Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: X$ changes in 9i
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
-- 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
![]() |
![]() |