Only in part. It's an hourly complete rebuild of a mini-warehouse table (don't ask -- not my idea). It does do a few index creates and accompanying analyzes of those indexes and their table at the end of the procedure. I think this accounts for the very high PIO spikes at the end of every DBMS_JOB cycle, but I'm still not sure how it affected the other queries.
Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] > Sent: Friday, June 20, 2003 11:06 AM > To: Jesse, Rich; 'Multiple recipients of list ORACLE-L ' > Subject: RE: What can cause boost in LIO/PIO? > > > What was this 5am job? It wasn't an analyze was it? > > RF > > -----Original Message----- > From: Jesse, Rich > To: Multiple recipients of list ORACLE-L > Sent: 6/20/2003 11:29 AM > Subject: What can cause boost in LIO/PIO? > > Hey all, > > I'm testing out the max I/O thruput of an IBM FastT900 using a dual > 2.4GHz > w/1GB RAM on Win2K server (not my choice but it's just for testing) > running > Oracle 8.1.7. For one of my tests, I created the following > heirarchical > query: > > [yadda yadda yadda] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).