Make Oracle Databases Run Like A Beast!


Making sure that your critical production databases run at their full potential is one of the prime jobs of an Oracle DBA. Sometimes it's hard to figure out what is causing the slowness inside the database. Oracle provides you with host of tools that allows you to find performance bottleneck and tune the database for optimal performance!


What you will learn

  • How Query Executes - SQL Parsing, Cursors, Latches and SQL Area
  • The Optimizer - CBO, RBO, Execution Pans, Cost, CPU, Access Path and Hints
  • How to Tune SQL - Join Order, Reduce SQL Cost, SQL Tracing, SQL Tuning Advisor
  • The Instance - Shared Pool vs Buffer Cache, Bind Variables vs Instance, Memory Allocation Issues
  • How to tune instance - Automatic Memory, Tune PGA & SGA, Instance Tuning Views, Tuning Temp
  • The database - Index vs I/Os, Database Statistics, Table Partitions, Histograms and High Water Mark
  • How to tune the database - Rebuild Indexes, Segment Tuning, Temporary Tables, Row Chaining, Row Migrations
  • Tuning tools - AWR, ADDM, ASH, Compare Period AWRs, SQL Access Advisor, SQL Plan Management & Baseline
  • Miscellaneous - Auto Tracing, Application Tracing, Parallel Queries, Wait Events & Common Solutions


Real-Time Projects

  • Tune Oracle Database for a banking client based out of Singapore
  • Tune Oracle Database for a manufacturing client based out of India
  • Tune Oracle Database for an online game streaming company based out of Dubai


Bonus

  • SQL Tuning Template
  • Database Tuning Template
  • Instance Tuning Template
  • Mock Interview

Meet Your Instructor!


Hi there! I'm Arun Kumar, owner and instructor at DBA Genesis. I created this platform to share my DBA knowledge with all of you. My vision is to simplify DBA learning in order to make you become more competent in your professional career.

Apart from database, I love swimming, filming and business automation!

Select Enrollment Option


Frequently Asked Questions



How do I schedule my appointment?

Upon purchasing coaching, you'll receive further instructions on how to book a time for your appointment.


Will I be getting certificate of completion for this training?

Absolutely! once you finish the training, our team will email you a digital copy of your Certificate of Completion.