Skip to Main Content

SQL & PL/SQL

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!

Performance tuning

886282Jun 14 2013 — edited Jun 14 2013

version:oracle 10g

Hi Experts,

I have given a task in the organization to find out myself which are the procedures or functions or packages(containing procedures) or sql statements causing performance degradation

and then to increase the performance.

So could you please help me with the first part of finding the procedures or functions or sqls taking long time in the database. So that I can fine tune them accordingly.

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2013
Added on Jun 14 2013
3 comments
206 views