DBA_HIST_DATABASE_INSTANCE

In 10g there is a view called DBA_HIST_DATABASE_INSTANCE which has database instance information. It has history on information such as instance startup time, last ASH sample id. Example: SQL> column startup_time format a35 SQL> alter session set nls_timestamp_format='DD-MON-YYYY HH24:MI:SS'; Session altered. SQL> SELECT startup_time, last_ash_sample_id FROM dba_hist_database_instance WHERE dbid = 1992878807 order by startup_time; STARTUP_TIME... Continue Reading →

Advertisements

Create a free website or blog at WordPress.com.

Up ↑