Description: Find the date when the Oracle Instance was last started
Code:
select to_char(TO_DATE(VALUE,'J'),'mm/dd/yyyy') startDate
from v$instance
where KEY LIKE 'STARTUP TIME - J%';
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 ...
-
Symptoms When running Create Accounting using SLA with the profile option FA: Use Workflow Account Generation set to Yes at the Site level,...
-
Mastering ORA-00054: Resolving the "Resource Busy" Error The ORA-00054 error, often accompanied by the message "resource b...
-
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