Tag Archive: tuning

Index Tuning
  • 11
    Dic

Index Tuning

Oracle indexes can be tuned looking to three main characteristics: SELECTIVITY: you can calculate index selectivity using this formula: SELECT DISTINCT_KEYS/NUM_ROWS SELECTIVITY FROM DBA_INDEXES / Values range from 0 to 1, where 1 is the optimal value (UNIQUE indexes and...

Read More
Loading SQL Plans into SPM using AWR
  • 14
    Ago

Loading SQL Plans into SPM using AWR

Spesso può esserci bisogno di inserire SQL Plans in SPM ma ciò non è possibile perché la query non è in memoria. Questa è una semplice procedura per caricare SQL Plans in SPM tramite AWR. Il primo posso è creare,...

Read More
  • 12
    Giu

Create Oracle SQL Profile For Tuning

1024x768 Normal 0 14 false false false IT X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Tabella normale"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;...

Read More