Page Comparison

...

Oracle tuning - Tune individual SQL statements

...

• http://www.dba-oracle.com/art_sql_tune.htm

Views to access AWR data

• http://www.dba-oracle.com/oracle10g_tuning/t_dba_hist_data_dictionary_views.htm

...

• http://orafaq.com/faqdbapf.htm
  • My query was fine last week and now it is slow. Why?
  • Why is Oracle not using the bleep index?

Compressing Extents in Oracle

• Source: http://www.lifeaftercoffee.com/2005/12/07/compressing-extents-in-oracle/

  • No Format
    ALTER TABLE system.session_audit MOVE TABLESPACE system STORAGE (INITIAL 10M NEXT 5M);

"Instance Efficiency Percentages" and "Shared Pool Statistics" metrics interpretation

• http://www.dba-oracle.com/oracle10g_tuning/t_instance_efficiency_percentage.htm