ORA-04030

Hi

Yesterday we have got this error in application console.Then i checked database 
but it was hanged.It did not allow me to open new sesion through sysdba also to 
check any parameters .
The error was like 

java.sql.SQLException: ORA-04030: out of process memory when trying to allocate
4012 bytes (callheap,bind var buf)

java.sql.SQLException: ORA-04030: out of process memory when trying to allocate
16396 bytes (hash-join subh,QERHJ Bit vector)

As databse was hanged and could not do shutdown immediate , we have to stop it 
from Services.

Where was the problem? What should we do so thet this error does not arise 
again?

Regards
Swathi

You are most likely running out of memory on your physical server (hardware).

If you are on 10g and above check the following parameter: PGA_AGGREGATE_TARGET 
try to lower it's value.

Bottom line -- you have to either:

  a) reduce process level memory consumption (tune SQL)
  b) install more memory on the server
  d) do both a) and b)

Try going to the server itself and using the good old sqlplus (unix/linux 
example follows):

## get an idea of memory consumption (again unix)
## if on Windows use Task Manager ...
##
vmstat 1 10

## bounce the database if you have to (unix/linux example)
##
sqlplus /nolog
connect / as sysdba
shutdown abort
startup

-HTH

Hi

We are using Windows 2003 server and Oracle 9.0.2.0.8 version
pga_aggregate_targer is set to 500MB.Should this be decreased?

also we are using /3GB switch in boot.ini file.

Regards
Swathi

Check the task manager to see how much memory is being utilized and by which 
process.  If you are running out of memory on the server then yes you'll either 
have to decrease it's consumption or add more physical RAM ...