Database Tuning (MOSC)

MOSC Banner

I look after my database and I see Wait time very high

edited Nov 15, 2011 4:06AM in Database Tuning (MOSC) 6 comments
Hello gurus,

      I look after my database on my server of production and I see :

That I have very high time / transaction for db file sequentiel read(21.43s)/txn and db file scatterred read (60.88s)/txn.

SQL*Net message to client766,665 0052.82
direct path read temp268,523 0018.50

SQL*Net message from client

769,543 164,76821453.02

1 - what do you think ?

2 - How can I improve ? ( Reorganize my tables of my schema ) maybe change my type of statistics.

Thank you for your advices ?

best regards

JP

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read311,023 354121.43
db file scattered read

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