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 JANUARY 30, 2022
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.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |