Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Database formed a very large trace file (New)

edited Jan 4, 2016 9:55AM in Core Concurrent Processing - EBS (MOSC) 9 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center