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
Subscribe to:
Post Comments (Atom)
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 ...
-
Mastering ORA-00054: Resolving the "Resource Busy" Error The ORA-00054 error, often accompanied by the message "resource b...
-
Symptoms When running Create Accounting using SLA with the profile option FA: Use Workflow Account Generation set to Yes at the Site level,...
-
Getting below error in EBS R12.1.3 in Oracle Database SMTP Error. Getting below error while trying to send email in XXXXXXX instance ...
No comments:
Post a Comment