Skip to Main Content

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 use STATSPACK

584465Aug 8 2008 — edited Aug 8 2008
I want or use STATSPACK utility for perfomance tuning.

For example how can we use/run statspack for following query

Select emp_name,Salary from emp_table
where emp_name='Alex' order by emp_name;

What will be the result and how can we tune after the result

Oralce 9i and Solaris 9

Could you brief the steps....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2008
Added on Aug 8 2008
3 comments
540 views