 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 4 -
Real Application Cluster Architecture
Large Pool
This area is only used if shared server
architecture (multi-threaded server - MTS) is used, or if parallel
query is utilized. The large pool holds the user global areas when
MTS is used and holds the parallel query execution message queues
for parallel query.
In general, large pool provides memory
allocations for:
Streams Pool
This is a new area in Oracle Database 10g that
is used to provide buffer areas for the streams components of
Oracle. To configure the Streams pool explicitly, you need to
specify the size of the pool in bytes using the STREAMS_POOL_SIZE
initialization parameter. If the size of the Streams pool is greater
than zero, then any SGA memory used by Streams is allocated from the
Streams pool. If the size of the Streams Pool is zero or not
specified, then the memory used by Streams is allocated from the
shared pool and may use up to 10% of the shared pool.
The above text is
an excerpt from:
Oracle 10g Grid & Real Application
Clusters
Oracle 10g
Grid
Computing with RAC
ISBN 0-9744355-4-6
by Mike Ault, Madhu Tumma
Oracle Consulting Services
Burleson Oracle Consulting offers Senior Oracle consultants which are available
for all areas of Oracle support. Common Oracle consulting support
activities include short-term Oracle tuning, Oracle database troubleshooting,
Oracle9i and Oracle10g migration,
Oracle9iAS App Server
consulting, Oracle design reviews and
Oracle requirements evaluation support. Oracle support and Oracle consulting
services are priced by the hour, so you only pay for what you need. These
one-time Oracle consulting services commonly include:
-
Answering questions from your Oracle DBA technical staff
-
Repairing down production Oracle database systems
-
One-time Oracle tuning evaluation
-
Guru support for your Oracle DBA
-
Installation of Oracle application packages
For more information, please visit
www.dba-oracle.com
or email
info@remote-dba.net.
|
