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 ); |