Re: Database Tuning Question

Your application could be 'sharing' data blocks which other users have pulled into the buffer pool during the week-days (using their own server 'shadow' process (except MTS)).

If db_block_buffers is too small and it is only your app that is needing buffers at the weekend, then its server 'shadow' process (again assuming no MTS) has to go to disk slightly more often (as no one else caused the blocks you need to be in the buffer cache), decreasing your throughput.

What do you think?

David P.

Oracle Certified DBA.

Dan White wrote:
>
> Nope the progragram was running alone....nothing else running
> mgumbs <mgumbsNOmgSPAM_at_hotmail.com.invalid> wrote in message
> news:23ddb7e0.9d6784d2_at_usw-ex0102-015.remarq.com...
> > Seems strange.
> >
> > The only explination i can give is that on the weekend, a
> > dataload may have been going on and an index or two disabled to
> > allow the dataload to go faster. The index which was disabled
> > is used in your code hence runs slower on the weekend.
> > The disabled index is then re-enabled later on in the weekend.
> >
> > Total stab in the dark but you never know. ;-)
> >
> > M
> >
> > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> > The fastest and easiest way to search and participate in Usenet - Free!
> >
  Received on Tue Apr 04 2000 - 00:00:00 CDT