Kindly query
select * from V$DIAG_INFO;
Look for value for Diag Trace
or use below query
SQL> select * from V$DIAG_INFO where NAME='Diag Trace';
INST_ID NAME VALUE CON_ID
---------- ---------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
1 Diag Trace /oracle/ASHISHDB/orabase/diag/rdbms/ashishdb1/ASHISHDB1/trace
select * from V$DIAG_INFO;
Look for value for Diag Trace
or use below query
SQL> select * from V$DIAG_INFO where NAME='Diag Trace';
INST_ID NAME VALUE CON_ID
---------- ---------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
1 Diag Trace /oracle/ASHISHDB/orabase/diag/rdbms/ashishdb1/ASHISHDB1/trace
No comments:
Post a Comment