Re: dba_hist_log and log switch history
From: patrick boulay <boulayp_at_free.fr>
Date: Sun, 19 Apr 2009 16:54:31 +0200
Message-ID: <49eb3b2d$0$5228$426a74cc_at_news.free.fr>
stevedhoward_at_gmail.com wrote:
> On Apr 19, 8:14 am, patrick boulay <boul..._at_free.fr> wrote:
>
> 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) Received on Sun Apr 19 2009 - 09:54:31 CDT
Date: Sun, 19 Apr 2009 16:54:31 +0200
Message-ID: <49eb3b2d$0$5228$426a74cc_at_news.free.fr>
stevedhoward_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) Received on Sun Apr 19 2009 - 09:54:31 CDT