Hi Guys,

There is nothing in the DBWR trc file. CKPT trc file has the following info

CKPT trc

2002--4-17 11:14:17.703
Session id:(4.1) 2002-04-17 11:14:17.703
error 4030 detected in background process.

And there was another trace file ora????.trc its contents are as follows


2002--4-17 9:27:47.859
Session id:(13.104) 2002-04-17 9:27:47.843
*****start PLSQL runtime dump *******
got ora-4030 while running PLSQL anonymous block

*****End of PLSQL runtime dump

It looks like the plsql anonymous block has created this problem. Is there a way to avoid this kind of thing repeating.
The server is win2k and has 4Gig of memory and Oracle is configured to use around 1.1Gig. Any inputs will be apreciated. Thanks in advance.

Thanks,
error 4030 detected in background process.