| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: X$ changes in 9i
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.
> 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
> -----------------------------------------------------------------
>
-- 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:15:49 CDT
 |
 |