Oracle trace file

Oracle trace file 11g: Oracle alter file before 11g is in the bdump directory. Oracle 11g provides Alert logs in XML and traditional text formats. The location of the new oracle 11g log is determined by the Automatic Diagnostic Respository (ADR. You can use the new initialization parameter DIAGNOSTIC_DEST to control the location of the adr base. If the location of the initialization parameter is not set and the ORACLE_BASE environment variable is set, ORACLE_BASE is not set, then ORACLE_HOME/log shows the location of DIAGNOSTIC_DEST [SQL] SQL> show parameter DIAGNOSTIC_DEST; name type value types ----------- ----------------------- diagnostic_dest string/u01/app/oracle SQL> query the location of two types of logs to query the directory of the xml file [SQL] SQL> select value from v $ diag_info where name = 'diag Alert '; VALUE limit/u01/app/oracle/diag/rdbms/orcl/ORCL/alert query the directory of the text file [SQL] SQL> select value from v $ diag_info where name = 'diag Trace '; VALUE logging/u01/app/oracle/diag/rdbms/orcl/ORCL/trace can also query background_dump_dest to view oracle Text logs [SQL] SQL> sho parameter background_dump_dest NAME TYPE VALUE revoke ----------- -------------------- background_dump_dest string/u01/app/oracle/diag/rdbms/orcl/ORCL/trace or SQL> select value from v $ parameter where name = 'background _ dump_dest '; [SQL] VALUE ----------------------------------------------------------------------/u01/app/oracle/diag/rdbms/orcl/ORCL/trace