Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_SHARED_POOL, 5 of 5
This procedure sets the aborted request threshold for the shared pool.
DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( threshold_size NUMBER);
An exception is raised if the threshold is not in the valid range.
Usually, if a request cannot be satisfied on the free list, then the RDBMS tries to reclaim memory by freeing objects from the LRU list and checking periodically to see if the request can be fulfilled. After finishing this step, the RDBMS has performed a near equivalent of an 'ALTER
SYSTEM
FLUSH
SHARED_POOL
'.
Because this impacts all users on the system, this procedure "localizes" the impact to the process failing to find a piece of shared pool memory of size greater than thresh_hold
size. This user gets the 'out of memory' error without attempting to search the LRU list.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|