Oracle Performance Tuning Course

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

(4.45)

19 Courses

196 Students

2901 Reviews

Ram Niwas Sangwan

I have spent 27 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 Digital Marketing, Website Design and Development, Software Development with more than 1200 Satisfied Client. Currently I am managing My Own Production Servers with more than 500 Live Websites and Launching my Dream Project www.theskillpedia.com after working on for more than 4 Years.