7.4 Performance Tuning

When tuning objects, the following items need to be addressed:

• How objects and object views consume CPU and memory resources during runtime

• How to monitor memory and CPU resources during runtime

• How to manage large numbers of objects

Some of the key performance factors are the following:

• DBMS_STATS package to collect statistics

• tkprof to profile execution of SQL commands

• EXPLAIN PLAN to generate the query plans

  See Also:

  Oracle Database SQL Tuning Guide for details on measuring and tuning the performance of your application