Home » RDBMS Server » Server Administration » ORA-04031: unable to allocate 1024 bytes of shared memory
ORA-04031: unable to allocate 1024 bytes of shared memory [message #52732] Thu, 08 August 2002 23:18 Go to next message
mani
Messages: 105
Registered: September 1999
Senior Member
Hi,
I have created some 10 procedures each of having 3600 lines.Now i have created one procedure to call all the above ten procedures.

but am getting the following error while creating the last procedure....

CREATE OR REPLACE PROCEDURE PROC_URT_CITY_BUILD_TABLE IS
*
ERROR at line 1:
ORA-04031: unable to allocate 1024 bytes of shared memory ("shared
pool","PROC_URT_CITY_ML_LRATT","PL/SQL DIANA","PAR.C:parapt:Page")

Any idea...
Thanks in advance
Mani

Report message to a moderator

Re: ORA-04031: unable to allocate 1024 bytes of shared memory [message #52736 is a reply to message #52732] Fri, 09 August 2002 05:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There are many things, that you need to look into solve this.
to start with, use the dbms_shared_pool package to pin
large packages/procedures or increase the amount of
shared memory by increasing the value of the SHARED_POOL_SIZE.
If the above wont help, pls post your oracle version,OS information etc.

Report message to a moderator

Re: ORA-04031: unable to allocate 1024 bytes of shared memory [message #52752 is a reply to message #52732] Sun, 11 August 2002 17:12 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Mani,

It is all explained Here

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

unable to allocate 1024 bytes of shared memory [message #53645 is a reply to message #52736] Thu, 03 October 2002 04:17 Go to previous messageGo to next message
ashish
Messages: 107
Registered: December 2000
Senior Member
My Oracle version is as follows
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

and the OS is
Windows NT SERVER 4.0

I have modified all the necessary parameters in the init.ora file i.e. the shared_pool_size etc.
Even then i am getting the same error.
Please help.

Report message to a moderator

Re: unable to allocate 1024 bytes of shared memory [message #53646 is a reply to message #52736] Thu, 03 October 2002 04:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
when are u getting this error? whats the scenario?
when create Java stored procedures or JVM or wat?

Report message to a moderator

Re: unable to allocate 1024 bytes of shared memory [message #53666 is a reply to message #52736] Thu, 03 October 2002 21:48 Go to previous message
Manu Gupta
Messages: 44
Registered: January 2002
Member
I got the same error and the reason was my system was infected by virus. I don't know why but after cleaning my system using antivirus it run. Give it a try.

Report message to a moderator

Previous Topic: Help!Oracle shutdown script /etc/rc0.d errors out!
Next Topic: Re: @hfclconnect.com
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 00:23:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.