DBMS_Shared_pool

[mcampb9713]

Hi,

Does anyone have the procedures down or can point me to the procedures
for using the DBMS_shared_pool package? I want to allow Pl/SQL objects
and SQL cursors to be pinned (kept) in the Oracle shared pool.


Thanks

[tomate]

Hi
the paket dbms_shared_pool contains 3 procedures.
dbms_shared_pool.keep
dbms_shared_pool.unkeep
dbms_shared_pool.size


dbms_shared_pool.keep(name VARCHAR2, flag CHAR default 'P');
That means:
name: The name of the object. This means the name of an pakets or an SQL-instruction.
flag: The type of the object. If flag has the value P, then the name should be of a pakets. If flag has the value C, then the name should be of a cusor. If flag has the value S, then the name should be of a sequence. If flag has the value R, then the name should be of a trigger.

dbms_shared_pool.unkeep(name VARCHAR2, flag CHAR default 'P');

dbms_shared_pool.size(minsize NUMBER);

Regards
Thomas Schmidt