Oracle Performance Tuning Course

Expert

Created by Ram Niwas Sangwan Last Updated 21/05/2018 07:41

₹39,900.00 ₹39,900.00 0.00% off

What's Included

  • 0 Lectures
  • 1 downloadable resources
  • Access on tablet and phone
  • Certificate of completion

Description

  • 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

Instructors

RN

(4.45)

21 Courses

201 Students

2809 Reviews

Ram Niwas Sangwan
I have spent 30 years in IT Industry as an Educationist. I have been a software developer/corporate trainer and an information systems specialist with a record of developing and supporting solutions incorporating a wide range of applications. I have an entrepreneurial-mindset and a track record of success in recognizing opportunities spanning more than 26 years. Developing innovative and creative approaches, I have trained top level executives of companies driving revenue growth and enhancing long-term profitability. I have been motivating my team to ensure project success and on-time delivery. I, have time and again proven my ability at managing multiple priorities in fast-paced environments.
Businessman Leading a team of Professionals in the Area of Software Development with more than 1200 Satisfied Client. Currently I am managing www.theskillpedia.com and www.skillpedia.ai