Posts

1 .C URRENT DATE and TIME : Select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') "Current Date/Time" from dual; 2. DATABASE Information: select INSTANCE_NAME,host_name,version,startup_time,status,INSTANCE_ROLE, log_mode from v$instance, v$database ; 3.Backup check: To check rman backup is running or not Ps –ef|grep rman To check export backup is running or not   Ps –ef|grep exp 4.  Check the file system utilization.                      >df   -h                      ------------ à Linux                      > bdf or df -k             ----------- à HPUX        ...