author:skatetime:2009/04/14这篇文章不错，记录一下EXP-00008: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory ("s......
SQL> execute dbms_shared_pool.keep('DBMS_PICKLER'); SQL> select OWNER, name, sharable_mem,kept,EXECUTIONS from v$db_object_cache where kept = 'YES' ORDER BY sharable_mem; SQL> alter system flush shared_pool; System altered.
SQL> SELECT POOL,BYTES FROM V$SGASTAT WHERE NAME ='free memory';
POOL BYTES ----------- ---------- shared pool 7742756 large pool 614400 java pool 32768
[oracle@ali-solution oracle]$ sh /home/oracle/admin/dbexp.sh
