Showing posts with label Oracle startup time. Show all posts
Showing posts with label Oracle startup time. Show all posts

Friday, November 13, 2009

Database uptime and startup time

SELECT 'Hostname : ' || HOST_NAME "Host name",
'Instance Name : ' || INSTANCE_NAME "Instance Name",
'Started At : ' || TO_CHAR(STARTUP_TIME, 'DD-MON-YYYY HH24:MI:SS') "Startup Time",
'Uptime : ' || FLOOR(SYSDATE - STARTUP_TIME) || ' days(s) ' ||
TRUNC(24 *
((SYSDATE - STARTUP_TIME) - TRUNC(SYSDATE - STARTUP_TIME))) ||
' hour(s) ' || MOD(TRUNC(1440 * ((SYSDATE - STARTUP_TIME) -
TRUNC(SYSDATE - STARTUP_TIME))),
60) || ' minute(s) ' ||
MOD(TRUNC(86400 *
((SYSDATE - STARTUP_TIME) - TRUNC(SYSDATE - STARTUP_TIME))),
60) || ' seconds' "Uptime"
FROM V$INSTANCE

Troubleshooting ACFS-07981: Metadata Validation Errors

  Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...