SQL> select instance_name,status,to_char (startup_time,'dd-mon-yyyy hh24:mi:ss') from gv$instance order by instance_name;
INSTANCE_NAME STATUS TO_CHAR(STARTUP_TIME
---------------- ------------ ----------------------------------------------------
mtlive1 OPEN 13-feb-2020 07:05:23
mtlive2 OPEN 13-feb-2020 07:01:51
Happy Learning.
