DB PERFORMANCE TUNNING

 DB PERFORMANCE TUNNING

***EXPLAIN PLAN how to generate explain plan in oracle | Oracle Shooter             https://www.youtube.com/watch?v=i8KrjgHmtZY https://www.youtube.com/watch?v=i8KrjgHmtZY WATCHED

Oracle SQL Performance Tuning 1              https://www.youtube.com/watch?v=sC3vmAKQXYI Watched SQL Performance Tuning 2 and tips             https://www.youtube.com/watch?v=3SHQMuxiqL4 Database Performance Tuning Steps | Oracle Performance Tuning                https://www.youtube.com/watch?v=YUWnhIRmYmU 3 Answers Every Performance Tuning Experts Always Seeking https://youtu.be/yGqK0fqM2EU Slow Running Query Tips | #dailyDBA 27 https://youtu.be/DzRCxzy7fF8

***HOW TO CHANGE THE PLAN

Read Oracle SQL Execution Plan | DBMS XPLAN https://www.youtube.com/watch?v=aUxrs8x_ieQ Webinar-06 - Performance Tuning || Profiling in Oracle || Oracle Database Performance Tuning https://www.youtube.com/watch?v=L6ypcJlTZeM&t=1s Loading plans in SQL Baselines in Oracle https://www.youtube.com/watch?v=2ZcMiMeo2pI Database Performance Tuning Steps | Oracle Performance Tuning https://www.youtube.com/watch?v=YUWnhIRmYmU&t=62s SQL Profile vs SQL Plan Management | #dailyDBA 21 https://www.youtube.com/watch?v=KbiUVHQ6uRQ How to Read Oracle AWR Report | Oracle Automatic Workload Repository https://www.youtube.com/watch?v=QPJL1fswbO4

Oracle Optimizer Cost | #dailyDBA 26 https://www.youtube.com/watch?v=FMWONK0pOY4&t=1s ***WHAT IS BIND VERIABLES

PL/SQL tutorial 6: Bind Variable in PL/SQL By Manish Sharma RebellionRider.com https://www.youtube.com/watch?v=TJtjo3FTBtE Bind Variables : For Performance and Protection Against SQL Injection https://www.youtube.com/watch?v=cwRwQ3mWyZQ PL/SQL Tutorial #5: Concept of Bind variables in PLSQL https://www.youtube.com/watch?v=5wVQJNrWte0

***HOW QEURY PROCESS WORK

DML Processing in an Oracle Database - DBArch Video 8 https://www.youtube.com/watch?v=shg1MjT0PuE

DDL statement processing in an Oracle Database - DBArch Video 9 https://www.youtube.com/watch?v=bCWljD74yr4 Instance Recovery in an Oracle Database - DBArch Video 10 https://www.youtube.com/watch?v=oH-jPGL4kdk ***HARD PARSE AND SOFT PARS

https://youtu.be/wT34XCkpoX4 https://youtu.be/oHZLVQjgSVM https://youtu.be/UYA71VIiTNs

***INDEX REBUILD OR CREATIONS

https://youtu.be/T0MzRoZiTAg https://youtu.be/alvUF2V73Us  https://youtu.be/ll3ulEIpHuc https://youtu.be/xbpqMvT8SNc ***ALL JOINS

https://youtu.be/F-pQGKjZRfM https://youtu.be/UF8JjOS_RK4 https://youtu.be/hFnAYS_UuJo https://youtu.be/0jsZofmoReM https://youtu.be/zYH-e6tUYbw

***GATHER STATS

https://youtu.be/jByvqkz4Nt8

https://youtu.be/fjzSkdArFuI

https://youtu.be/aNaevNAtq54

https://youtu.be/gjLfWMgVZ-g