X$ changes in 9i
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: "ORACLE-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Jul 2004 11:00:59 -0500
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 =
waits" to the list of idle waits from d.kslednam). However, it's =
telling me that our queries have waited 55 *years* for db file =
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, =
but nothing really pops up. I vaguely remember mention of UOM changes =
(seconds/centiseconds/etc) in some version of Oracle's internals, but I =
couldn't find anything on that either.
I know Mr. Adams has not been able to update his site for 9i/10g, but I =
was hoping to check this out after our 9i upgrade. (I know, I know. =
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
-----------------------------------------------------------------
Other related posts:
