ORA-04031 ORA-04031out of shared memory when trying to allocate num bytes (str) Cause:More shared memory is needed than was allocated in the SGA. Action:Reduce use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameter SHARED_POOL_SIZE. ________________________________________
D:\Oracle\admin\OraName\pfile\init.ora
----------------(数据库目录)
OraName 是数据库名
pfile 是文件夹.
init.ora 是文件(可以用 "记事本" 来打开)找到 shared_pool_size 就可以把它的值设大些啦(起码要大于 8132 呀 :) )
shared_pool_size
java_pool_size
large_poo_size
亦可查询v$sgastat视图获取内存结构信息。