Database Tuning (MOSC)

MOSC Banner

Wait event

edited Jun 29, 2011 3:30AM in Database Tuning (MOSC) 2 commentsAnswered
 Hi, I am getting I/O slave wait,db file sequential read,db file scattered read gc cr multi block request while session is gathering table's index statistics.
How I can speed up this process as it is taking very long time.
DB=10.2.0.4 RAC
OS=IBM AIX 5.3

EVENT                                                            TIME_WAITED
---------------------------------------------------------------- -----------
i/o slave wait                                                       4194035
db file scattered read                                               4012774
CPU used by this session                                             3437386
gc cr multi block request                                             291818
db file sequential read                                               138597
direct path read temp                                                  91712
db file parallel read                                                  30006
gc cr grant 2-way                                                       6608
row cache lock                                                          5699
gc current grant 2-way                                                  3824
gc current block 3-way                                                  1257

EVENT                                                            TIME_WAITED

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