Re: dba_hist_log and log switch history
From: <srivenu.kadiyala_at_gmail.com>
Date: Sun, 19 Apr 2009 00:10:08 -0700 (PDT)
Message-ID: <1995a388-a054-4f7f-81ff-c4211c36b106_at_u9g2000pre.googlegroups.com>
You can query V$LOG_HISTORY
Date: Sun, 19 Apr 2009 00:10:08 -0700 (PDT)
Message-ID: <1995a388-a054-4f7f-81ff-c4211c36b106_at_u9g2000pre.googlegroups.com>
You can query V$LOG_HISTORY
example - select sequence#,to_char(first_time,'dd-mon-yy hh24:mi:ss') from v$log_history order by 1;
regards
srivenu
Received on Sun Apr 19 2009 - 02:10:08 CDT