My Oracle Support Banner

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 to [Release 11.2]
Information in this document applies to any platform.


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 - 64bit Production
With the Partitioning and Automatic Storage Management options
ORACLE_HOME = /opt/oracle/product/
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:( 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


This problem has been introduced with patch-set


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.