Hi there Ghuru's i need you help urgently please.

Every 4 Days oracle 9i Kicks out this error message.
Can anybody help? HAs anybody seen this error?

ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 8192 bytes (sort
subheap,sort key)

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 8192 bytes (sort
subheap,sort key)



Thanks Ghuru's