High Av Buf Wt
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 .
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 .
0