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
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.
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.