Oracle Database Discussions

Hi Gurus,

There is an error in my alert log File suddenly application is not worked on that time i restarted the server and then i checked that alert log there is some error here i attached the errors below.

--------------------------------------------------------------------------------------------------------

Errors in file c:\Oracle\Proddb\8.1.7\admin\PROD\udump\ORA07532.TRC:
ORA-04030: out of process memory when trying to allocate 67108 bytes (pga heap,ksm stack)
ORA-04030: out of process memory when trying to allocate 8512 bytes (pga heap,ksm stack)
ORA-04030: out of process memory when trying to allocate 8512 bytes (pga heap,ksm stack)
ORA-04030: out of process memory when trying to allocate 117372 bytes (PLS non-lib hp,PL/SQL STACK)

Tue Jul 13 14:26:46 2010
Errors in file c:\Oracle\Proddb\8.1.7\admin\PROD\udump\ORA07532.TRC:
ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 67108 bytes (pga heap,ksm stack)
ORA-04030: out of process memory when trying to allocate 8512 bytes (pga heap,ksm stack)
ORA-04030: out of process memory when trying to allocate 8512 bytes (pga heap,ksm stack)
ORA-04030: out of process memory when trying to allocate 117372 bytes (PLS non-lib hp,PL/SQL STACK)
--------------------------------------------------------------------------------------------------------------------------------------------



after i restarted the server after two hours same problem occurs but on that time the alertlog file error is

-----------------------

Errors in file c:\Oracle\Proddb\8.1.7\admin\PROD\bdump\prodLGWR.TRC:
ORA-00472: PMON process terminated with error

Tue Jul 13 14:28:32 2010
Errors in file c:\Oracle\Proddb\8.1.7\admin\PROD\bdump\prodDBW0.TRC:
ORA-00472: PMON process terminated with error

--------------------------





Application working fine for past 2 months but before coming this error i run gather schema statistics

schema name :ALL
Priority :40

i run this request at the time of clients are in logoff only.

Regards

***SBJ***