Oracle Performance Tuning Training

Oracle Performance Tuning Syllabus

  • Basic of Performance tuning
  • The major Components of Oracle database (Memory, CPU, Hard Disk)
  • Oracle Database Architecture.
  • Background processes.
  • Memory Structure
  • Data Files, Control Files, Log Files (Redo Log files), Archive log file.
  • Connection of Oracle database server with client server
  • Different types of Parsing methods
  • Transaction Flow of select query
  • Transaction flow of DML statements.
  • Different ways of consuming Memroy, CPU and Disc
  • Different ways of using Memory, CPU and disc to optimise the performance
  • Sub queries
  • Areas of application of suubqueries and joins.
  • Characteristics of good SQL and bad SQLs
  • Redesigning/Restructuring queries to get optimal performance
  • Activity guide that involves practices of the various concepts we had discussed so far about SQL tuning.
  • Different types of indexes
  • Index scanning methods
  • Role of indexes in performance
  • B-Tree Indexes
  • Bitmap Indexes
  • Activity guide for this indexes chapter
  • Clustered and non-clustered Indexes
  • Reverse Key indexes for performance optimization
  • Statistics gathering ( complete and partial )
  • Histogram statistics for skewed data.
  • Bind varibles
  • In SQL
  • In PL/SQL
  • High water mark.
  • Partitioning of table
  • Local and global Indexes
  • Hints
  • Temporary Tables
  • Bulk Operations in PL/SQL
  • How Block results in performance
  • Free - List
  • PCTFREE, PCTUSED
  • INITTRANSE and MAXTRANS
  • Row Chaining
  • Row Migration
  • Explain Plan
  • What is explain plan
  • How to read an explain plan
  • What to look for in an explain
  • Figuring out throw away
  • Auto Trace
  • Difference between explain plan n auto trace.
  • Tracefile
Quick Enroll