Friday, November 13, 2009

Oracle Instance last started

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%';

No comments:

Post a Comment

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 ...