Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Performance issues

Nirmalkumar
Frequent Advisor

Performance issues

Hi all,

we merged two databases in produuction environment.After merging the databases the performance is very slow..

please suggest me what are the ways to analyse the problem and resolve it..

Is it possible to analyse the performance using quest software .if so,please provide the deatils regarding how to configure quest software and how to analyse the performance issue.

Thanks,
Nirmal.
2 REPLIES
Juan_20
Advisor

Re: Performance issues

Hi
Please post your server and SAN specs and $ORACLE_HOME/dbs/init$SID.ora and
admin/$SID/bdump/alert.log files.
jm
Yogeeraj_1
Honored Contributor

Re: Performance issues

hi Nirmal,

for performance monitoring you will require Statspack or Automatic Database Diagnostic Monitor (ADDM) (in oracle 10g).

With Quest software, you can generate a health check which will highlight all the problem areas as per the database configuration.

E.g. In Toad, you can do File->DBA->Health Check.


Hope this helps!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)