Query Processing

-SQL Processing in Oracle
-SQL Execution Life Cycle & Reading Execution Plans

Wait Events: Latch Series

-Latch Cache Buffer Chains
-Buffer Busy Waits
-Buffer Free Waits
-Shared Pool Latch/Library Cache Lock

 Wait Events: I/O Series

-DB File Sequential Read
-DB File Scattered Read
-Log File Sync

 Wait Events : Lock Series

-Lock Series Enq TX
-Enq TM

 Performance Troubleshooting Series

-Understanding your Oracle Database Load
-Understanding your database load from Metrics – Part 2
-Understanding where the database time is spending – Time Model Statistics
-Understanding I/O Wait Performance of Oracle Database
-Understanding Database CPU – Consumers – Waiters – Average Active Sessions
-Troubleshooting Instance Memory Structures (SGA + PGA) Usage
-Identifying Problematic Sessions or Queries (Preface)
-Identifying Problematic Sessions or Queries (Method 1)
-Query Parsing & Execution Times
-Identifying or Estimating How much PGA needed by Session/Query

Report Walk Through Series

-AWR Report
-ASH Report
-Interactive Reports
-AWR Difference Report

Question Series
-Finding Transactions on a Table
-Finding fragmentation of a table having clob.
-Does dbms_stats collects stats for invisible indexes
-What happens when root.sh run in rac installation?
-When was the table last modified
-Check for performance issues
-When is my table last accessed? Does my index is in use?
-Why statistics are not collected though the automatic job shown it has ran sucessfully
-How to invalidate the cursor after statistics gathering
-Find the best way to find how much time a query has taken to execute
-when does your session/sid/statement appears in V$session_longops
-What are the meanings for different letter for awr base tables WR#
-Purge single sql from Shared Pool?
-Restore statistics and history facts
-Why you need to increase the cache size for sys.audsess$ sequence in RAC
-SQL Magic
-SQL_ID missing in dba_hist_sqlstat? Why
-CPU usage by Oracle, performance metrics
-High cpu usage with library cache locks
-Resolving Library cache: mutex X
-Number of locks that can acquire with parallel DML statements
-What is the minimum execution time that a query/statement for a parallel execution
-How to find the optimizer settings for a given session or sql_id

SQL Plan Flexibility & Stability Features

Oracle SQL Plan Stability and Flexbility features from 8i to 12c with demo snippets covering Cursor_sharing, Dynamic Sampling, Cardinality Feedback, Adaptive Cursor Sharing, 12c Adaptive Query Optimization features , SQL Profiles & Baselines with one sample use case. This presentation helps participants to understand various plan flexibility features in conjunction with Stability features