·
Server Tuning
o Disk – IO Stat
o RAM -VMStat
o CPU - Top
·
Instance Workload
Tuning
o Parameters – Optimizer Settings
o MetaData –Optimizer Statistics Tuning
o Cursor Management
- Cursor Tuning
·
Instance Object
Tuning
o Row Packing – PCTFree- PCT Used
o Concurrency -Freelists
o Table Row Location
- Sorted hash clusters
o Caching – Objects into KEEP pool
·
SQL Statement Tuning
o Rewrite SQL – Optimizer SQL with faster syntax formats.
§ Current Baseline From Production, and test environment.
§ Understand the current query completely and thoroughly.
§ Break the Data export query into 5/more section (We will
focus section wise, each section we will go with below and that we will do
today).
§ This is the order of the SQL execution, our analysis of
data extract query must be in the order by mentioning current implementation
and target implementation.
·
Where
·
Join/union
·
Order/group by
·
Select
§ List of solution identified.
·
Low
·
Medium
·
High
SQL
Profiles – for static execution plans.
