|
|
|
Database Details
| select |
NAME,
CREATED,
LOG_MODE,
CHECKPOINT_CHANGE#,
ARCHIVE_CHANGE# |
| from |
sys.v_$database; |
| select |
to_char(to_date(to_number(in1.VALUE), 'J') +
(to_number(in2.VALUE) / (24 * 60 * 60)) ,'MM/DD/YYYY
HH24:MI:SS'),
round(sysdate - to_date(to_number(in1.VALUE), 'J')
-
(to_number(in2.VALUE) / (24 * 60 * 60)),2),
round(((sysdate - to_date(to_number(in1.VALUE),
'J') -
(to_number(in2.VALUE) / (24 * 60 * 60))) * 24 ),2) |
| from |
sys.v_$instance in1, sys.v_$instance in2, sys.v_$database |
| where |
in1.KEY = 'STARTUP TIME - JULIAN' |
| and |
in2.KEY = 'STARTUP TIME - SECONDS'; |
|
