Streams Pool
New to Oracle 10g, the streams pool is sized by using the initialization parameter STREAMS_
POOL_SIZE. The streams pool holds data and control structures to support the Oracle Streams
feature of Oracle Enterprise Edition. Oracle Streams manages the sharing of data and events
in a distributed environment. If the initialization parameter STREAMS_POOL_SIZE is uninitialized
or set to zero, the memory used for Streams operations is allocated from the shared pool and
may use up to 10 percent of the shared pool. For more information on Oracle Streams, see
Chapter 17.
Chapter 1: Getting Started with the Oracle Architecture 35
Program Global Area
The Program Global Area is an area of memory allocated and private for one process. The
configuration of the PGA depends on the connection configuration of the Oracle database:
either shared server or dedicated.
In a shared server configuration, multiple users share a connection to the database, minimizing
memory usage on the server, but potentially affecting response time for user requests. In a shared
server environment, the SGA holds the session information for a user instead of the PGA. Shared
server environments are ideal for a large number of simultaneous connections to the database
with infrequent or short-lived requests.
In a dedicated server environment, each user process gets its own connection to the database;
the PGA contains the session memory for this configuration.
Pages:
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115