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