Oracle8I Database Tuning And Troubleshooting Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 261
Course Abstract:	This course presents techniques for finding performance or configuration problems within the Oracle database and solving those problems. Manual techniques as well as those employing the specialty Packs within Oracle Enterprise Manager are considered. Workshop exercises allow participants the opportunity to examine the internal operation of an Oracle instance, isolate problems, test possible solutions and implement effective remedies.
Audience:	This course is designed for Oracle database administrators.
Duration:	3 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Avoid locking and contention problems > Tune and troubleshoot SGA buffers > Tune and troubleshoot the shared pool > Tune and troubleshoot data file configuration problems > Use utlBstat and utlEstat
Course Topics:	Designing A Tuning Approach About Server Tuning OLTP Tuning DSS Tuning Hardware/Software Platform Tuning Unix Ms Windows NT / Server Starting With A Good Configuration About Sound Database Configuration About Application Partitioning Understanding The SGA Understanding Data Files Checklists For Sound Configuration Troubleshooting Tools Collecting Statistics Using The Utlbstat & Utlestat Utilities Introduction To OEM Performance Manager Tuning The Shared Pool Library Cache Looking Inside The Library Cache Tuning The Library Cache Dbms_Shared_Pool() Package Further Shared Pool Tuning Looking Inside The Dictionary Cache Tuning The Dictionary Cache Looking Inside The Pga/Uga Tuning The Buffer Cache Looking Inside The Buffer Cache LRU Illustrated Tuning The Buffer Cache Multiple Buffer P_Ffe Overall SGA Tuning Data File I/O Tuning About I/O Tuning Troubleshooting Data Files Tuning Data Files Tuning Sorts Configuring & Tuning Undo Space Management What Is Undo Space Configuring Automatic Undo Space Management Create Database Tuning Automatic Undo Space Management Dba_Undo_Extents Tuning Rollback Segments SQL Statement & Optimizer Tuning About The Optimizer Analyze Pctfree/Pctused SQL Statement Tuning Explain Plan Tkprof Autotrace About Histograms About Bitmap Indexes Redo Log I/O Tuning About Redo Log I/O Tuning Are Redo Log Files Large Enough? Is Log_Buffer Large Enough? Contention & Locks Shared Server Parallel Execution Processes About Locks Monitoring Locks Dba_Locks The Dbms_Repair() Package Resumable Space Allocation About Resumable Space Allocation Managing Resumable Space Allocation User_Resumable View Description Implementing Special Features The OEM Diagnostics Pack The Power Of The Diagnostics Pack Capacity Planner Lock Monitor Performance Ma_Form Performance Ov_Forma Top Sessions Optional - Oracle Trace About Oracle Trace Using Oracle Trace Using Oracle Trace Data Viewer Optional - OEM Tuning Pack The Power Of The Tuning Pack Tablespace Manager SQL Analyze Oracle Expert
Prerequisites:	Introduction To Oracle8i SQL & SQLPlus Introduction To Oracle8i PL/SQL Language Introduction To Oracle8i Advanced SQL & SQLPlus Oracle8i Database Architecture & Administration - DBA I Oracle8i Database Backup & Recovery - DBA II

Oracle8I Database Tuning And Troubleshooting Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology