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 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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.