What we do?
- Evaluating system architecture including hardware, software and storage components
- Workload analysis
- Query tuning
- Index maintenance
- Optimise initialisation and instance parameters
- Analyse and tune instance memory
- Analyse ADDM, ASH, AWR reports
- Collect and analyse OS counters
- Analyse query plan and tune SQL statements
- Tune PGA, SGA and Buffer Cache
- Analyse and resolve CPU utilisation related issue
- Analyse SQL access adviser
- Configure Optimizer Hints
- Analyse database and database configurations