Mastering Oracle Database for High-Performance Systems
You're under pressure. Deadlines are tightening, systems are straining, and performance bottlenecks are escalating into board-level concerns. You know Oracle is powerful, but if it's not optimised correctly, it becomes a liability, not an asset. Every second of latency costs your organisation revenue, trust, and competitive edge. You need more than just SQL syntax or basic administration. You need deep, strategic mastery of Oracle Database architecture-the kind that transforms sluggish systems into high-velocity engines. Mastering Oracle Database for High-Performance Systems is engineered for professionals like you. This is not a beginner tutorial. It's a precision toolkit that fast-tracks you from reactive troubleshooting to proactive, elite-level system design-giving you the clarity, control, and confidence to deliver measurable performance gains within 30 days. One senior DBA, working on a global financial trading platform, reduced query response times by 84% using the indexing frameworks in this course. He presented the results directly to CTO leadership and was fast-tracked into an architecture role-now earning 42% more. Whether you're managing mission-critical ERP systems, real-time analytics, or cloud-native applications, this course equips you with the proven methodologies used by top-tier Oracle performance engineers. No guesswork. No outdated tricks. Just battle-tested strategies, performance blueprints, and implementation playbooks that work in the real world. Here’s how this course is structured to help you get there.Course Format & Delivery Details Self-Paced, On-Demand, and Built for Your Reality
This is a premium, self-paced learning experience with immediate online access. There are no fixed start dates, live sessions, or arbitrary deadlines. You begin when you're ready, progress at your own pace, and retain full control over your learning journey. Most learners complete the core performance modules in 4 to 6 weeks with just 60–90 minutes per day. Many report implementing high-impact tuning strategies and seeing measurable improvements in system responsiveness within their first week. Lifetime Access, Zero Expiry
Once enrolled, you receive lifetime access to the entire course. This includes all current materials and every future update released by our team of Oracle performance architects-free of charge. As Oracle evolves, so does your knowledge. - 24/7 access from any device-fully mobile-friendly and responsive
- Learn during commute, lunch breaks, or late-night deep work sessions
- Structured for high retention, with progress tracking and actionable checkpoints
Expert Guidance, Not Just Content
You’re not learning in isolation. Every module includes direct access to refined implementation guidance from certified Oracle performance engineers. Our support system is designed for clarity-you’ll get concise, technical responses to your questions, ensuring confident execution. Prove Your Mastery: Certificate of Completion
Upon finishing, you’ll receive a globally recognised Certificate of Completion issued by The Art of Service. This credential is respected across Fortune 500 organisations, government agencies, and enterprise IT departments. It validates your ability to architect, optimise, and maintain Oracle systems at peak performance. Recruiters and hiring managers actively look for this certification when filling high-performance database roles-it’s a proven differentiator on LinkedIn, résumés, and performance reviews. No Risk. No Tricks. Full Confidence.
We eliminate all risk with a 30-day, no-questions-asked refund guarantee. If you don’t find immediate value in the first three modules, simply request a refund. You walk away with zero loss. Pricing is straightforward, with no hidden fees, subscriptions, or upsells. What you see is exactly what you pay-one-time, all-inclusive access. - Accepted payment methods: Visa, Mastercard, PayPal
- Invoice and bulk licensing options available for teams
- After enrollment, you’ll receive a confirmation email, and your access details will be delivered separately once your course package is fully prepared
This Works Even If...
You’re not a DBA by title. You work in development, DevOps, or systems engineering and need Oracle performance depth to unblock your team. You’ve tried online resources before and found them fragmented or outdated. This course is a complete, integrated system-not random tutorials. You’re time-constrained. The modular design means you can target your weakest performance gaps first-indexing, memory allocation, query optimisation-and see results fast. Our alumni include software architects, cloud engineers, and data platform leads who used this course to close critical skill gaps and step into Oracle performance leadership. This is not theoretical. It’s the exact methodology used by Oracle consultants at top-tier firms-now distilled into a clear, results-first roadmap.
Extensive and Detailed Course Curriculum
Module 1: Foundations of Oracle High-Performance Architecture - Understanding Oracle Database architecture: SGA, PGA, and process structures
- Memory management principles for optimal throughput
- Oracle instance vs database: key distinctions and implications
- Data block structure and I/O efficiency fundamentals
- Row chaining and migration: identification and resolution
- Redo log mechanics and performance impact
- Control file configuration for resilience and speed
- Temporary tablespace optimisation for sorting operations
- Undo tablespace sizing and retention best practices
- Storage hierarchy: from disk to memory to cache optimization
- Database links and distributed query performance considerations
- Oracle Real Application Clusters (RAC) architecture overview
- Partitioning strategies for performance and manageability
- Introduction to automatic memory management (AMM) and ASMM
- Oracle Database licensing models and performance implications
Module 2: High-Performance Installation and Configuration - Optimal Oracle software installation for performance
- Database creation with performance-specific parameters
- Optimal filesystem selection: ASM, OCFS2, or third-party
- Automatic Storage Management (ASM) setup and tuning
- Parameter file optimization: SPFILE vs PFILE
- Key init.ora parameters for high-throughput environments
- SGA target and PGA aggregate target calibration
- Result cache configuration and memory allocation
- Large pool and shared pool sizing for high concurrency
- Java pool and Streams pool considerations
- Memory pressure detection and prevention
- Database time model analysis for tuning priorities
- Instance parameter validation using V$ views
- Oracle restart and Grid Infrastructure for high availability
- Pre-installation performance checklist and validation
Module 3: Table and Index Performance Engineering - Data type selection for performance and storage efficiency
- Table organisation: heap, index-organized, external
- Compression techniques: basic, advanced, and hybrid
- Index types: B-tree, bitmap, function-based, reverse key
- Index rebuild vs coalesce: performance trade-offs
- Index monitoring and usage analysis
- Index-only scans and covering indexes
- Clustering factor and its impact on index efficiency
- Bitmap join indexes for data warehouse performance
- Index key compression: prefix vs suffix strategies
- Partitioned indexes: local vs global, prefixed vs non-prefixed
- Invisible indexes for safe performance testing
- Descending indexes for range query optimisation
- Duplicate index detection and removal
- Index maintenance scheduling for OLTP workloads
Module 4: SQL Query Optimization and Execution Plans - SQL execution flow: parse, execute, fetch phases
- Understanding the cost-based optimizer (CBO)
- Rule-based vs cost-based: when each applies
- Reading and interpreting execution plans
- EXPLAIN PLAN, DBMS_XPLAN, and SQL Trace
- Access methods: full table scan vs index scan vs fast full scan
- Join methods: nested loop, hash join, sort merge join
- Join order and driving table selection
- Optimizer statistics: gathering, locking, and monitoring
- Dynamic sampling for missing statistics
- Cardinality estimation and histogram strategies
- SQL hints: when and how to use safely
- SQL profile creation and deployment
- SQL plan baseline implementation
- Adaptive execution plans and their impact
- SQL Plan Management (SPM) for stability
- Parallel execution and DOP (degree of parallelism) tuning
- Automatic Degree of Parallelism (Auto DOP)
- PQ distribution methods and skew handling
- Parallel query hints and session control
Module 5: Advanced Indexing for High-Volume Workloads - Index compression efficiency analysis
- Index rebuilding for space reclamation
- Index monitoring during application peak loads
- Function-based index design for complex filters
- Virtual column indexes for computed expressions
- Spatial index tuning for GIS applications
- Text index optimisation for Oracle Text
- Index-organized tables (IOT) for primary key-heavy access
- Overflow segments and PCTTHRESHOLD tuning
- Secondary indexes on IOTs: performance trade-offs
- Bitmap index usage in mixed OLTP/DW environments
- Bitmap index concurrency limitations and workarounds
- Index key length and entry size optimisation
- Index maintenance during bulk operations
- Index rebuild automation scripts
Module 6: High-Performance Schema Design and Normalisation - Normalisation levels and performance trade-offs
- Denormalisation guidelines for read-heavy systems
- Surrogate vs natural key performance impact
- Sequence number caching for high-insert scenarios
- Identity columns and their performance implications
- Referential integrity and constraint enforcement costs
- Deferrable constraints for batch processing
- Check constraints and expression evaluation
- Materialised view design for query offloading
- Incremental refresh strategies for materialised views
- Fast refresh eligibility and logs
- Query rewrite optimisation and tuning
- Materialised view logs and overhead management
- Prebuilt tables and with rowid optimisation
- SUMMARIES and aggregation performance
Module 7: Concurrency and Lock Management - Oracle locking mechanisms: row-level, table-level, DML locks
- Enqueue wait analysis using V$SESSION_WAIT
- Deadlock detection and resolution
- Lock escalation avoidance strategies
- FOR UPDATE WAIT and NOWAIT clause usage
- Skip locked rows for high-concurrency queues
- Transaction isolation levels and performance
- Read consistency and undo segment usage
- Undo retention tuning for long-running queries
- ORA-1555 snapshot too old prevention
- Lock contention monitoring scripts
- Library cache lock and pin optimisation
- Cursor duration and parse locks
- DDL locking and online operations
- Resumable space allocation for large DDL
Module 8: High-Performance Data Loading and Bulk Operations - SQL*Loader: direct path vs conventional path
- Direct path insert and its redo implications
- PARTITION clause usage for targeted loading
- Append hint and NOLOGGING mode for speed
- Parallel data loading with multiple SQL*Loader sessions
- External table performance tuning
- Preprocessing scripts for external data
- CTAS (Create Table As Select) performance guidelines
- Batch commit frequency and rollback segment sizing
- Bulk collect and FORALL in PL/SQL
- Limit clause for memory-efficient bulk operations
- Multitable INSERT for efficient ETL
- INSERT ALL and conditional INSERT ALL
- MERGE statement optimisation
- Filtering during data load to prevent bloat
Module 9: Performance Monitoring and Diagnostic Tools - AWR (Automatic Workload Repository) report analysis
- AWR baseline comparison for changes
- ASH (Active Session History) drill-down
- ADDM (Automatic Database Diagnostic Monitor) recommendations
- STATSPACK for older Oracle versions
- Custom performance snapshots and delta analysis
- V$ system views for real-time monitoring
- Dynamic Performance Views hierarchy
- Wait event analysis: top 20 performance killers
- Idle vs non-idle wait events
- Time model statistics and DB time breakdown
- SQL monitoring for long-running queries
- Real-time SQL monitoring with detailed reports
- Performance views for parallel execution
- Diagnostic pack licensing implications
Module 10: High-Performance PL/SQL and Stored Procedures - PL/SQL optimisation: avoiding context switches
- NOCOPY hint for large OUT parameters
- Native compilation and its performance gains
- Subprogram inlining for critical routines
- Pipelined table functions for streaming
- Conditional compilation for environment-specific logic
- Autonomous transactions and performance impact
- Exception handling best practices for speed
- Cursor variables and ref cursors efficiency
- FOR loops vs cursor FOR loops
- Implicit vs explicit cursor performance
- Caching within PL/SQL: package state
- PL/SQL function result cache
- Scalar subquery caching in SQL
- Recursion avoidance in stored logic
Module 11: High-Performance Partitioning Strategies - Range, list, hash, and composite partitioning
- Partition pruning: full vs partial
- Smart scan offloading in Exadata environments
- Partition-wise joins for large table queries
- Partition maintenance: SPLIT, MERGE, DROP
- EXCHANGE PARTITION for fast data loading
- Partition templates and interval partitioning
- Reference partitioning for parent-child tables
- System partitioning for application-controlled routing
- Partition key selection best practices
- Partition granularity: row count vs performance
- Local vs global index maintenance
- Partitioning with indexes: performance scenarios
- Partitioning in RAC environments
- Partitioning and backup strategies
Module 12: Memory and Buffer Cache Optimisation - Database buffer cache: LRU and touch count
- Multiple buffer pools: keep, recycle, default
- DB_KEEP_CACHE_SIZE and sizing guidelines
- Buffer busy waits and contention resolution
- Free buffer wait and write complete waits
- DBWR (Database Writer) process tuning
- Checkpoint tuning and its impact on I/O
- FAST_START_MTTR_TARGET configuration
- Log file sync and log buffer optimisation
- LOG_BUFFER sizing and LGWR performance
- Redo log file size and switching frequency
- Redo generation minimisation techniques
- No logging operations and recovery trade-offs
- Direct path read and buffer cache bypass
- Smart scan and Exadata offloading
Module 13: High-Performance Backup and Recovery - RMAN architecture and channel configuration
- Incremental backup strategies: level 0, 1, differential, cumulative
- Block change tracking for faster backups
- Binary compression and RMAN performance
- Parallelism in RMAN: channels and duplexing
- Backup optimization and duplicate detection
- Archivelog mode and performance overhead
- Flashback Database and restore points
- Fast recovery area (FRA) sizing and monitoring
- TSPITR (Tablespace Point-in-Time Recovery)
- Transportable tablespaces for fast cloning
- Full vs partial database recovery
- Incremental refresh for standby databases
- Backup encryption and compression trade-offs
- Monitoring RMAN job progress and bottlenecks
Module 14: High-Performance High Availability and Scalability - Data Guard configuration: physical vs logical standby
- Real-Time Apply and lag minimisation
- Switchover and failover best practices
- Active Data Guard and reporting offloading
- Fast-start failover (FSFO) setup
- RAC load balancing and service tuning
- Service failover and replay
- Database sharding for extreme scale
- Shard catalog and key distribution
- Cross-shard query optimisation
- Global query coordinator tuning
- Application continuity and replay drivers
- FAN (Fast Application Notification) integration
- Load balancing advisory and service metrics
- Maximum availability architecture (MAA) principles
Module 15: High-Performance Cloud and Hybrid Deployments - Oracle Cloud Infrastructure (OCI) database deployment
- Autonomous Database performance considerations
- Exadata Cloud Service tuning
- Storage performance in cloud environments
- Network bandwidth and latency tuning
- Cloud backup and snapshot strategies
- Hybrid connectivity: on-prem to cloud
- GoldenGate replication for hybrid performance
- Latency-aware application design
- Cloud licensing and cost-performance trade-offs
- Instance sizing: OCPU, memory, storage
- Auto-scaling and performance thresholds
- Cloud monitoring integration
- Performance tuning in containerised Oracle
- Database as a Service (DBaaS) optimisation
Module 16: Certification, Implementation, and Next Steps - Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service
Module 1: Foundations of Oracle High-Performance Architecture - Understanding Oracle Database architecture: SGA, PGA, and process structures
- Memory management principles for optimal throughput
- Oracle instance vs database: key distinctions and implications
- Data block structure and I/O efficiency fundamentals
- Row chaining and migration: identification and resolution
- Redo log mechanics and performance impact
- Control file configuration for resilience and speed
- Temporary tablespace optimisation for sorting operations
- Undo tablespace sizing and retention best practices
- Storage hierarchy: from disk to memory to cache optimization
- Database links and distributed query performance considerations
- Oracle Real Application Clusters (RAC) architecture overview
- Partitioning strategies for performance and manageability
- Introduction to automatic memory management (AMM) and ASMM
- Oracle Database licensing models and performance implications
Module 2: High-Performance Installation and Configuration - Optimal Oracle software installation for performance
- Database creation with performance-specific parameters
- Optimal filesystem selection: ASM, OCFS2, or third-party
- Automatic Storage Management (ASM) setup and tuning
- Parameter file optimization: SPFILE vs PFILE
- Key init.ora parameters for high-throughput environments
- SGA target and PGA aggregate target calibration
- Result cache configuration and memory allocation
- Large pool and shared pool sizing for high concurrency
- Java pool and Streams pool considerations
- Memory pressure detection and prevention
- Database time model analysis for tuning priorities
- Instance parameter validation using V$ views
- Oracle restart and Grid Infrastructure for high availability
- Pre-installation performance checklist and validation
Module 3: Table and Index Performance Engineering - Data type selection for performance and storage efficiency
- Table organisation: heap, index-organized, external
- Compression techniques: basic, advanced, and hybrid
- Index types: B-tree, bitmap, function-based, reverse key
- Index rebuild vs coalesce: performance trade-offs
- Index monitoring and usage analysis
- Index-only scans and covering indexes
- Clustering factor and its impact on index efficiency
- Bitmap join indexes for data warehouse performance
- Index key compression: prefix vs suffix strategies
- Partitioned indexes: local vs global, prefixed vs non-prefixed
- Invisible indexes for safe performance testing
- Descending indexes for range query optimisation
- Duplicate index detection and removal
- Index maintenance scheduling for OLTP workloads
Module 4: SQL Query Optimization and Execution Plans - SQL execution flow: parse, execute, fetch phases
- Understanding the cost-based optimizer (CBO)
- Rule-based vs cost-based: when each applies
- Reading and interpreting execution plans
- EXPLAIN PLAN, DBMS_XPLAN, and SQL Trace
- Access methods: full table scan vs index scan vs fast full scan
- Join methods: nested loop, hash join, sort merge join
- Join order and driving table selection
- Optimizer statistics: gathering, locking, and monitoring
- Dynamic sampling for missing statistics
- Cardinality estimation and histogram strategies
- SQL hints: when and how to use safely
- SQL profile creation and deployment
- SQL plan baseline implementation
- Adaptive execution plans and their impact
- SQL Plan Management (SPM) for stability
- Parallel execution and DOP (degree of parallelism) tuning
- Automatic Degree of Parallelism (Auto DOP)
- PQ distribution methods and skew handling
- Parallel query hints and session control
Module 5: Advanced Indexing for High-Volume Workloads - Index compression efficiency analysis
- Index rebuilding for space reclamation
- Index monitoring during application peak loads
- Function-based index design for complex filters
- Virtual column indexes for computed expressions
- Spatial index tuning for GIS applications
- Text index optimisation for Oracle Text
- Index-organized tables (IOT) for primary key-heavy access
- Overflow segments and PCTTHRESHOLD tuning
- Secondary indexes on IOTs: performance trade-offs
- Bitmap index usage in mixed OLTP/DW environments
- Bitmap index concurrency limitations and workarounds
- Index key length and entry size optimisation
- Index maintenance during bulk operations
- Index rebuild automation scripts
Module 6: High-Performance Schema Design and Normalisation - Normalisation levels and performance trade-offs
- Denormalisation guidelines for read-heavy systems
- Surrogate vs natural key performance impact
- Sequence number caching for high-insert scenarios
- Identity columns and their performance implications
- Referential integrity and constraint enforcement costs
- Deferrable constraints for batch processing
- Check constraints and expression evaluation
- Materialised view design for query offloading
- Incremental refresh strategies for materialised views
- Fast refresh eligibility and logs
- Query rewrite optimisation and tuning
- Materialised view logs and overhead management
- Prebuilt tables and with rowid optimisation
- SUMMARIES and aggregation performance
Module 7: Concurrency and Lock Management - Oracle locking mechanisms: row-level, table-level, DML locks
- Enqueue wait analysis using V$SESSION_WAIT
- Deadlock detection and resolution
- Lock escalation avoidance strategies
- FOR UPDATE WAIT and NOWAIT clause usage
- Skip locked rows for high-concurrency queues
- Transaction isolation levels and performance
- Read consistency and undo segment usage
- Undo retention tuning for long-running queries
- ORA-1555 snapshot too old prevention
- Lock contention monitoring scripts
- Library cache lock and pin optimisation
- Cursor duration and parse locks
- DDL locking and online operations
- Resumable space allocation for large DDL
Module 8: High-Performance Data Loading and Bulk Operations - SQL*Loader: direct path vs conventional path
- Direct path insert and its redo implications
- PARTITION clause usage for targeted loading
- Append hint and NOLOGGING mode for speed
- Parallel data loading with multiple SQL*Loader sessions
- External table performance tuning
- Preprocessing scripts for external data
- CTAS (Create Table As Select) performance guidelines
- Batch commit frequency and rollback segment sizing
- Bulk collect and FORALL in PL/SQL
- Limit clause for memory-efficient bulk operations
- Multitable INSERT for efficient ETL
- INSERT ALL and conditional INSERT ALL
- MERGE statement optimisation
- Filtering during data load to prevent bloat
Module 9: Performance Monitoring and Diagnostic Tools - AWR (Automatic Workload Repository) report analysis
- AWR baseline comparison for changes
- ASH (Active Session History) drill-down
- ADDM (Automatic Database Diagnostic Monitor) recommendations
- STATSPACK for older Oracle versions
- Custom performance snapshots and delta analysis
- V$ system views for real-time monitoring
- Dynamic Performance Views hierarchy
- Wait event analysis: top 20 performance killers
- Idle vs non-idle wait events
- Time model statistics and DB time breakdown
- SQL monitoring for long-running queries
- Real-time SQL monitoring with detailed reports
- Performance views for parallel execution
- Diagnostic pack licensing implications
Module 10: High-Performance PL/SQL and Stored Procedures - PL/SQL optimisation: avoiding context switches
- NOCOPY hint for large OUT parameters
- Native compilation and its performance gains
- Subprogram inlining for critical routines
- Pipelined table functions for streaming
- Conditional compilation for environment-specific logic
- Autonomous transactions and performance impact
- Exception handling best practices for speed
- Cursor variables and ref cursors efficiency
- FOR loops vs cursor FOR loops
- Implicit vs explicit cursor performance
- Caching within PL/SQL: package state
- PL/SQL function result cache
- Scalar subquery caching in SQL
- Recursion avoidance in stored logic
Module 11: High-Performance Partitioning Strategies - Range, list, hash, and composite partitioning
- Partition pruning: full vs partial
- Smart scan offloading in Exadata environments
- Partition-wise joins for large table queries
- Partition maintenance: SPLIT, MERGE, DROP
- EXCHANGE PARTITION for fast data loading
- Partition templates and interval partitioning
- Reference partitioning for parent-child tables
- System partitioning for application-controlled routing
- Partition key selection best practices
- Partition granularity: row count vs performance
- Local vs global index maintenance
- Partitioning with indexes: performance scenarios
- Partitioning in RAC environments
- Partitioning and backup strategies
Module 12: Memory and Buffer Cache Optimisation - Database buffer cache: LRU and touch count
- Multiple buffer pools: keep, recycle, default
- DB_KEEP_CACHE_SIZE and sizing guidelines
- Buffer busy waits and contention resolution
- Free buffer wait and write complete waits
- DBWR (Database Writer) process tuning
- Checkpoint tuning and its impact on I/O
- FAST_START_MTTR_TARGET configuration
- Log file sync and log buffer optimisation
- LOG_BUFFER sizing and LGWR performance
- Redo log file size and switching frequency
- Redo generation minimisation techniques
- No logging operations and recovery trade-offs
- Direct path read and buffer cache bypass
- Smart scan and Exadata offloading
Module 13: High-Performance Backup and Recovery - RMAN architecture and channel configuration
- Incremental backup strategies: level 0, 1, differential, cumulative
- Block change tracking for faster backups
- Binary compression and RMAN performance
- Parallelism in RMAN: channels and duplexing
- Backup optimization and duplicate detection
- Archivelog mode and performance overhead
- Flashback Database and restore points
- Fast recovery area (FRA) sizing and monitoring
- TSPITR (Tablespace Point-in-Time Recovery)
- Transportable tablespaces for fast cloning
- Full vs partial database recovery
- Incremental refresh for standby databases
- Backup encryption and compression trade-offs
- Monitoring RMAN job progress and bottlenecks
Module 14: High-Performance High Availability and Scalability - Data Guard configuration: physical vs logical standby
- Real-Time Apply and lag minimisation
- Switchover and failover best practices
- Active Data Guard and reporting offloading
- Fast-start failover (FSFO) setup
- RAC load balancing and service tuning
- Service failover and replay
- Database sharding for extreme scale
- Shard catalog and key distribution
- Cross-shard query optimisation
- Global query coordinator tuning
- Application continuity and replay drivers
- FAN (Fast Application Notification) integration
- Load balancing advisory and service metrics
- Maximum availability architecture (MAA) principles
Module 15: High-Performance Cloud and Hybrid Deployments - Oracle Cloud Infrastructure (OCI) database deployment
- Autonomous Database performance considerations
- Exadata Cloud Service tuning
- Storage performance in cloud environments
- Network bandwidth and latency tuning
- Cloud backup and snapshot strategies
- Hybrid connectivity: on-prem to cloud
- GoldenGate replication for hybrid performance
- Latency-aware application design
- Cloud licensing and cost-performance trade-offs
- Instance sizing: OCPU, memory, storage
- Auto-scaling and performance thresholds
- Cloud monitoring integration
- Performance tuning in containerised Oracle
- Database as a Service (DBaaS) optimisation
Module 16: Certification, Implementation, and Next Steps - Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service
- Optimal Oracle software installation for performance
- Database creation with performance-specific parameters
- Optimal filesystem selection: ASM, OCFS2, or third-party
- Automatic Storage Management (ASM) setup and tuning
- Parameter file optimization: SPFILE vs PFILE
- Key init.ora parameters for high-throughput environments
- SGA target and PGA aggregate target calibration
- Result cache configuration and memory allocation
- Large pool and shared pool sizing for high concurrency
- Java pool and Streams pool considerations
- Memory pressure detection and prevention
- Database time model analysis for tuning priorities
- Instance parameter validation using V$ views
- Oracle restart and Grid Infrastructure for high availability
- Pre-installation performance checklist and validation
Module 3: Table and Index Performance Engineering - Data type selection for performance and storage efficiency
- Table organisation: heap, index-organized, external
- Compression techniques: basic, advanced, and hybrid
- Index types: B-tree, bitmap, function-based, reverse key
- Index rebuild vs coalesce: performance trade-offs
- Index monitoring and usage analysis
- Index-only scans and covering indexes
- Clustering factor and its impact on index efficiency
- Bitmap join indexes for data warehouse performance
- Index key compression: prefix vs suffix strategies
- Partitioned indexes: local vs global, prefixed vs non-prefixed
- Invisible indexes for safe performance testing
- Descending indexes for range query optimisation
- Duplicate index detection and removal
- Index maintenance scheduling for OLTP workloads
Module 4: SQL Query Optimization and Execution Plans - SQL execution flow: parse, execute, fetch phases
- Understanding the cost-based optimizer (CBO)
- Rule-based vs cost-based: when each applies
- Reading and interpreting execution plans
- EXPLAIN PLAN, DBMS_XPLAN, and SQL Trace
- Access methods: full table scan vs index scan vs fast full scan
- Join methods: nested loop, hash join, sort merge join
- Join order and driving table selection
- Optimizer statistics: gathering, locking, and monitoring
- Dynamic sampling for missing statistics
- Cardinality estimation and histogram strategies
- SQL hints: when and how to use safely
- SQL profile creation and deployment
- SQL plan baseline implementation
- Adaptive execution plans and their impact
- SQL Plan Management (SPM) for stability
- Parallel execution and DOP (degree of parallelism) tuning
- Automatic Degree of Parallelism (Auto DOP)
- PQ distribution methods and skew handling
- Parallel query hints and session control
Module 5: Advanced Indexing for High-Volume Workloads - Index compression efficiency analysis
- Index rebuilding for space reclamation
- Index monitoring during application peak loads
- Function-based index design for complex filters
- Virtual column indexes for computed expressions
- Spatial index tuning for GIS applications
- Text index optimisation for Oracle Text
- Index-organized tables (IOT) for primary key-heavy access
- Overflow segments and PCTTHRESHOLD tuning
- Secondary indexes on IOTs: performance trade-offs
- Bitmap index usage in mixed OLTP/DW environments
- Bitmap index concurrency limitations and workarounds
- Index key length and entry size optimisation
- Index maintenance during bulk operations
- Index rebuild automation scripts
Module 6: High-Performance Schema Design and Normalisation - Normalisation levels and performance trade-offs
- Denormalisation guidelines for read-heavy systems
- Surrogate vs natural key performance impact
- Sequence number caching for high-insert scenarios
- Identity columns and their performance implications
- Referential integrity and constraint enforcement costs
- Deferrable constraints for batch processing
- Check constraints and expression evaluation
- Materialised view design for query offloading
- Incremental refresh strategies for materialised views
- Fast refresh eligibility and logs
- Query rewrite optimisation and tuning
- Materialised view logs and overhead management
- Prebuilt tables and with rowid optimisation
- SUMMARIES and aggregation performance
Module 7: Concurrency and Lock Management - Oracle locking mechanisms: row-level, table-level, DML locks
- Enqueue wait analysis using V$SESSION_WAIT
- Deadlock detection and resolution
- Lock escalation avoidance strategies
- FOR UPDATE WAIT and NOWAIT clause usage
- Skip locked rows for high-concurrency queues
- Transaction isolation levels and performance
- Read consistency and undo segment usage
- Undo retention tuning for long-running queries
- ORA-1555 snapshot too old prevention
- Lock contention monitoring scripts
- Library cache lock and pin optimisation
- Cursor duration and parse locks
- DDL locking and online operations
- Resumable space allocation for large DDL
Module 8: High-Performance Data Loading and Bulk Operations - SQL*Loader: direct path vs conventional path
- Direct path insert and its redo implications
- PARTITION clause usage for targeted loading
- Append hint and NOLOGGING mode for speed
- Parallel data loading with multiple SQL*Loader sessions
- External table performance tuning
- Preprocessing scripts for external data
- CTAS (Create Table As Select) performance guidelines
- Batch commit frequency and rollback segment sizing
- Bulk collect and FORALL in PL/SQL
- Limit clause for memory-efficient bulk operations
- Multitable INSERT for efficient ETL
- INSERT ALL and conditional INSERT ALL
- MERGE statement optimisation
- Filtering during data load to prevent bloat
Module 9: Performance Monitoring and Diagnostic Tools - AWR (Automatic Workload Repository) report analysis
- AWR baseline comparison for changes
- ASH (Active Session History) drill-down
- ADDM (Automatic Database Diagnostic Monitor) recommendations
- STATSPACK for older Oracle versions
- Custom performance snapshots and delta analysis
- V$ system views for real-time monitoring
- Dynamic Performance Views hierarchy
- Wait event analysis: top 20 performance killers
- Idle vs non-idle wait events
- Time model statistics and DB time breakdown
- SQL monitoring for long-running queries
- Real-time SQL monitoring with detailed reports
- Performance views for parallel execution
- Diagnostic pack licensing implications
Module 10: High-Performance PL/SQL and Stored Procedures - PL/SQL optimisation: avoiding context switches
- NOCOPY hint for large OUT parameters
- Native compilation and its performance gains
- Subprogram inlining for critical routines
- Pipelined table functions for streaming
- Conditional compilation for environment-specific logic
- Autonomous transactions and performance impact
- Exception handling best practices for speed
- Cursor variables and ref cursors efficiency
- FOR loops vs cursor FOR loops
- Implicit vs explicit cursor performance
- Caching within PL/SQL: package state
- PL/SQL function result cache
- Scalar subquery caching in SQL
- Recursion avoidance in stored logic
Module 11: High-Performance Partitioning Strategies - Range, list, hash, and composite partitioning
- Partition pruning: full vs partial
- Smart scan offloading in Exadata environments
- Partition-wise joins for large table queries
- Partition maintenance: SPLIT, MERGE, DROP
- EXCHANGE PARTITION for fast data loading
- Partition templates and interval partitioning
- Reference partitioning for parent-child tables
- System partitioning for application-controlled routing
- Partition key selection best practices
- Partition granularity: row count vs performance
- Local vs global index maintenance
- Partitioning with indexes: performance scenarios
- Partitioning in RAC environments
- Partitioning and backup strategies
Module 12: Memory and Buffer Cache Optimisation - Database buffer cache: LRU and touch count
- Multiple buffer pools: keep, recycle, default
- DB_KEEP_CACHE_SIZE and sizing guidelines
- Buffer busy waits and contention resolution
- Free buffer wait and write complete waits
- DBWR (Database Writer) process tuning
- Checkpoint tuning and its impact on I/O
- FAST_START_MTTR_TARGET configuration
- Log file sync and log buffer optimisation
- LOG_BUFFER sizing and LGWR performance
- Redo log file size and switching frequency
- Redo generation minimisation techniques
- No logging operations and recovery trade-offs
- Direct path read and buffer cache bypass
- Smart scan and Exadata offloading
Module 13: High-Performance Backup and Recovery - RMAN architecture and channel configuration
- Incremental backup strategies: level 0, 1, differential, cumulative
- Block change tracking for faster backups
- Binary compression and RMAN performance
- Parallelism in RMAN: channels and duplexing
- Backup optimization and duplicate detection
- Archivelog mode and performance overhead
- Flashback Database and restore points
- Fast recovery area (FRA) sizing and monitoring
- TSPITR (Tablespace Point-in-Time Recovery)
- Transportable tablespaces for fast cloning
- Full vs partial database recovery
- Incremental refresh for standby databases
- Backup encryption and compression trade-offs
- Monitoring RMAN job progress and bottlenecks
Module 14: High-Performance High Availability and Scalability - Data Guard configuration: physical vs logical standby
- Real-Time Apply and lag minimisation
- Switchover and failover best practices
- Active Data Guard and reporting offloading
- Fast-start failover (FSFO) setup
- RAC load balancing and service tuning
- Service failover and replay
- Database sharding for extreme scale
- Shard catalog and key distribution
- Cross-shard query optimisation
- Global query coordinator tuning
- Application continuity and replay drivers
- FAN (Fast Application Notification) integration
- Load balancing advisory and service metrics
- Maximum availability architecture (MAA) principles
Module 15: High-Performance Cloud and Hybrid Deployments - Oracle Cloud Infrastructure (OCI) database deployment
- Autonomous Database performance considerations
- Exadata Cloud Service tuning
- Storage performance in cloud environments
- Network bandwidth and latency tuning
- Cloud backup and snapshot strategies
- Hybrid connectivity: on-prem to cloud
- GoldenGate replication for hybrid performance
- Latency-aware application design
- Cloud licensing and cost-performance trade-offs
- Instance sizing: OCPU, memory, storage
- Auto-scaling and performance thresholds
- Cloud monitoring integration
- Performance tuning in containerised Oracle
- Database as a Service (DBaaS) optimisation
Module 16: Certification, Implementation, and Next Steps - Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service
- SQL execution flow: parse, execute, fetch phases
- Understanding the cost-based optimizer (CBO)
- Rule-based vs cost-based: when each applies
- Reading and interpreting execution plans
- EXPLAIN PLAN, DBMS_XPLAN, and SQL Trace
- Access methods: full table scan vs index scan vs fast full scan
- Join methods: nested loop, hash join, sort merge join
- Join order and driving table selection
- Optimizer statistics: gathering, locking, and monitoring
- Dynamic sampling for missing statistics
- Cardinality estimation and histogram strategies
- SQL hints: when and how to use safely
- SQL profile creation and deployment
- SQL plan baseline implementation
- Adaptive execution plans and their impact
- SQL Plan Management (SPM) for stability
- Parallel execution and DOP (degree of parallelism) tuning
- Automatic Degree of Parallelism (Auto DOP)
- PQ distribution methods and skew handling
- Parallel query hints and session control
Module 5: Advanced Indexing for High-Volume Workloads - Index compression efficiency analysis
- Index rebuilding for space reclamation
- Index monitoring during application peak loads
- Function-based index design for complex filters
- Virtual column indexes for computed expressions
- Spatial index tuning for GIS applications
- Text index optimisation for Oracle Text
- Index-organized tables (IOT) for primary key-heavy access
- Overflow segments and PCTTHRESHOLD tuning
- Secondary indexes on IOTs: performance trade-offs
- Bitmap index usage in mixed OLTP/DW environments
- Bitmap index concurrency limitations and workarounds
- Index key length and entry size optimisation
- Index maintenance during bulk operations
- Index rebuild automation scripts
Module 6: High-Performance Schema Design and Normalisation - Normalisation levels and performance trade-offs
- Denormalisation guidelines for read-heavy systems
- Surrogate vs natural key performance impact
- Sequence number caching for high-insert scenarios
- Identity columns and their performance implications
- Referential integrity and constraint enforcement costs
- Deferrable constraints for batch processing
- Check constraints and expression evaluation
- Materialised view design for query offloading
- Incremental refresh strategies for materialised views
- Fast refresh eligibility and logs
- Query rewrite optimisation and tuning
- Materialised view logs and overhead management
- Prebuilt tables and with rowid optimisation
- SUMMARIES and aggregation performance
Module 7: Concurrency and Lock Management - Oracle locking mechanisms: row-level, table-level, DML locks
- Enqueue wait analysis using V$SESSION_WAIT
- Deadlock detection and resolution
- Lock escalation avoidance strategies
- FOR UPDATE WAIT and NOWAIT clause usage
- Skip locked rows for high-concurrency queues
- Transaction isolation levels and performance
- Read consistency and undo segment usage
- Undo retention tuning for long-running queries
- ORA-1555 snapshot too old prevention
- Lock contention monitoring scripts
- Library cache lock and pin optimisation
- Cursor duration and parse locks
- DDL locking and online operations
- Resumable space allocation for large DDL
Module 8: High-Performance Data Loading and Bulk Operations - SQL*Loader: direct path vs conventional path
- Direct path insert and its redo implications
- PARTITION clause usage for targeted loading
- Append hint and NOLOGGING mode for speed
- Parallel data loading with multiple SQL*Loader sessions
- External table performance tuning
- Preprocessing scripts for external data
- CTAS (Create Table As Select) performance guidelines
- Batch commit frequency and rollback segment sizing
- Bulk collect and FORALL in PL/SQL
- Limit clause for memory-efficient bulk operations
- Multitable INSERT for efficient ETL
- INSERT ALL and conditional INSERT ALL
- MERGE statement optimisation
- Filtering during data load to prevent bloat
Module 9: Performance Monitoring and Diagnostic Tools - AWR (Automatic Workload Repository) report analysis
- AWR baseline comparison for changes
- ASH (Active Session History) drill-down
- ADDM (Automatic Database Diagnostic Monitor) recommendations
- STATSPACK for older Oracle versions
- Custom performance snapshots and delta analysis
- V$ system views for real-time monitoring
- Dynamic Performance Views hierarchy
- Wait event analysis: top 20 performance killers
- Idle vs non-idle wait events
- Time model statistics and DB time breakdown
- SQL monitoring for long-running queries
- Real-time SQL monitoring with detailed reports
- Performance views for parallel execution
- Diagnostic pack licensing implications
Module 10: High-Performance PL/SQL and Stored Procedures - PL/SQL optimisation: avoiding context switches
- NOCOPY hint for large OUT parameters
- Native compilation and its performance gains
- Subprogram inlining for critical routines
- Pipelined table functions for streaming
- Conditional compilation for environment-specific logic
- Autonomous transactions and performance impact
- Exception handling best practices for speed
- Cursor variables and ref cursors efficiency
- FOR loops vs cursor FOR loops
- Implicit vs explicit cursor performance
- Caching within PL/SQL: package state
- PL/SQL function result cache
- Scalar subquery caching in SQL
- Recursion avoidance in stored logic
Module 11: High-Performance Partitioning Strategies - Range, list, hash, and composite partitioning
- Partition pruning: full vs partial
- Smart scan offloading in Exadata environments
- Partition-wise joins for large table queries
- Partition maintenance: SPLIT, MERGE, DROP
- EXCHANGE PARTITION for fast data loading
- Partition templates and interval partitioning
- Reference partitioning for parent-child tables
- System partitioning for application-controlled routing
- Partition key selection best practices
- Partition granularity: row count vs performance
- Local vs global index maintenance
- Partitioning with indexes: performance scenarios
- Partitioning in RAC environments
- Partitioning and backup strategies
Module 12: Memory and Buffer Cache Optimisation - Database buffer cache: LRU and touch count
- Multiple buffer pools: keep, recycle, default
- DB_KEEP_CACHE_SIZE and sizing guidelines
- Buffer busy waits and contention resolution
- Free buffer wait and write complete waits
- DBWR (Database Writer) process tuning
- Checkpoint tuning and its impact on I/O
- FAST_START_MTTR_TARGET configuration
- Log file sync and log buffer optimisation
- LOG_BUFFER sizing and LGWR performance
- Redo log file size and switching frequency
- Redo generation minimisation techniques
- No logging operations and recovery trade-offs
- Direct path read and buffer cache bypass
- Smart scan and Exadata offloading
Module 13: High-Performance Backup and Recovery - RMAN architecture and channel configuration
- Incremental backup strategies: level 0, 1, differential, cumulative
- Block change tracking for faster backups
- Binary compression and RMAN performance
- Parallelism in RMAN: channels and duplexing
- Backup optimization and duplicate detection
- Archivelog mode and performance overhead
- Flashback Database and restore points
- Fast recovery area (FRA) sizing and monitoring
- TSPITR (Tablespace Point-in-Time Recovery)
- Transportable tablespaces for fast cloning
- Full vs partial database recovery
- Incremental refresh for standby databases
- Backup encryption and compression trade-offs
- Monitoring RMAN job progress and bottlenecks
Module 14: High-Performance High Availability and Scalability - Data Guard configuration: physical vs logical standby
- Real-Time Apply and lag minimisation
- Switchover and failover best practices
- Active Data Guard and reporting offloading
- Fast-start failover (FSFO) setup
- RAC load balancing and service tuning
- Service failover and replay
- Database sharding for extreme scale
- Shard catalog and key distribution
- Cross-shard query optimisation
- Global query coordinator tuning
- Application continuity and replay drivers
- FAN (Fast Application Notification) integration
- Load balancing advisory and service metrics
- Maximum availability architecture (MAA) principles
Module 15: High-Performance Cloud and Hybrid Deployments - Oracle Cloud Infrastructure (OCI) database deployment
- Autonomous Database performance considerations
- Exadata Cloud Service tuning
- Storage performance in cloud environments
- Network bandwidth and latency tuning
- Cloud backup and snapshot strategies
- Hybrid connectivity: on-prem to cloud
- GoldenGate replication for hybrid performance
- Latency-aware application design
- Cloud licensing and cost-performance trade-offs
- Instance sizing: OCPU, memory, storage
- Auto-scaling and performance thresholds
- Cloud monitoring integration
- Performance tuning in containerised Oracle
- Database as a Service (DBaaS) optimisation
Module 16: Certification, Implementation, and Next Steps - Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service
- Normalisation levels and performance trade-offs
- Denormalisation guidelines for read-heavy systems
- Surrogate vs natural key performance impact
- Sequence number caching for high-insert scenarios
- Identity columns and their performance implications
- Referential integrity and constraint enforcement costs
- Deferrable constraints for batch processing
- Check constraints and expression evaluation
- Materialised view design for query offloading
- Incremental refresh strategies for materialised views
- Fast refresh eligibility and logs
- Query rewrite optimisation and tuning
- Materialised view logs and overhead management
- Prebuilt tables and with rowid optimisation
- SUMMARIES and aggregation performance
Module 7: Concurrency and Lock Management - Oracle locking mechanisms: row-level, table-level, DML locks
- Enqueue wait analysis using V$SESSION_WAIT
- Deadlock detection and resolution
- Lock escalation avoidance strategies
- FOR UPDATE WAIT and NOWAIT clause usage
- Skip locked rows for high-concurrency queues
- Transaction isolation levels and performance
- Read consistency and undo segment usage
- Undo retention tuning for long-running queries
- ORA-1555 snapshot too old prevention
- Lock contention monitoring scripts
- Library cache lock and pin optimisation
- Cursor duration and parse locks
- DDL locking and online operations
- Resumable space allocation for large DDL
Module 8: High-Performance Data Loading and Bulk Operations - SQL*Loader: direct path vs conventional path
- Direct path insert and its redo implications
- PARTITION clause usage for targeted loading
- Append hint and NOLOGGING mode for speed
- Parallel data loading with multiple SQL*Loader sessions
- External table performance tuning
- Preprocessing scripts for external data
- CTAS (Create Table As Select) performance guidelines
- Batch commit frequency and rollback segment sizing
- Bulk collect and FORALL in PL/SQL
- Limit clause for memory-efficient bulk operations
- Multitable INSERT for efficient ETL
- INSERT ALL and conditional INSERT ALL
- MERGE statement optimisation
- Filtering during data load to prevent bloat
Module 9: Performance Monitoring and Diagnostic Tools - AWR (Automatic Workload Repository) report analysis
- AWR baseline comparison for changes
- ASH (Active Session History) drill-down
- ADDM (Automatic Database Diagnostic Monitor) recommendations
- STATSPACK for older Oracle versions
- Custom performance snapshots and delta analysis
- V$ system views for real-time monitoring
- Dynamic Performance Views hierarchy
- Wait event analysis: top 20 performance killers
- Idle vs non-idle wait events
- Time model statistics and DB time breakdown
- SQL monitoring for long-running queries
- Real-time SQL monitoring with detailed reports
- Performance views for parallel execution
- Diagnostic pack licensing implications
Module 10: High-Performance PL/SQL and Stored Procedures - PL/SQL optimisation: avoiding context switches
- NOCOPY hint for large OUT parameters
- Native compilation and its performance gains
- Subprogram inlining for critical routines
- Pipelined table functions for streaming
- Conditional compilation for environment-specific logic
- Autonomous transactions and performance impact
- Exception handling best practices for speed
- Cursor variables and ref cursors efficiency
- FOR loops vs cursor FOR loops
- Implicit vs explicit cursor performance
- Caching within PL/SQL: package state
- PL/SQL function result cache
- Scalar subquery caching in SQL
- Recursion avoidance in stored logic
Module 11: High-Performance Partitioning Strategies - Range, list, hash, and composite partitioning
- Partition pruning: full vs partial
- Smart scan offloading in Exadata environments
- Partition-wise joins for large table queries
- Partition maintenance: SPLIT, MERGE, DROP
- EXCHANGE PARTITION for fast data loading
- Partition templates and interval partitioning
- Reference partitioning for parent-child tables
- System partitioning for application-controlled routing
- Partition key selection best practices
- Partition granularity: row count vs performance
- Local vs global index maintenance
- Partitioning with indexes: performance scenarios
- Partitioning in RAC environments
- Partitioning and backup strategies
Module 12: Memory and Buffer Cache Optimisation - Database buffer cache: LRU and touch count
- Multiple buffer pools: keep, recycle, default
- DB_KEEP_CACHE_SIZE and sizing guidelines
- Buffer busy waits and contention resolution
- Free buffer wait and write complete waits
- DBWR (Database Writer) process tuning
- Checkpoint tuning and its impact on I/O
- FAST_START_MTTR_TARGET configuration
- Log file sync and log buffer optimisation
- LOG_BUFFER sizing and LGWR performance
- Redo log file size and switching frequency
- Redo generation minimisation techniques
- No logging operations and recovery trade-offs
- Direct path read and buffer cache bypass
- Smart scan and Exadata offloading
Module 13: High-Performance Backup and Recovery - RMAN architecture and channel configuration
- Incremental backup strategies: level 0, 1, differential, cumulative
- Block change tracking for faster backups
- Binary compression and RMAN performance
- Parallelism in RMAN: channels and duplexing
- Backup optimization and duplicate detection
- Archivelog mode and performance overhead
- Flashback Database and restore points
- Fast recovery area (FRA) sizing and monitoring
- TSPITR (Tablespace Point-in-Time Recovery)
- Transportable tablespaces for fast cloning
- Full vs partial database recovery
- Incremental refresh for standby databases
- Backup encryption and compression trade-offs
- Monitoring RMAN job progress and bottlenecks
Module 14: High-Performance High Availability and Scalability - Data Guard configuration: physical vs logical standby
- Real-Time Apply and lag minimisation
- Switchover and failover best practices
- Active Data Guard and reporting offloading
- Fast-start failover (FSFO) setup
- RAC load balancing and service tuning
- Service failover and replay
- Database sharding for extreme scale
- Shard catalog and key distribution
- Cross-shard query optimisation
- Global query coordinator tuning
- Application continuity and replay drivers
- FAN (Fast Application Notification) integration
- Load balancing advisory and service metrics
- Maximum availability architecture (MAA) principles
Module 15: High-Performance Cloud and Hybrid Deployments - Oracle Cloud Infrastructure (OCI) database deployment
- Autonomous Database performance considerations
- Exadata Cloud Service tuning
- Storage performance in cloud environments
- Network bandwidth and latency tuning
- Cloud backup and snapshot strategies
- Hybrid connectivity: on-prem to cloud
- GoldenGate replication for hybrid performance
- Latency-aware application design
- Cloud licensing and cost-performance trade-offs
- Instance sizing: OCPU, memory, storage
- Auto-scaling and performance thresholds
- Cloud monitoring integration
- Performance tuning in containerised Oracle
- Database as a Service (DBaaS) optimisation
Module 16: Certification, Implementation, and Next Steps - Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service
- SQL*Loader: direct path vs conventional path
- Direct path insert and its redo implications
- PARTITION clause usage for targeted loading
- Append hint and NOLOGGING mode for speed
- Parallel data loading with multiple SQL*Loader sessions
- External table performance tuning
- Preprocessing scripts for external data
- CTAS (Create Table As Select) performance guidelines
- Batch commit frequency and rollback segment sizing
- Bulk collect and FORALL in PL/SQL
- Limit clause for memory-efficient bulk operations
- Multitable INSERT for efficient ETL
- INSERT ALL and conditional INSERT ALL
- MERGE statement optimisation
- Filtering during data load to prevent bloat
Module 9: Performance Monitoring and Diagnostic Tools - AWR (Automatic Workload Repository) report analysis
- AWR baseline comparison for changes
- ASH (Active Session History) drill-down
- ADDM (Automatic Database Diagnostic Monitor) recommendations
- STATSPACK for older Oracle versions
- Custom performance snapshots and delta analysis
- V$ system views for real-time monitoring
- Dynamic Performance Views hierarchy
- Wait event analysis: top 20 performance killers
- Idle vs non-idle wait events
- Time model statistics and DB time breakdown
- SQL monitoring for long-running queries
- Real-time SQL monitoring with detailed reports
- Performance views for parallel execution
- Diagnostic pack licensing implications
Module 10: High-Performance PL/SQL and Stored Procedures - PL/SQL optimisation: avoiding context switches
- NOCOPY hint for large OUT parameters
- Native compilation and its performance gains
- Subprogram inlining for critical routines
- Pipelined table functions for streaming
- Conditional compilation for environment-specific logic
- Autonomous transactions and performance impact
- Exception handling best practices for speed
- Cursor variables and ref cursors efficiency
- FOR loops vs cursor FOR loops
- Implicit vs explicit cursor performance
- Caching within PL/SQL: package state
- PL/SQL function result cache
- Scalar subquery caching in SQL
- Recursion avoidance in stored logic
Module 11: High-Performance Partitioning Strategies - Range, list, hash, and composite partitioning
- Partition pruning: full vs partial
- Smart scan offloading in Exadata environments
- Partition-wise joins for large table queries
- Partition maintenance: SPLIT, MERGE, DROP
- EXCHANGE PARTITION for fast data loading
- Partition templates and interval partitioning
- Reference partitioning for parent-child tables
- System partitioning for application-controlled routing
- Partition key selection best practices
- Partition granularity: row count vs performance
- Local vs global index maintenance
- Partitioning with indexes: performance scenarios
- Partitioning in RAC environments
- Partitioning and backup strategies
Module 12: Memory and Buffer Cache Optimisation - Database buffer cache: LRU and touch count
- Multiple buffer pools: keep, recycle, default
- DB_KEEP_CACHE_SIZE and sizing guidelines
- Buffer busy waits and contention resolution
- Free buffer wait and write complete waits
- DBWR (Database Writer) process tuning
- Checkpoint tuning and its impact on I/O
- FAST_START_MTTR_TARGET configuration
- Log file sync and log buffer optimisation
- LOG_BUFFER sizing and LGWR performance
- Redo log file size and switching frequency
- Redo generation minimisation techniques
- No logging operations and recovery trade-offs
- Direct path read and buffer cache bypass
- Smart scan and Exadata offloading
Module 13: High-Performance Backup and Recovery - RMAN architecture and channel configuration
- Incremental backup strategies: level 0, 1, differential, cumulative
- Block change tracking for faster backups
- Binary compression and RMAN performance
- Parallelism in RMAN: channels and duplexing
- Backup optimization and duplicate detection
- Archivelog mode and performance overhead
- Flashback Database and restore points
- Fast recovery area (FRA) sizing and monitoring
- TSPITR (Tablespace Point-in-Time Recovery)
- Transportable tablespaces for fast cloning
- Full vs partial database recovery
- Incremental refresh for standby databases
- Backup encryption and compression trade-offs
- Monitoring RMAN job progress and bottlenecks
Module 14: High-Performance High Availability and Scalability - Data Guard configuration: physical vs logical standby
- Real-Time Apply and lag minimisation
- Switchover and failover best practices
- Active Data Guard and reporting offloading
- Fast-start failover (FSFO) setup
- RAC load balancing and service tuning
- Service failover and replay
- Database sharding for extreme scale
- Shard catalog and key distribution
- Cross-shard query optimisation
- Global query coordinator tuning
- Application continuity and replay drivers
- FAN (Fast Application Notification) integration
- Load balancing advisory and service metrics
- Maximum availability architecture (MAA) principles
Module 15: High-Performance Cloud and Hybrid Deployments - Oracle Cloud Infrastructure (OCI) database deployment
- Autonomous Database performance considerations
- Exadata Cloud Service tuning
- Storage performance in cloud environments
- Network bandwidth and latency tuning
- Cloud backup and snapshot strategies
- Hybrid connectivity: on-prem to cloud
- GoldenGate replication for hybrid performance
- Latency-aware application design
- Cloud licensing and cost-performance trade-offs
- Instance sizing: OCPU, memory, storage
- Auto-scaling and performance thresholds
- Cloud monitoring integration
- Performance tuning in containerised Oracle
- Database as a Service (DBaaS) optimisation
Module 16: Certification, Implementation, and Next Steps - Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service
- PL/SQL optimisation: avoiding context switches
- NOCOPY hint for large OUT parameters
- Native compilation and its performance gains
- Subprogram inlining for critical routines
- Pipelined table functions for streaming
- Conditional compilation for environment-specific logic
- Autonomous transactions and performance impact
- Exception handling best practices for speed
- Cursor variables and ref cursors efficiency
- FOR loops vs cursor FOR loops
- Implicit vs explicit cursor performance
- Caching within PL/SQL: package state
- PL/SQL function result cache
- Scalar subquery caching in SQL
- Recursion avoidance in stored logic
Module 11: High-Performance Partitioning Strategies - Range, list, hash, and composite partitioning
- Partition pruning: full vs partial
- Smart scan offloading in Exadata environments
- Partition-wise joins for large table queries
- Partition maintenance: SPLIT, MERGE, DROP
- EXCHANGE PARTITION for fast data loading
- Partition templates and interval partitioning
- Reference partitioning for parent-child tables
- System partitioning for application-controlled routing
- Partition key selection best practices
- Partition granularity: row count vs performance
- Local vs global index maintenance
- Partitioning with indexes: performance scenarios
- Partitioning in RAC environments
- Partitioning and backup strategies
Module 12: Memory and Buffer Cache Optimisation - Database buffer cache: LRU and touch count
- Multiple buffer pools: keep, recycle, default
- DB_KEEP_CACHE_SIZE and sizing guidelines
- Buffer busy waits and contention resolution
- Free buffer wait and write complete waits
- DBWR (Database Writer) process tuning
- Checkpoint tuning and its impact on I/O
- FAST_START_MTTR_TARGET configuration
- Log file sync and log buffer optimisation
- LOG_BUFFER sizing and LGWR performance
- Redo log file size and switching frequency
- Redo generation minimisation techniques
- No logging operations and recovery trade-offs
- Direct path read and buffer cache bypass
- Smart scan and Exadata offloading
Module 13: High-Performance Backup and Recovery - RMAN architecture and channel configuration
- Incremental backup strategies: level 0, 1, differential, cumulative
- Block change tracking for faster backups
- Binary compression and RMAN performance
- Parallelism in RMAN: channels and duplexing
- Backup optimization and duplicate detection
- Archivelog mode and performance overhead
- Flashback Database and restore points
- Fast recovery area (FRA) sizing and monitoring
- TSPITR (Tablespace Point-in-Time Recovery)
- Transportable tablespaces for fast cloning
- Full vs partial database recovery
- Incremental refresh for standby databases
- Backup encryption and compression trade-offs
- Monitoring RMAN job progress and bottlenecks
Module 14: High-Performance High Availability and Scalability - Data Guard configuration: physical vs logical standby
- Real-Time Apply and lag minimisation
- Switchover and failover best practices
- Active Data Guard and reporting offloading
- Fast-start failover (FSFO) setup
- RAC load balancing and service tuning
- Service failover and replay
- Database sharding for extreme scale
- Shard catalog and key distribution
- Cross-shard query optimisation
- Global query coordinator tuning
- Application continuity and replay drivers
- FAN (Fast Application Notification) integration
- Load balancing advisory and service metrics
- Maximum availability architecture (MAA) principles
Module 15: High-Performance Cloud and Hybrid Deployments - Oracle Cloud Infrastructure (OCI) database deployment
- Autonomous Database performance considerations
- Exadata Cloud Service tuning
- Storage performance in cloud environments
- Network bandwidth and latency tuning
- Cloud backup and snapshot strategies
- Hybrid connectivity: on-prem to cloud
- GoldenGate replication for hybrid performance
- Latency-aware application design
- Cloud licensing and cost-performance trade-offs
- Instance sizing: OCPU, memory, storage
- Auto-scaling and performance thresholds
- Cloud monitoring integration
- Performance tuning in containerised Oracle
- Database as a Service (DBaaS) optimisation
Module 16: Certification, Implementation, and Next Steps - Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service
- Database buffer cache: LRU and touch count
- Multiple buffer pools: keep, recycle, default
- DB_KEEP_CACHE_SIZE and sizing guidelines
- Buffer busy waits and contention resolution
- Free buffer wait and write complete waits
- DBWR (Database Writer) process tuning
- Checkpoint tuning and its impact on I/O
- FAST_START_MTTR_TARGET configuration
- Log file sync and log buffer optimisation
- LOG_BUFFER sizing and LGWR performance
- Redo log file size and switching frequency
- Redo generation minimisation techniques
- No logging operations and recovery trade-offs
- Direct path read and buffer cache bypass
- Smart scan and Exadata offloading
Module 13: High-Performance Backup and Recovery - RMAN architecture and channel configuration
- Incremental backup strategies: level 0, 1, differential, cumulative
- Block change tracking for faster backups
- Binary compression and RMAN performance
- Parallelism in RMAN: channels and duplexing
- Backup optimization and duplicate detection
- Archivelog mode and performance overhead
- Flashback Database and restore points
- Fast recovery area (FRA) sizing and monitoring
- TSPITR (Tablespace Point-in-Time Recovery)
- Transportable tablespaces for fast cloning
- Full vs partial database recovery
- Incremental refresh for standby databases
- Backup encryption and compression trade-offs
- Monitoring RMAN job progress and bottlenecks
Module 14: High-Performance High Availability and Scalability - Data Guard configuration: physical vs logical standby
- Real-Time Apply and lag minimisation
- Switchover and failover best practices
- Active Data Guard and reporting offloading
- Fast-start failover (FSFO) setup
- RAC load balancing and service tuning
- Service failover and replay
- Database sharding for extreme scale
- Shard catalog and key distribution
- Cross-shard query optimisation
- Global query coordinator tuning
- Application continuity and replay drivers
- FAN (Fast Application Notification) integration
- Load balancing advisory and service metrics
- Maximum availability architecture (MAA) principles
Module 15: High-Performance Cloud and Hybrid Deployments - Oracle Cloud Infrastructure (OCI) database deployment
- Autonomous Database performance considerations
- Exadata Cloud Service tuning
- Storage performance in cloud environments
- Network bandwidth and latency tuning
- Cloud backup and snapshot strategies
- Hybrid connectivity: on-prem to cloud
- GoldenGate replication for hybrid performance
- Latency-aware application design
- Cloud licensing and cost-performance trade-offs
- Instance sizing: OCPU, memory, storage
- Auto-scaling and performance thresholds
- Cloud monitoring integration
- Performance tuning in containerised Oracle
- Database as a Service (DBaaS) optimisation
Module 16: Certification, Implementation, and Next Steps - Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service
- Data Guard configuration: physical vs logical standby
- Real-Time Apply and lag minimisation
- Switchover and failover best practices
- Active Data Guard and reporting offloading
- Fast-start failover (FSFO) setup
- RAC load balancing and service tuning
- Service failover and replay
- Database sharding for extreme scale
- Shard catalog and key distribution
- Cross-shard query optimisation
- Global query coordinator tuning
- Application continuity and replay drivers
- FAN (Fast Application Notification) integration
- Load balancing advisory and service metrics
- Maximum availability architecture (MAA) principles
Module 15: High-Performance Cloud and Hybrid Deployments - Oracle Cloud Infrastructure (OCI) database deployment
- Autonomous Database performance considerations
- Exadata Cloud Service tuning
- Storage performance in cloud environments
- Network bandwidth and latency tuning
- Cloud backup and snapshot strategies
- Hybrid connectivity: on-prem to cloud
- GoldenGate replication for hybrid performance
- Latency-aware application design
- Cloud licensing and cost-performance trade-offs
- Instance sizing: OCPU, memory, storage
- Auto-scaling and performance thresholds
- Cloud monitoring integration
- Performance tuning in containerised Oracle
- Database as a Service (DBaaS) optimisation
Module 16: Certification, Implementation, and Next Steps - Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service
- Final performance audit checklist
- Production readiness assessment
- Performance regression testing framework
- Change control and deployment validation
- Ongoing performance monitoring plan
- KPIs for high-performance database systems
- Performance tuning documentation template
- Rehearsing performance presentations for leadership
- Building a personal Oracle performance portfolio
- Preparing for Oracle certification exams
- Resume and LinkedIn optimisation for performance roles
- Engaging with performance communities and forums
- Advanced reading and Oracle white papers
- Lifetime access to updated tuning playbooks
- Final assessment and Certificate of Completion issuance by The Art of Service