Pages

Thursday, August 31, 2023

How to check database startup time ?

How to check database startup time ?


set pages 9999 lines 300
col open_mode for a10
col host_name for a20
select name db_name,instance_name,host_name,database_role,open_mode,version db_version,logins,
to_char(startup_time,'dd-mon-yyyy hh24:mi:ss') "db up time" from v$database,gv$instance;

No comments:

Post a Comment