Re: Oracle10G error!!!!

On 29 Oct 2004 06:56:03 -0700, spraveen2001_at_yahoo.com (Praveen) wrote:

>Hi
>
>If i connect from sqlplus prompt, it is working fine. but if java is
>trying to connect, then it is saying following error...
>
>(java.sql.SQLException: ORA-00604: error occurred at recursive SQL
>level 3
>ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
>pool","select
>/*+ rule */ bucket_cn...","Typecheck heap","kgghteInit")
>
>What might be the problem?

Your shared pool is ridiculously small. Also, by setting explicitly the shared pool, you won't be using automatic pool management anymore. You need to set db_cache_size, and remove large_pool_size, shared_pool_size, java_pool_size and db_block_buffers.

--
Sybrand Bakker, Senior Oracle DBA