Re: Performance issue
From: Ram <krishna000_at_gmail.com>
Date: Tue, 17 Mar 2009 02:51:33 -0700 (PDT)
Message-ID: <693c59f3-2438-4d2b-8597-b68aa50b8990_at_n33g2000pri.googlegroups.com>
On Mar 17, 12:27 pm, 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
Date: Tue, 17 Mar 2009 02:51:33 -0700 (PDT)
Message-ID: <693c59f3-2438-4d2b-8597-b68aa50b8990_at_n33g2000pri.googlegroups.com>
On Mar 17, 12:27 pm, 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
Hi,
You should look into session waits and more ever you should take statspack regularly and compare the performance . Find out the bottlenecks and fix the issues.
Regards
Bala Received on Tue Mar 17 2009 - 04:51:33 CDT