Database Tuning (MOSC)

MOSC Banner

High Av Buf Wt

edited Aug 4, 2014 8:52AM in Database Tuning (MOSC) 13 commentsAnswered
 Hi,
We are doing ETL Workloads Testing between different Exadata Box . Here on AWR i found Differences .

On both cases we found difference of 8 hours when we load Data using ETL.

I am also attaching the AWR Reports also of both Cases.

Bad One(Data Guard) :-


Tablespace        Filename                                                Reads                Av Reads/s        Av Rd(ms)        Av Blks/Rd        Writes        Av Writes/s        Buffer Waits        Av Buf Wt(ms)


DPODS_DATA        +SHR_DATA/dpodst01/datafile/dpods_data.367.823367255        14,564,582        4,065                1.74                1.00                23,705,837        6,617        1,058,570        12.33



Good One (Non-Data Guard):-
DPODS_DATA        +SHR_DATA/dpodst02/datafile/dpods_data.367.823628557        6,186,769        215        1.89        24.84        12,995,893        451        3,401,375        3.04

I need to understand the difference what's going on these cases  why both different when on the same Exadata Boxes .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center