| ORA-4031 [message #108924] |
Sat, 19 February 2005 23:20  |
ravish agarwal
Messages: 2
Registered: February 2005
|
Junior Member |
|
|
Hi all,
We are using oracle 8.1.7 enterprise edition. I am getting a Ora - 4031 while making insertions in a particular table. when I try to insert values in other tables it is working fine. There is absolutely no problem with shared pool or large pool size. can any one help.
|
|
|
|
| Re: ORA-4031 [message #108986 is a reply to message #108924] |
Mon, 21 February 2005 04:02  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
If you don't want to increase your shared pool without further investigation, use the DBMS_SHARED_POOL.SIZES(minsize) procedure to see what is in your shared pool, and how much memory is used by each object.
You can run dbmspool.sql and prvtpool.plb to create the DBMS_SHARED_POOL package.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
