ORACLE-Log Files

Oracle log files include warning logs, trace logs, and audit logs,
Redo logs: Archive logs.
Warning log: the alert log, which corresponds to the background_dump_dest set in the system initialization parameter file.
View the location of the log file:
After connecting with the SYS User:
 
SQL> show parameter dump
NAME TYPE VALUE
-----------------------------------------------------------------------------
Background_core_dump string partial
Background_dump_dest string/data1/oracle/admin/tsd
Boss/bdump
Core_dump_dest string/data1/oracle/admin/tsd
Boss/cdump
Max_dump_file_size string UNLIMITED
Shadow_core_dump string partial
User_dump_dest string/data1/oracle/admin/tsd
Boss/udump
 
The location of background trace files is determined by the background_dump_dest parameter.
Background trace files records the log files of background processes. logs are recorded when background processes encounter errors.
User_dump_dest determines the location of user trace files
Logs are logged when a process connection error occurs. The size is determined by max_dump_file_size.
Set the record for each user connection operation:
Alter session set SQL _TRACE = TRUE
 
 
This article is from the "Technical Achievements" blog