Oracle Performance Tuning This tutorial will provide a

Oracle Performance Tuning This tutorial will provide a good foundation for Oracle Performance Tuning Technique along with Handy Tips for performance resolution Learn Oracle Performance Tuning with Real-Time scenario by Industry Expert in 30 Day.

Agenda Oracle Memory Tuning/Instance Tuning Redo log Tuning SQL Tuning Understanding SQL tuning tools (Explain Plan , Trace and TKPROF Oracle Wait Event AWR , ASH and ADDM Analysis, Diagnose Database Performance Issues General Possible Problem Advance Database. Analysis Tools ( RDA and OSWATCHER)

Performance Tuning Overview Database Tuning is the activity of making a database application run more quickly. “More quickly” usually means higher throughput, though it may mean lower response time for time-critical applications. Improving performance means A)Reduce response time B)Increase throughput There is four main area for Performance Tuning. 1. SQL Tuning – Responsibility of the Developer 2. Database Tuning – Responsibility of the Database Administrator 3. System Tuning – Responsibility of the System Administrator 4. Network Tuning – Responsibility of the Network / LAN / WAN Administrator

Oracle Database Tuning tools/utilities Oracle provides the following tools/utilities to assist with performance monitoring and tuning Automated Maintenance Tasks ADDM Report / Regular ADDM Report (pre-12 c) ADDM Compare Report (New in 12 c) Real-Time ADDM Report (New in 12 c) Emergency Monitoring (Enhacement in "Memory Access Mode") ASH Report and AWR Report Trace and TKProf Oracle Enterprise Manager /12 c Grid Control RDA SQLT/STA OS watcher Various OS commands for identify bottleneck

Contact Information Email: easyreliable@gmail. com/support@easyreliable. com Web: www. easyreliable. com