| |
 |
|
Oracle Tips by Burleson |
Chapter 2 Inside the
Oracle Shared Pool
Oracle8 introduced a new area, the large pool,
controlled by the large_pool_size parameter. In general, it is
suggested that the shared pool size start at 40 megabytes and
increase from there. The large pool size will depend on the number
of concurrent users, the number of multi-threaded server servers,
and the dispatchers and sort requirements for the application.
What should be monitored to determine if the
shared pool is too small? This information can be gleaned from the
data dictionary tables, specifically the v$sgastat and v$sqlarea views. The report below shows how
much of the shared pool is in use at any given time.
shared_pool_ora73.sql
--**********************************************
--
--
Copyright © 2003 by Rampant TechPress Inc.
--
-- Free for
non-commercial use.
-- For
commercial licensing, e-mail info@rampant.cc
--
--
*********************************************
column
shared_pool_used format 9,999.99
column
shared_pool_size format 9,999.99
column
shared_pool_avail format 9,999.99
column
shared_pool_pct format 999.99
@title80
'Shared Pool Summary'
spool
rep_out\&db\shared_pool
select
The above text is
an excerpt from:
Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts
Written by the world's top DBA and author
of over 20 Oracle books, Mike Ault shares his secrets for Oracle
DBA management scripts. This handy reference is indispensable
for all Oracle professionals who must quickly automate and
manage their Oracle databases with scripts.
This stellar book comes complete with an
online code depot full of over 200 pre-tested Oracle DBA
scripts, and covers all areas of Oracle database administration
including data files, tablespace, table and index management
scripts. Based on more than 20 years full-time experience, Mike
Ault brings his expertise to the public with this fantastic
book. Your time savings from a single script is worth the price
of this great book.
|
Mike Ault is one of the
leading names in Oracle technology. The author of 20
books and hundreds of articles in national publications,
Mike was the first popular Oracle author with his
landmark book "Oracle7 Administration and Management".
Mike also wrote several of the "Exam Cram" books, and
enjoys a reputation as a leading author and Oracle
consultant.
Mike started
working with computers in 1979 right out of a stint in
the Nuclear Navy. He began working with Oracle in 1990
and has since become a World Renowned Oracle expert (in
the words of his publisher anyway!) Mike has written 14
Oracle related books, dozens of articles, and has
presented at conferences in Europe and the USA. Mike has
two wonderful daughters and is kept out of trouble by
his wife of 29 years, Susan. |
http://www.rampant-books.com/book_2003_2_ault_internals.htm
See the Oracle script collection::
|
