Performance Tuning and Troubleshooting in Oracle || SQL tuning & Database Performance Tuning - PT 0 скачать в хорошем качестве

Performance Tuning and Troubleshooting in Oracle || SQL tuning & Database Performance Tuning - PT 0

Hello Friends, I am starting the new series of videos on PT (Performance Tuning) Performance Tuning and Troubleshooting in Oracle || SQL Tuning - Database Performance Tuning - PT0 1. Database Performance Issue 2. AWR – How to read 3. ASH – How to read 4. System State Dump – How to capture and how to read them 5. 10046/10053/error stack 6. RAC specific database tuning parameters 7. Automatic SQL Tuning 8. Tools 9. Identifying and Tuning SQL Problems 10. ADDM 11. Tuning SQL & Tuning Optimizer and Execution Plan 12. Recommendations or Suggestions 13. Other Tools 14. Some frequently asked questions What is a DB performance issue: CPU high? Out of Memory? I/O slow? Qtune? High wait event? Hang? Tools AWR ASH dba_hist_active_sess_history SSD (System State Dump) HA (Enqueues & Latches) 10046 10053 Error stack Automatic SQL Tuning SQL Tuning Set SQL Tuning Advisor (Optimizer and Execution Plan) SQL Access Advisor SQL Performance Analyzer Identifying and Tuning SQL Problems Why SQL statements regress? Optimizer Application Resource and contention Issues Identifying problematic SQL ADDM and ASH Analytics Tuning SQL Tuning Optimizer Execution plan and history of execution Preventing SQL problems Recommendations or Suggestions Gather Schema stats and Table stats Table move Table shrink Index Analysing Table and Index partitioning Pegging Patching and BUG fixes Other recommendations Other Tools explain plan - lets you see the execution plan used by the query autotrace - automatically produces an execution plan when you execute any SQL. SQL trace - traces the execution of SQL statements TKPROF - formats the trace files into a readable form dbms_monitor - setup up end-to-end tracing Statspack - performance diagnosis tool Common questions: SQL Query is running longer time? Query data fetching is slow? Bad execution plan or execution plan keep changing? Please do follow me and support me on, Blog: https://mallik034.blogspot.com/ LinkedIn:   / mallikarjun-ramadurg-397a751a   twitter:   / mallik034   instagram:   / mallik034   YouTube:   / @vismotechnologies   Regards, Mallikarjun Ramadurg Mobile: +966 543796525 WhatsApp: +91 9880616848 Blog: https://mallik034.blogspot.com/ LinkedIn:   / mallikarjun-ramadurg-397a751a   twitter:  / mallik034   Instagram:  / mallik034   YouTube:   / @vismotechnologies