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 -----------------------------------------------------------------