Re: dba_hist_log and log switch history

From: <stevedhoward_at_gmail.com>
Date: Sun, 19 Apr 2009 11:25:41 -0700 (PDT)
Message-ID: <50473982-a58a-4cff-909e-d06b756b0905_at_h2g2000yqg.googlegroups.com>

On Apr 19, 10:54 am, patrick boulay <boul..._at_free.fr> wrote:
> stevedhow..._at_gmail.com wrote:
> > On Apr 19, 8:14 am, patrick boulay <boul..._at_free.fr> wrote:
> >> yes, you are right , but I need to use dba_hist
> >> _log and dba_hist_snapshot ...
>
> > Why?  v$log_history gives you exactly what you are looking for.
>
> because I want to use data from AWR , not control files , and as there
> is a DBA_HIST_LOG table ...I would like to use it ;o)

Ahh, "like" is different than "need" :) Just do a natural join, and you should be good to go...

select begin_interval_time,status,group#,thread#,sequence   from dba_hist_log
  natural join dba_hist_snapshot;

HTH, Steve Received on Sun Apr 19 2009 - 13:25:41 CDT