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

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...