Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> IO wait problem more info

IO wait problem more info

From: <oracle-l-bounce_at_freelists.org>
Date: Fri, 16 Sep 2005 09:58:55 -0700
Message-ID: <EF25DB6D87DD1A469C80A312C63C3B4C047709C9@SVR-ORW-EXC-07.mgc.mentorg.com>


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
------- ------------ -------- ------------ ------------ -----------

Received on Fri Sep 16 2005 - 12:01:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US