Re: Measuring the impact of Redo Log change

I think the average wait time of "log file sync" is also a good statistics to look at.

On Tue, Sep 9, 2008 at 12:32 PM, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com
> wrote:

> We recently (today) moved the redo logs from RAID5 to RAID1+0.
>
> The obvious reason of doing this is to make things better in terms of
> performance, as RAID1+0 is better suited for read/writes. Someone pls
> correct me if that's not true.
>
> What are different ways to measure the impact of this change?
>
> The platform is AIX, DB is 10.2.0.3 and DB size is 55TB, and 2TB redo is
> generated each day. There are plans underway to reduce the redo generation
> using direct path etc. (so let's not get diverted by that).
>
> We can try measuring the wait event stats using AWR, session stats etc.,
> but what exactly to look for? 'log file switch completion', 'log file
> sync', are some things that come to mind - what else?
>
> Thanks,
> Deepak
>
>
>

-- 
Eagle Fan

Sr. DBA

--
http://www.freelists.org/webpage/oracle-l