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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: X$ changes in 9i

RE: X$ changes in 9i

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 26 Jul 2004 12:07:31 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09660C37@bosmail00.bos.il.pqe>


First guess, this is due to timings in 9i being microsecond rather than centisecond. You probably need to shave a few zeros off....;-)

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jesse, Rich Sent: Monday, July 26, 2004 12:01 PM
To: ORACLE-L (E-mail)
Subject: X$ changes in 9i

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
=3D

waits" to the list of idle waits from d.kslednam). However, it's =3D telling me that our queries have waited 55 *years* for db file =3D 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, =
=3D

but nothing really pops up. I vaguely remember mention of UOM changes =
=3D

(seconds/centiseconds/etc) in some version of Oracle's internals, but I
=3D

couldn't find anything on that either.

I know Mr. Adams has not been able to update his site for 9i/10g, but I
=3D

was hoping to check this out after our 9i upgrade. (I know, I know. =
=3D

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
-----------------------------------------------------------------
----------------------------------------------------------------
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 - 11:04:50 CDT

Original text of this message

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