Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to collect DB stats from 10g database

700386Sep 2 2009 — edited Sep 2 2009

Hi All,

We have a production Oracle 10.1.0.5.0 database. We are facing performance issue in the application side. So we are in process of analysing the performance issues in both database and application side. Application vendor is asking for DB stats of the primary schema.
I dont know anything about database performance tuning activities like collecting DB stats, using Statspacks etc...

Kindly help me to understand about DB stats and what is the best way collect the required DB statistics information.

Thanks in advance.

Aruna

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2009

Added on Sep 2 2009

#general-database-discussions

10 comments

1,334 views