Database Tuning (MOSC)

MOSC Banner

improve my number disk's access read 1M230 to retrieve 465 rows

edited Mar 23, 2013 5:26PM in Database Tuning (MOSC) 14 commentsAnswered
hello,
    I would like reduce the disk's read i have executed tkprof.

1 - i see tkprof's report and I see disk 1018569 and 1234680 for retrieve 465 rows. and CPU 26.36
how may I improve it ? i suppose that my statistics are correct but I am not sur. How may i control ?
afterwards maybe I can improve by histogramme, how may I to do ?
what do you think about it ? or have an other solution to improve it ?

2 - I see this next and i would understand the signification :
 
  db file scattered read                      99261        0.00          3.90
  db file sequential read                     19442        0.01          0.13

best regards
JP


call     count       cpu    elapsed       disk      query    current        rows

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