Re: Why application is becoming slow ?

MotoX is right, a number of things can be the result of this: 1) table rows are chaining (fragmentation problems all over the place) 2) As more data is being added without any of it being tossed out, the SGA may have to be re-configuired. 3) Maybe more traffic on your network?? Are you guys downloading a lot of Porn?? <joking>

My suggestion is to hire a consultant to view your current status and tune where needed.

Satar Naghshineh
In article <908293419.11167.0.nnrp-05.c2de712e_at_news.demon.co.uk>,   "MotoX" <rat_at_tat.a-tat.com> wrote:
> It's called "Lack of design." Go back and do some. And try putting
> "Performance Goals" on page one of your design doc., not on the final page
> called "Into Production".
>
> Sorry for being so harsh, but if you are this much out of your depth... Get
> a consultant in to review what you've got and help you get to where you want
> to be. Your application could be slow for any number (try 1000+) reasons,
> and no-one here will be able to tell you exactly why (even if they think
> otherwise... :-)) And get some training - on both Oracle and your server,
> and it's OS.
>
> Sure, you can re-analyze, you can monitor SGA stats, I/O stats, etc., etc.,
> but they will not tell you the *cause* of your problems, just the
> *symptoms*.
>
> Just my rant. Other's may disagree.
>
> MotoX.
>
> Wang Jing wrote in message <362342B0.F559F6E9_at_usa.net>...
> >Hello,
> >
> >My application run well before. But with much more data inserted. It is
> >becoming slow and slow? What's the reason? and how to solve?
> >
> >Thanks
> >
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 13 1998 - 14:31:39 CDT