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