| Error ORA-04031 against a query. how to fix? [message #178156] |
Mon, 19 June 2006 14:35 |
dude4084
Messages: 222
Registered: March 2005
Location: Mux
|
Senior Member |
|
|
First of my apology if i am not posting it on appropriate forum.
I have executed and re-executed the following command but failed and got this error
SQL> select * from bs_view;
*
ERROR at line 1:
ORA-04031: unable to allocate 192 bytes of shared memory ("shared pool","select * from bs_view
","Typecheck heap","qknAllocate : qkn")
SQL> /
select * from bs_view
*
ERROR at line 1:
ORA-04031: unable to allocate 20 bytes of shared memory ("shared pool","select * from bs_view
","sql area","qertbAllocatePartitioningInfo qertbph")
SQL> /
select * from bs_view
*
ERROR at line 1:
ORA-04031: unable to allocate 296 bytes of shared memory ("shared pool","select * from bs_view
","Typecheck heap","qknAllocate : qkn")
**************************************************************
All the above errors has bit different error wordings.
I read documentation and it has given me the detail as follow
**************************************************************
ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")
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 initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.
*****************************************************************
I tried to add following lines in INIT.ORA
LARGE_POOL_SIZE = 67108864
shared_pool_size = 33554432
****************************************************************
But i am failed to fix my problem.
Please guide me about understanding and solving this problem.
Thanking you
Dude
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
