Raafat Mohamed

Senior Linux Administrator

  • About Me
Menu
  • About Me
Determine the Oracle Database Uptime
  • Determine the Oracle Database Uptime

    You can check the Oracle DB uptime by run one of the following commands :

    SELECT host_name, instance_name,
           TO_CHAR(startup_time, 'DD-MM-YYYY HH24:MI:SS') startup_time,
           FLOOR(sysdate-startup_time) days
    FROM   sys.v_$instance;
    
    

    OR

    SELECT TO_CHAR(logon_time, 'DD-MM-YYYY HH24:MI:SS')
    FROM v$session 
    WHERE program LIKE '%PMON%'

    Categories: Oracle

    ORA-28001 the password has expired Check if Archivelog mode is enabled

    Comments are currently closed.

Recent Posts
  • Exalogic Power On Sequence
  • Exalogic Power Off Sequence
  • Clear Winbind cache
  • ifconfig not found in CentOS 7 Minimal Install
  • How to install Vmware Vcenter server step by step
Categories
  • Apache (2)
  • Benchmarking (1)
  • CitrixXen (3)
  • Cpanel (5)
  • DBs (1)
  • DNS (2)
  • Exim (3)
  • Fireawall (3)
  • IIS (1)
  • Linux (21)
  • MSSQL Server (1)
  • Mysql (10)
  • Network (2)
  • Oracle (6)
  • Others (2)
  • Plesk (3)
  • Storag (3)
  • Uncategorized (2)
  • Virtualization (4)
  • Windows (9)
  • Xen (4)
  • Zpanel (1)
Archives

Join the mailing list

Your Name:
E-mail:*
Type the characters you see here:

Copyright © 2015 Raafat IT blog

Theme created by PWT. Powered by WordPress.org