Oracle Notes‎ > ‎

Performance Tuning

Dynamic Performance Views
https://netfiles.uiuc.edu/jstrode/www/oraview/index.html

Plan Management:
http://www.oracle-base.com/articles/11g/SqlPlanManagement_11gR1.php

Reorg tables: tables can be moved to new segments with new storage caluse  or even another tablespace.
ALTER TABLE hr.admin_emp MOVE STORAGE ( INITIAL 20K  NEXT 40K  MINEXTENTS 2 MAXEXTENTS 20  PCTINCREASE 0 );