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 FEBRUARY 19, 2019
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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 22.214.171.124.0 - 64bit Production With the Partitioning and Automatic Storage Management options ORACLE_HOME = /opt/oracle/product/126.96.36.199 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