ORACLE SUPPLIED GUI TUNING TOOLS | Oracle DBA Tutorial pdf

ORACLE SUPPLIED GUI TUNING TOOLS

Oracle supplied GUI tuning tools
Capacity Planner
Performance Manager – observe database performance.
Top Sessions – see which users are consuming most resource
Trace Data Viewer
Lock Monitor
Top SQL – most resource consuming SQLs
Performance Overview – see current performance of database
Oracle Expert – gathers statistics and gives recommendations for tuning Index Tuning Wizard – identify unused indexes