Ezekiel, on a subsequent search I have found this explanation for you:
Oracle Error :: ORA-04032
pga_aggregate_target must be set before switching to auto mode
Cause
An attempt was made to set WORKAREA_SIZE_POLICY to AUTO while PGA_AGGREGATE_TARGET is not specified.
Action
Before setting WORKAREA_SIZE_POLICY, set PGA_AGGREGATE_TARGET to a value representing the total private memory available to the instance. This total is generally the total physical memory available in the system minus what is needed for the SGA minus what is needed for the operating system (for example, such as 500 MB).
Gurmohan
www.onlymath.com - Place to learn and teach math.
-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x44936949.[Email address protected]
Sent: Sunday, January 29, 2006 9:37 AM
To: LazyDBA Discussion
Subject: RE: ORA-04031: unable to allocate 4032 bytes of shared memory
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
--------
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