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: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA

Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter:https://twitter.com/mallik034
Instagram:https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA