Re: X$ changes in 9i
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Jul 2004 19:17:00 +0300
Hi!
Yep, the wait times are in microseconds starting from 9i, but if you modify
the script, remember that the CPU times which are got from
v$sysstat/x$ksusgsta table are still in centiseconds.
Tanel.
----- Original Message -----
From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, July 26, 2004 7:07 PM
Subject: 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
