Database formed a very large trace file
edited Jan 12, 2016 10:03AM in Complex Maintenance, Repair and Overhaul - EBS (MOSC) 2 commentsAnswered
Dear Expert,
It happened a long time not every day occurrence .
Formed a very large * .trc file ( 7.2G ) contained in the directory $ORACLE_HOME/admin/PROD_erpdb/diag/RDBMS/prod/PROD/ trace.
To handle this case I restart Cuncurent Manager at EBS APPS Server, and move the trace files which have a large capacity to another mount point.
Why does this happen and how to cope with that does not happen again ?
--------------------------------------------------------------------------------------------------------------
Iam Try to Run this script :
tkprof PROD_ora_6974_APPS.trc PROD_ora_6974_APPS explain=apps/proaction2012 sort='(prsela,exeela,fchela)' print=10
And attach with name
0