2.
select name,type,code_size
from dba_object_size
where name in ('DBMS_PIPE','STANDARD','DBMS_OUTPUT')
select name,type,code_size
from dba_object_size
where name in ('DBMS_PIPE','STANDARD','DBMS_OUTPUT')
当使用PL/SQL对象时,ORACLE将其存储在SGA区的共享SQL区的库缓内.
要想让PL/SQL对象留在内存里,应该在系统一启动后就将它们加载到SGA中.
使用DBMS_SHARED_POOL程序包.
1.对PL/SQL程序包重新编译
2.SQL>alter package appowner.add_client complie;
SQL>execute DBMS_SHARED_POOL.KEEP('appowner.add_client','P');
'P'表示程序包.另外:
使用DBMS_SHARED_POOL.UNKEEP程序把对象从内存里移走.
SQL> execute DBMS_SHARED_POOL.UNKEEP('appowner.add_client');