Re: Performance issue
Date: Fri, 20 Mar 2009 22:27:24 -0700 (PDT)
Message-ID: <93b893c2-62d5-42ce-833d-4e43955bc050_at_h20g2000yqj.googlegroups.com>
On Mar 17, 4:09 am, gar..._at_jamms.org wrote:
> On 17 Mar, 07:27, Jenny <jjohni..._at_gmail.com> wrote:
>
> > our database oracle 9i is running on tru64. Db's performance degrades
> > as the time goes on, later we bounce the DB and also restarts the
> > machine. after restart the performance increases drastically and as
> > time goes performance degrade.
> > Can anyone tell what the problem is and also a solution 4 it
>
> Oracle and O/S versions? Hardware configuration?
>
> -g
I concur, some versions of "9i" have memory leaks, some of which are platform and usage specific. Some mid-versions have strangeness with pga_aggregate and other things. When people ask for versions, you need to be specific, like 9.2.0.6. See http://www.dbaoracle.net/readme-cdos.htm for some other hints about dealing with this group.
There are also other things that can be going on, like sessions being killed improperly, shared pool fragmentation, OS I/O buffer fragmentation (well, dunno about true64 with that one), sessions not being killed when they should be, batch programs not completing fast enough and piling on each other, I/O issues, dying hardware, and on and on. We really shouldn't be guessing, there are tools available to figure it out. The basic question, what exactly do you mean by performance degradation and what is the 'puter waiting on?
jg
-- _at_home.com is bogus. http://www3.signonsandiego.com/stories/2009/mar/20/1m20money233432-money-shower-brings-rush-hour-halt/?uniontribReceived on Sat Mar 21 2009 - 00:27:24 CDT