X$ changes in 9i

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Mon, 26 Jul 2004 11:00:59 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93BAF@qtiexch2.qgraph.com>

Hey all,

I've just tried running a slightly modified version of:

http://www.ixora.com.au/scripts/sql/response_time_breakdown.sql

...on our month-old 9.2.0.5.0 instance on HP/UX 11i (I added "jobq slave = waits" to the list of idle waits from d.kslednam). However, it's = telling me that our queries have waited 55 *years* for db file = sequential read. I know we need to reduce our I/O, but come on!

I've looked on MetaLink for bugs/notes/articles and in some archives, = but nothing really pops up. I vaguely remember mention of UOM changes = (seconds/centiseconds/etc) in some version of Oracle's internals, but I = couldn't find anything on that either.

I know Mr. Adams has not been able to update his site for 9i/10g, but I = was hoping to check this out after our 9i upgrade. (I know, I know. = It's not a Method R query. We're not there just yet...)

TIA,
Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA


----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Jul 26 2004 - 10:59:03 CDT