Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Tuning Question

Re: Database Tuning Question

From: Dan White <dwhite_at_vrinter.net>
Date: 2000/04/03
Message-ID: <8cb39103pq@enews2.newsguy.com>#1/1

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 Mon Apr 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US