Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_SHARED_POOL, 2 of 5
This procedure shows objects in the shared_pool
that are larger than the specified size. The name of the object is also given, which can be used as an argument to either the KEEP
or UNKEEP
calls below.
DBMS_SHARED_POOL.SIZES ( minsize NUMBER);
Parameter | Description |
---|---|
minsize |
Size, in kilobytes, over which an object must be occupying in the shared pool, in order for it to be displayed. |
Issue the SQLDBA or SQLPLUS 'SET
SERVEROUTPUT
ON
SIZE
XXXXX'
command prior to using this procedure so that the results are displayed.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|