Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> IO wait problem more info
Thanks for the suggestions yesterday. I've done more spelunking and
here is a real oddity:
Exerpts from tkprof for production and development. (production is the one running real slow) The thing I notice is that the disk numbers are about the same. Which is fine because the amount of data and the distribution is very close. But the query column is WAY off. (10X)
Any ideas?
Development section.
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
-------- ---------- ------- ----------- ------------- -----------
Here is the same section for Production:
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------------ -------- ------------ ------------ -----------
![]() |
![]() |