Some Base table queries

SQL>select name,open_mode,log_mode from V$database;

SQL>select instance_name,status from V$instance;

SQL>select name from V$datafile;

SQL>select name from V$controlfile;

SQL>select member from V$logfile;

SQL>select name from V$tempfile;

SQL>select name from V$tablespace;

SQL>select * from V$diag_info;  --->with this query we can see the path of the alert log file.

 

>tail -f alert_hrms.log  -->to monitor the alert log file.