Oracle 8i: Tuning and Troubleshooting, Part One
Price: $ 109.00 (USD)
Add to Cart
Have a question about this course? .
Course Description
Oracle 8i: Tuning and Troubleshooting, Part One
Course Type: Self-paced Courses
Estimated Time of Completion: 8 hour(s) 47 minutes
CEU Credits:
Language: English
Description: In this course you will learn about Oracle performance tuning, database utilities, the data dictionary, and the buffer cache.
Objectives:
Introduction to Oracle Performance Tuning
The Oracle Performance Pack
The Tuning Process
The Various Roles in the Tuning Process
Managing Workloads in Different Environments
Tuning Database Configuration
The Parameter File
Optimum Flexible Architecture (OFA)
RAID and File Striping
Tuning the Background Processes
Tuning SQL Statements
Examining SQL Statements
The Oracle Optimizer
Tuning Index Usage
Database Utilities and The Data Dictionary
The Data Dictionary and Dynamic Performance Views
The UTLBSTAT and ULTESTAT Scripts
The Alert Log and Background Process Trace Files
SQL Trace and TKPROF
The Buffer Cache
Managing the Buffer Cache
The Multi-Part Buffer Pool
Back to Top
Course Type: Self-paced Courses
Estimated Time of Completion: 8 hour(s) 47 minutes
CEU Credits:
Language: English
Description: In this course you will learn about Oracle performance tuning, database utilities, the data dictionary, and the buffer cache.
Objectives:
· After completing this course you will be able to tune database configurations and SQL statements.
· Browser Netscape Communicator 4.0
· Browser Other: AOL 4.0
· Operating System MacOS 8.5
· Browser Microsoft Internet Explorer 4.0
· Operating System MS-Windows 95
Introduction to Oracle Performance Tuning
The Oracle Performance Pack
The Tuning Process
The Various Roles in the Tuning Process
Managing Workloads in Different Environments
Tuning Database Configuration
The Parameter File
Optimum Flexible Architecture (OFA)
RAID and File Striping
Tuning the Background Processes
Tuning SQL Statements
Examining SQL Statements
The Oracle Optimizer
Tuning Index Usage
Database Utilities and The Data Dictionary
The Data Dictionary and Dynamic Performance Views
The UTLBSTAT and ULTESTAT Scripts
The Alert Log and Background Process Trace Files
SQL Trace and TKPROF
The Buffer Cache
Managing the Buffer Cache
The Multi-Part Buffer Pool
More Information
| Language | English |
| Course Length | 8.00 hours |
| Duration of Access | 12 weeks |
| Instructor | Self Study |
| Vendor | Element K |
Price: $ 109.00 (USD)
Add to Cart