• 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

The Skill Pedia not just prepare you for the exam but also covers lot of other topics which are...Read more

Derrick O.

Linux Administrator

Certificate Code

Who’s Online

There are no users currently online

Last Tweets

Error retrieving tweets
top
WhatsApp chat
X