Several Trace Files Generated By Database Foreground Processes Showing: "TTX id1: nnnnnn id2: nnnnn ret: n waitopt: n" (Doc ID 1359902.1)

Last updated on APRIL 01, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 01-Apr-2013***

Symptoms

You notice lots of trace files from the regular database foreground processes have been generated at the database diagnostic directory (former USER_DUMP_DEST), and the same trace files are filed up with  following pattern:

Trace file /opt/oracle/admin/TEST/diag/rdbms/test/TEST/trace/TEST_ora_11143.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
ORACLE_HOME = /opt/oracle/product/11.2.0.2
System name: SunOS
Node name: node_test
Release: 5.10
Version: Generic_144488-01
Machine: sun4u
Instance name: TEST
Redo thread mounted by this instance: 1
Oracle process number: 81
Unix process pid: 11143, image: oracle@node_test


*** 2011-04-19 10:24:36.548
*** SESSION ID:(259.6311) 2011-04-19 10:24:36.548
*** CLIENT ID:() 2011-04-19 10:24:36.548
*** SERVICE NAME:(TEST.oracle.com) 2011-04-19 10:24:36.548
*** MODULE NAME:(test@test (TNS V1-V3)) 2011-04-19 10:24:36.548
*** ACTION NAME:() 2011-04-19 10:24:36.548

TTX id1: b0013 id2: 600a4 ret: 0 waitopt: 2
TTX id1: 60021 id2: 7ac6 ret: 0 waitopt: 2
TTX id1: b0015 id2: 60087 ret: 0 waitopt: 2
TTX id1: 5001f id2: 7a8c ret: 0 waitopt: 2
TTX id1: b000d id2: 60089 ret: 0 waitopt: 2
TTX id1: 10005 id2: 7ac9 ret: 0 waitopt: 2
TTX id1: b0011 id2: 60075 ret: 0 waitopt: 2
TTX id1: 8001c id2: 7ee3 ret: 0 waitopt: 2
...
...
...

Changes

This problem has been introduced with patch-set 11.2.0.2.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms