• Getting started with Oracle on Linux
  • Important Linux Commands, Service Configuration
  • SQL Developer connecting to linux
  • Oracle Architecture, Oracle Memory Architecture, Oracle Physical Architecture
  • Performance & Tuning: Overview & Goals
  • Tuning The Shared Pool, Tuning The Buffer Cache
  • Control Files, Redo files
  • Archive Log, No Archive Log
  • Oracle Physical Architecture
  • Tablespaces, Data files, Blocks, Extents
  • Oracle Result Cache, Query Result Cache, Function Result Cache
  • Oracle Transactions and Locks, Transactions, Isolation Levels in Oracle
  • MVCC, Deadlocks
  • Oracle Indexes, B-Tree Indexes, Bitmap Indexes, Functional Indexes, Invisible Indexes
  • Query Plans, Actual Query Plan, Estimated Query Plan, Query Statistics
  • Optimizer Modes: Rules vs Cost Based, Managing Statistics
  • SQL Optimization Using TKProf
  • Oracle Table Partitioning, Range Partitioning, List Partitioning, Hash Partitioning, Interval Partitioning, Referential Partitioning, Oracle Index Partitioning
  • Local Indexes, Global Indexes, Global Partitioned Indexes
  • Tuning SGA Structure Oracle Query Hints, Tuning SGA Structure
  • Automatic Shared Memory, SQL Hints
  • Monitoring & Re-Constructing Indexes, Monitoring Triggers & Constraints
  • Tuning Disk I/O, SQL Trace Utility
  • Materialized Views, Static Materialized Views, Refreshable Materialized Views
  • SQL Optimization Using Explain Plan, SQL Optimization Using Auto Trace
  • Advanced Performance Tuning, Tuning PGA & Temporary Space
  • Generating STATSPACK Reports, Generating UTLBSTAT & UTLESTAT, Introduction To SQL Tunning

Course Curriculum

No curriculum found !

Course Reviews

4

4
1 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Featured Testimonial

I would like to mention a new feature "Interactive Video". You can't simply watch the video. You...Read more

Indiana Jones

Co-Founder Director

Certificate Code

Who’s Online

There are no users currently online

Last Tweets

top
WhatsApp chat
X