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
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2] Information in this document applies to any platform.
***Checked for relevance on 01-Apr-2013***
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 188.8.131.52.0 - 64bit Production With the Partitioning and Automatic Storage Management options ORACLE_HOME = /opt/oracle/product/184.108.40.206 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