Skip to main content

SQL Queries to find ORACLE Log Directories

Below are the some of the sql queries which helps to find the log directories in oracle database server.

select * from v$logfile;

select * from v$log_history;

show parameter debug;

select * from dba_profiles;

select profile,resource_name,resource_type,limit from dba_profiles;

select window_name, repeat_interval, duration from dba_scheduler_windows where window_name like 'WEEK%';

Comments