오라클자바커뮤니티에서 설립한 오엔제이프로그래밍 실무교육센터
(신입사원채용무료교육, 오라클SQL, 튜닝, 힌트,자바프레임워크, 안드로이드, 아이폰, 닷넷)
SQL> exec dbms_shared_pool.unkeep('7856AC4C, 1137127237','c');
PL/SQL 처리가 정상적으로 완료되었습니다.
SQL> select distinct name, sharable_mem, loads
2 from v$db_object_cache
3 where name like '%emp%'
4 and kept = 'YES';
결과가 없겠죠…
아래는 DBMS_SHARED_POOL.keep procedure 명셉니다… 메타링크 자료니 참고 하세요…
PROCEDURE:DBMS_SHARED_POOL.KEEP
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Version/s: 7.1+, 8.0, 8.1
See Also: [NOTE:67537.1] The Purpose of DB Package Reference Articles
[NOTE:67569.1] DBMS_SHARED_POOL Package Description
Specification:
procedure keep(name varchar2, flag char DEFAULT 'P');
Description:
Keep an object in the shared pool. Once an object has been keeped in
the shared pool, it is not subject to aging out of the pool. This
may be useful for certain semi-frequently used large objects since
when large objects are brought into the shared pool, a larger
number of other objects (much more than the size of the object
being brought in, may need to be aged out in order to create a
contiguous area large enough.
WARNING: This procedure may not be supported in the future when
and if automatic mechanisms are implemented to make this
unnecessary.
Input arguments:
name
The name of the object to keep. There are two kinds of objects:
PL/SQL objects, triggers, sequences which are specified by name,
and SQL cursor objects which are specified by a two-part number
(indicating a location in the shared pool). For example:
dbms_shared_pool.keep('scott.hispackage')
will keep package HISPACKAGE, owned by SCOTT. The names for
PL/SQL objects follows SQL rules for naming objects (i.e.,
delimited identifiers, multi-byte names, etc. are allowed).
A cursor can be keeped by
dbms_shared_pool.keep('0034CDFF, 20348871')
The complete hexadecimal address must be in the first 8 characters.
The value for this identifier is the concatonation of the
'address' and 'hash_value' columns from the v$sqlarea view. This
is displayed by the 'sizes' call above.
Currently 'TABLE' and 'VIEW' objects may not be keeped.
flag
This is an optional parameter. If the parameter is not specified,
the package assumes that the first parameter is the name of a
package/procedure/function and will resolve the name. It can also
be set to 'P' or 'p' to fully specify that the input is the name
of a package/procedure/function.
Other FLAG options are:
'T' or 't' to specify that the input is the name of a type.
'R' or 'r' to specify that the input is the name of a trigger
'Q' or 'q' to specify that the input is the name of a sequence.
other In case the first argument is a cursor address and
hash-value, the parameter should be set to any
character except 'P','p','Q','q','R','r','T' or 't'.
Exceptions:
An exception will raised if the named object cannot be found.
댓글 없음:
댓글 쓰기