What will I Learn by the end of this course?
• Complete overall knowledge in Oracle Db’s and fine-tune them for better performance
• Determine the bottlenecks in low-performance Oracle databases
• Use Oracle database performance tuning tools, like Wait Events, AWR, ASH, V$ views, SQL tracing, real-time monitoring,
• Propose solutions to database performance issues
• Implement Oracle methodology in performance tuning
• Using Oracle optimizer for better tuning and execution
• Implementing various tuning methods like different types of indexes, using bind variables and much more.
• Discover the ineffectively performing queries
• Identifying bad and good queries to improve performance and remove bottlenecks and Implement proper tuning approach
• Gathering the metrics and generating performance reports, Creating test plans and strategies
Training Details:
Demo 1: 11 Aug 2022
Demo 2: 12 Aug 2022
Training Start Date: 15 Aug 2022
Time: 8 PM (IST) / 10:30 AM (EST) / 3:30 PM (BST)
Course Duration: 20 hours
Demo Session: First 2 Sessions Free
Course Content:
- Oracle DB and its components:
- Needs of SQL Tuning & Prerequisites for SQL DB Tuning.
- Need for knowing oracle DB Architecture.
- Oracle DB Architecture.
- Data Blocks, PGA, Shared pool, Buffer cache & Redo Log Buffer
- DML Processing, Automatic Memory management, Storage Architecture of Oracle DB, Logical and Physical DB.
- Oracle Tuning Basics and Tools:
- Wait events
- AWR
- Bad SQL, Efficient Schema, Table Partition, SQL statement processing, Optimizer and the needs of it, Query transform, Selectivity and Cardinality, Plan Generator & Row Source Generator
- SQL Tuning and Query analysis strategy principles.
- Execution Plan and Statistics:
- Execution Plan and Explain Plan, Generating Statistics, Generating Execution Plan
- V$SQL_PLAN View
- Reading Execution Plans & Execution Plan Analysis
- Tables and Index access pathway:
- Indexes and how they work?
- Types of Table and Index Access Paths
- Table Access Full
- Index Unique Scan, Index Range Scan, Index Full Scan, Index Fast Full Scan, Index Skip Scan, Index Join Scan
- Optimizer hints & Joins
- Hints and their use, some valuable Hints
- Join Methods & Join Types
- Nested Loop Joins, Sort Merge Joins, Hash Joins, Cartesian Joins
- Equi joins, Outer Joins, Semi Joins, Anti Joins
- Optimizer Operators
- Result Cache Operator, View Operator, Clusters
- Sort Operators, Inlist Operator, Count Stopkey Operator, First Row Operator, Filter Operator, Concatenation Operator, Union Operator, Intersect Operator, Minus Operator
- In-Depth SQL Tuning With Query Profiling
- How to find a performance problem and its tuning solution?
- Different Ways of Getting the Execution Plan and the Statistics
- Using the Real-Time SQL Monitoring Tool, Using the Trace Files & TKPROF Utility, Fetch only those absolutely needed.
- Index Usage, Using Concatenation, Using Arithmetic Operators, Using Like Conditions, Using Functions on the Indexed Columns, Handling NULL-Based Performance Problems, Using EXISTS instead of IN Clause, Using TRUNCATE instead of DELETE command, Data Type Mismatch, Tuning Ordered Queries, Fetching MIN & MAX Values, UNION and UNION ALL Operators, Prevent HAVING Clause, Alert about Views, Materialized Views, Optimized use of COMMIT, Partition Pruning, BULK COLLECT, Tuning the Join Order, Multitable DML Operations, Using Temporary Tables, Combining SQL Statements, WITH Clause, Using Analytical Functions
- Advanced Oracle DB/SQL Tuning Concepts
- Tuning Star Queries, Using Bind Variables, Beware of Bind Variable Peeking
- Cursor Sharing &Adaptive Cursor Sharing
- Adaptive Plans, Dynamic Statistics (Dynamic Sampling)
Registration Link: Click here
More Details on Training: Click here
Contact Number: +91-8019952427 (WhatsApp or Call)
Organized By: Isha Training Solutions
Disclaimer: PerfMatrix does not conduct any classroom or online training/classes. The training/demo details given on this page are either taken from the social media source or provided by the individual trainer or institute. Request you to please verify the authenticity of the training (and trainer) before providing your personal details. PerfMatrix will not take any responsibility in case of false knowledge, waste of time or financial loses.