ORA-04031: unable to allocate 1784 bytes of shared memory ("large pool","unknown object","
I got the following message:
Failed to connect to database instance: ORA-04031: unable to allocate 1784 bytes of shared memory ("large pool","unknown object","session heap","kpuinit env handle") (DBD ERROR: OCISessionBegin).
Severity=Critical
This is test database. In production we have 500 mb in shared_pool and 300 mb in large_pool.
In Uat we have 1 gb shared_pool and 112 mb in large_pool.
What I did is in Test - I re-distributed 400 mb in large_pool and 800 mb to the shared_pool.
Also I saw note # 4118188.8 (Bug) which mentioned that jdbc connections uses large pool for dedicated connections.
This query returns the following jdbc connections from test: In test instead of "NONE" you see "DEDICATED".
Failed to connect to database instance: ORA-04031: unable to allocate 1784 bytes of shared memory ("large pool","unknown object","session heap","kpuinit env handle") (DBD ERROR: OCISessionBegin).
Severity=Critical
This is test database. In production we have 500 mb in shared_pool and 300 mb in large_pool.
In Uat we have 1 gb shared_pool and 112 mb in large_pool.
What I did is in Test - I re-distributed 400 mb in large_pool and 800 mb to the shared_pool.
Also I saw note # 4118188.8 (Bug) which mentioned that jdbc connections uses large pool for dedicated connections.
This query returns the following jdbc connections from test: In test instead of "NONE" you see "DEDICATED".
0