Database Tuning
oracle Database Tuning
Our bespoke training course shall equip you with the essential skills required in real world applications to be able to tune an Oracle Database. One of the topics on this course shall focus on bottlenecks that not only cause poor performance but also focus on the underlying flaws.
We shall teach you how to examine & tune the hardware, operating system, application as well as the database & network bandwidth in order to fully optimise any database environment. This course shall cover the following topics in detail to ensure you are able to maintain a system to its optimum performance capability.
Day-1
- Tuning Application Design
Effective Table Design
Distribution of CPU Requirements
Effective Application Design
- Tuning SQL
Impact of Order on Load Rates
Additional Indexing Options
Generating Explain Plans
- Tuning Memory Usage
Managing SGA Pools
Specifying the Size of the SGA
Using the Cost-Based Optimizer
- Tuning Data Access
Identifying Chained Rows
Using Index-Organised Tables
Tuning Issues for Index-Organised Tables
Day-1
- Tuning Application Design
Effective Table Design
Distribution of CPU Requirements
Effective Application Design
- Tuning SQL
Impact of Order on Load Rates
Additional Indexing Options
Generating Explain Plans
- Tuning Memory Usage
Managing SGA Pools
Specifying the Size of the SGA
Using the Cost-Based Optimizer
- Tuning Data Access
Identifying Chained Rows
Using Index-Organised Tables
Tuning Issues for Index-Organised Tables
Day-2
- Tuning Data Manipulation
Bulk Inserts: Using the SQL*Loader Direct Path Option
Bulk Data Moves: Using External Tables
Bulk Inserts: Common Traps and Successful Tricks
Bulk Deletes: The TRUNCATE Command
Using Partitions
- Reducing Network Traffic
Replication of Data Using Materialized Views
Using Remote Procedure Calls
- Using the Automatic Workload Repository
Managing Snapshots
Managing Baselines
Generating AWR Reports
Running the Automatic Database Diagnostic Monitor Reports
Using Automatic SQL Tuning Advisor
Day-3
- Performance Tuning in a Multitenant Environment
Tuning Methodology
Sizing the CDB
Using Memory Advisors
Leveraging AWR Reports
Using the SQL Tuning Advisor
- Managing Resource Allocation Within a PDB
Using Shares to Manage Inter-PDB Resources
Creating and Modifying Resource Manager Plans
- Performing Database Replay
Analyze the Source Database Workloads
Capture Source Database Workloads
Process Workloads on Target System
Replay Workloads on Target CDB
Verify Replay Results
Have any questions?
testimonials
-
Oracle Database Academy is one of the best courses I have participated in. Satnam 's knowledge, delivery, and experience are second to none.
Tom Jenkins
-
The only course that I have come across which was tailored to my specific company needs, at a fraction of the price compared to previous learning courses I have used.
Gurmejer Singh
-
Well thought out courses, amazing organisation of courses and the ODA team are extremely helpful during the hands-on process. Definitely recommend.
Sarah Robinson
