请高手帮忙看看这个问题,有时候sql执行时间过长,就会抛出这个异常,平时使用又没有问题。
把sql在pl/sql中执行,又不会有任何问题。java.sql.SQLException: ORA-04031: unable to allocate 8192 bytes of shared memory ("large pool","unknown object","sort subheap","sort key")
把sql在pl/sql中执行,又不会有任何问题。java.sql.SQLException: ORA-04031: unable to allocate 8192 bytes of shared memory ("large pool","unknown object","sort subheap","sort key")
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters "shared_pool_reserved_size" and "shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".