Lesson 1
Course introduction
As an Oracle DBA, it is important to remember that your Oracle databases
exist within a computer network. Environmental factors such as CPU, RAM, and network communications all influence the performance of your Oracle databases. Essentially there are three environmental factors that affect Oracle performance:
- Memory consumption on your machine
- CPU consumption on your machine
- I/O between your database server and your disk devices
The focus of this course will be to show you how you can take advantage of all the UNIX-based tools for monitoring, configuring, and tuning the
external environment.
For those of you who are not using a UNIX environment, remember that the principles addressed in this course apply to systems on NT or MVS or
any other system. The external environment that an Oracle instance runs in may be unique in terms of hardware platforms, but the concepts
discussed here will be generic to all of them.
Course goals
After completing the course, you will be able to:
- Address general tuning issues related to the operating system
- Tune Disk I/O for optimal performance
- Tune the operating system to reduce memory usage
- Tune for effective CPU usage
- Reorganize tables to improve I/O performance
- Configure and monitor an Oracle listener
- Tune with the Multi-Threaded Server for external connections
How you will learn
In this course, you will learn and practice Oracle tuning concepts with three kinds of applets: the diagram, the Slide Show.
For additional information on these and other applets, see the Course Orientation.
The series
Tuning the External Oracle Environment is the fourth of five courses in the
First-time students: To get the most out of this course, take the Course Orientation.
The next lesson is about prerequisites to this course.