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: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Thu, 11 Oct 2007 15:07:57 GMT
Message-ID: <h%qPi.9345$GO5.1960@edtnps90>


<rogv24_at_yahoo.com> wrote in message
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????
>

To use the car analogy: going from a paved road to a potholed gravel road will make your car go a lot slower, even though you are driving the same road (ie quey statement). So yes, potentially the OS could be a problem.

-- 
Terry Dykstra 
Received on Thu Oct 11 2007 - 10:07:57 CDT

Original text of this message

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