RE: What can cause boost in LIO/PIO?

I just got a call from the S/A that the copy completed. After looking back at Spotlight I asked "At 1:00, right?". Sure enough. So at least that part's solved. As to why/how it started the same time as the DBMS_JOB? I'm willing to let that be a mystery pondered on over beers for years and years.

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 12:58 PM
> To: Jesse, Rich; ''Multiple recipients of list ORACLE-L ' '
> Subject: RE: What can cause boost in LIO/PIO?
>
>
> makes sence to me... I've seen an analyze, if it takes a
> long time to run,
> cause odd things to happen to SQL that starts running in the
> middle of the
> analyze process.
>
> The SAN rebuild certainly sounds like a likley suspect.
>
> RF
>
>
> -----Original Message-----
> From: Jesse, Rich
> To: Jesse, Rich; Freeman Robert - IL; 'Multiple recipients of
> list ORACLE-L
> '
> Sent: 6/20/2003 12:52 PM
> Subject: RE: What can cause boost in LIO/PIO?
>
> [deft backpedaling]
>
> OK, now I think it IS the SAN. The S/A handling the SAN is helping us
> with
> our backup scenario so he's reorganizing some drives on the SAN. At
> about
> the same time he started the reorg (highly drive-intensive), my
> aggregate
> PIO rate dropped from almost 10K/s to less than 2K/s. And the LIOs
> dropped
> similarly, while the event waits increased.
>
> I'm thinking that the impact of the reorg on the SAN caused the wait
> events
> for the PIOs to grow (from 3.5K/s to 4.7K/s). This longer
> wait in turn
> caused a decrease in LIOs because the processes are too busy
> waiting to
> generate the IO requests.
>
> This explains everything except that the lack of contention
> to cause the
> IOs
> to boost in the first place happened at the same time as the first run
> of
> the DBMS_JOB at 5:00 AM. Coincidence?
>
> How's that sound?
>
> Rich
>
> Rich Jesse System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
>
>
> > -----Original Message-----
> > From: Jesse, Rich
> > Sent: Friday, June 20, 2003 12:32 PM
> > To: 'Freeman Robert - IL'; 'Multiple recipients of list ORACLE-L '
> > Subject: RE: What can cause boost in LIO/PIO?
> >
> >
> > 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).