Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Database performance problem

Highlighted
KeanChen
Super Collector

Database performance problem

Hi,

 

What parameter turn on in the server.conf, but when I have database performance problems?

 

Any Idea?

 

Best Regards.

2 REPLIES
AlexSavencu
Honored Contributor

Re: Database performance problem

Hi,

 

what kind of database performance problems are you facing? How did you investigate these problems?

 

First of all, you should make sure that all Oracle parameters are set as per the HP documentation - check the Installation Admin Guide and the Deployment Best Practices Guide.

 

cheers

alex


--remember to kudos people who helped solve your problem
Mohit_Agrawal
Frequent Visitor

Re: Database performance problem

Hi Kean,

 

The kBuildStats.sh script instructs Oracle to gather statistics about the PPM Center database schema. This information can be very important in improving the overall performance of PPM Center.

 

you can use the dbms_stats package to gather additional statistics. Oracle provides this package as part of the database. To gather additional statistics, run the following script.

 

begin

dbms_stats.gather_schema_stats (ownname => <PPM_User>,

cascade => TRUE,

method_opt => 'FOR ALL COLUMNS SIZE SKEWONLY'

);

end;

/

 

You typically run the dbms_stats package as the SYSTEM user. To run it as a PPM Center user, grant the privilege to run the package by running the following SQL statement as the SYSTEM user from an SQL*Plus session.

 

grant execute on dbms_stats to <PPM_User>;

 

The first time you run the dbms_stats package, use method_opt => 'FOR ALL COLUMNS SIZE SKEWONLY'. After the system has been up and running for a while, use method_opt => 'FOR ALL COLUMNS SIZE AUTO'.

 

Please work with your DBAs for the same..

 

Thanks!!
Mohit Agrawal
Please mark it as accepted solution, if this resolves your query and don't forget to give KUDOS :)

//Add this to "OnDomLoad" event