My first reaction would be to check your shared pool / sga size. You may want to increase it.

Gurmohan
www.onlymath.com - Place to learn and teach math.




-----Original Message-----
From: Ezekiel Filane
[mailto:oracledba-ezmlmshield-x58309071.[Email address protected]
Sent: Sunday, January 29, 2006 7:16 AM
To: LazyDBA Discussion
Subject: ORA-04031: unable to allocate 4032 bytes of shared memory



Hi There

Unable to drop user PDMP ...I get the below error pls help.

SQL> drop user PDMPcascade;
drop user PDMPRD cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4032 bytes of shared memory ("java
pool","java/io/ObjectStreamClassSYS","joxlod exec
hp","SGAClass")

Thanks
Ezekiel.



--------------------------------------------------------------------------------
Please note: This e-mail and its contents are subject to a disclaimer
which can be viewed at http://www.woolworths.co.za/disclaimer. Should
you be unable to access the link please e-mail [Email address protected]
and a copy of the disclaimer will be e-mailed to you.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page