This content has been marked as final. Show 9 replies
Please refer.1 person found this helpful
I sure seem to see a UDUMP in the output you posted1 person found this helpful
user_dump_dest string /u01/app/oracle/diag/rdbms/edm p2/edmp2/trace
udump bdump are replace with diagnostic_dest in 11g1 person found this helpful
background_dump_dest 11.1 DEPRECATED replaced by "diagnostic_dest"
user_dump_dest 11.1 DEPRECATED replaced by "diagnostic_dest"
core_dump_dest 11.1 DEPRECATED replaced by "diagnostic_dest"
Edited by: Kh$n on Apr 25, 2013 11:11 PM
Hi,1 person found this helpful
What's your DIAGNOSTIC_DEST ?
You can check by follows.
# check Diag Trace.
SQL> select * from v$diag_info;
Edited by: asahide on 2013/04/26 15:11
It's been replaced with the Trace folder under Diag .1 person found this helpful
I thank you all,
There so lots of folders in diag which are confusing. :(
So where can I find my output for > ALTER SYSTEM SET SQL_TRACE = TRUE SCOPE=MEMORY;
SQL> / 1 Diag Enabled TRUE 1 ADR Base /u01/app/oracle 1 ADR Home /u01/app/oracle/diag/rdbms/edmp2/edmp2 1 Diag Trace /u01/app/oracle/diag/rdbms/edmp2/edmp2/trace 1 Diag Alert /u01/app/oracle/diag/rdbms/edmp2/edmp2/alert 1 Diag Incident /u01/app/oracle/diag/rdbms/edmp2/edmp2/incident 1 Diag Cdump /u01/app/oracle/diag/rdbms/edmp2/edmp2/cdump 1 Health Monitor /u01/app/oracle/diag/rdbms/edmp2/edmp2/hm 1 Default Trace File /u01/app/oracle/diag/rdbms/edmp2/edmp2/trace/edmp2_ora_16846.trc 1 Active Problem Count 0 1 Active Incident Count 0 11 rows selected.
The has been lots of "locking" transaction happening. Can I see it in OEM emca database control, or in the database level trace and tkfprof ?
75aae07c:13e44f1f938:email@example.com ffup553 26-abr-13 02:09:58 org.hibernate.util.JDBCExceptionReporter ERROR ORA-00054: recurso ocupado y obtenido con NOWAIT especificado o timeout vencido 18.104.22.168 -75aae07c:13e44f1f938:firstname.lastname@example.org ffup553 26-abr-13 02:09:58 com.smartmatic.sge.services.tickets.TicketManagementBean ERROR TaskInstance = 25840were not unassigned by actor = ffup553 10.0.0.12 22.214.171.124
Check Diag Trace /u01/app/oracle/diag/rdbms/edmp2/edmp2/trace
What are these lots *.trm files for?
It has 3 lines like