Performance Tuning Level - I
Performance Tuning Level - I SQL Tuning – Level I 1. Job is running slow : Ask for Details – Template for Tickets. 2. SQL running slow - Find the SQL 3. Find the Stale Statistics objects, column details and index status. 4. How long a SQL has been running 5. Explain plan for SQL Running -- From Cursor Cache 6. Explain plan for SQL already been completed. – From AWR 7. Easy way to find top – running SQL using OEM 8. My package / procedure running slow – How to find the SQL 9. Enabling the Trace. 10. Setup the trace before package starts. – Using Trigger. 11. SQL Running Slow – I hav...