 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 7 - Tuning and Performance
Allocating too Much
Memory to the Shared Pool and Data Buffers
There is another problem that can occur that is not related to
paging and swapping. Over allocating memory to the shared pool may
cause Oracle to spend too much CPU time controlling the large memory
area. If you are experiencing poor performance problems, have high
Oracle CPU utilization and a very large shared pool, you may want to
decrease the shared pool size even if swapping and paging is not
occurring.
Conclusion
Tuning Oracle can be a challenging task.
Oracle provides the administrator with a host of tuning knobs that
are used to tailor the Oracle database environment to meet an
application’s specific processing requirements. There is a
bewildering array of tools and information that can be used to
increase the performance of an Oracle database. A review of some of
the more important points covered in this chapter should help:
-
Once again, read the Oracle Tuning and
Performance manuals.
-
Learn how to use the toolset used for
performance monitoring and performance problem identification.
Learning how to read an explain plan and understanding the
information contained in the v$ tables will give you a good start.
Follow that with STATSPACK, Oracle Tuning Pack and the Oracle
traces.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
