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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle performance

Re: Oracle performance

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 11 Oct 2007 15:01:50 GMT
Message-ID: <yVqPi.235019$zz2.130133@newsfe12.phx>


rogv24_at_yahoo.com wrote in
news:1192114370.994565.305400_at_19g2000hsx.googlegroups.com:

> On Oct 11, 9:12 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:

>> On Oct 11, 7:56 am, sybrandb <sybra..._at_gmail.com> wrote:
>>
>>
>>
>>
>>
>> > On Oct 11, 4:54 am, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
>>
>> > > rog..._at_yahoo.com wrote in news:1192048135.946395.141040
>> > > @o3g2000hsb.googlegroups.com:
>>
>> > > > There is a sql script that updates a file and it took 20
>> > > > minutes
>> > > > about 10 days ago.
>>
>> > > > With a few more records that are updated it too 190 minutes
>> > > > on the
>> > > > same server.
>>
>> > > > Can any one think what could possibly could cause this?
>> > > > thanks.
>>
>> > > My blue 2-door car used to be fast & now it goes slow.
>> > > Can any one think what could possibly could cause this?
>>
>> > Did you put a brick on the brakes?
>>
>> > --
>> > Sybrand Bakker
>> > Senior Oracle DBA
>>
>> Geez, the reason is obvious:
>>
>> The atmospheric conditions in Zimbabwe no longer favor blue, two-door
>> vehicles, therefore all such vehicles in Duluth will be travel
>> slower.
>>
>> David Fitzjarrell- Hide quoted text -
>>
>> - Show quoted text -
> 
> 
> 
> What has the operating system go to do with this???????  What has the
> code go to do with this??????  Even if I give you this info will you
> be able to tell me why its so slow????
> 
> 

Without fact, the best that can be done is random guesses. To obtain facts enable SQL_TRACE & run the results thru TKPROF in order to see where the time is being spent.

Post the EXPLAIN PLAN.

Are statistics current on both table & indexes? Received on Thu Oct 11 2007 - 10:01:50 CDT

Original text of this message

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