Re: Oracle performance

On Oct 11, 9:52 am, rog..._at_yahoo.com wrote:
> 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????- Hide quoted text -
>
> - Show quoted text -

Possibly, however why it's 'slow' is a function of any number of things. What we need to accurately diagnose the 'problem' is:

Oracle version
State of statistics
Code used for the update
Explain plan for this code
Statspack information during a run of this code

You can't expect your mechanic to diagnose a problem with your car based upon irrelevant information such as the color and the body style. This is, effectively, what you've supplied in this post: essentially irrelevant 'information' and a statement that the update is 'slow'.

If you want an answer then provide that which is requested (see the list above). If you can't be bothered to supply such details then this isn't a pressing problem for you to address.

And biting the hand which you expect to feed you is irresponsible and foolish. Especially when you're asking after a topic and a methodology with which you're apparently unfamiliar.

David Fitzjarrell Received on Thu Oct 11 2007 - 10:00:18 CDT