Pasha,
I am no expert in replication. But it looks like there is not enough memory
left in the box to address this. Since you are getting ORA-600, try scanning
your alert.log at
http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. It
could be a bug, I don't know. Sorry I am not of much help here.

You may also want to search Metalink or log an iTAR with Oracle.

Regards,

- Kirti Deshpande
Verizon Information Services
http://www.superpages.com

> -----Original Message-----
> From: Pasha, Ajaz [SMTP:Ajaz.[Email Address Removed] Sent: Friday, June 29, 2001 12:28 PM
> To: LazyDBA.com Discussion
> Subject: Out of Process Memory
>
> Hi Kirti,
>
> Getting following error message, when refresh takes place on replication
> site
> BEGIN DBMS_REFRESH.REFRESH ('PIRSREP_REFRESH'); END;
>
> *
> ERROR at line 1:
> ORA-04030: out of process memory when trying to allocate 125012 bytes
> (callheap,KQL tmpbuf)
> ORA-00600: internal error code, arguments: [18090], [16737], [], [], [],
> [],
> [], []
> ORA-12008: error in snapshot refresh path
> ORA-04030: out of process memory when trying to allocate 65056 bytes (RPC
> Heap,RPC Heap)
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674
> ORA-06512: at "SYS.DBMS_IREFRESH", line 577
> ORA-06512: at "SYS.DBMS_REFRESH", line 211
> ORA-06512: at line 1
>
> Oracle Database : 8.1.7.1.3
> Operation System : Windows NT 4
> The table getting replicated has about 500 thousands records containnig
> CLOB
> data.
> It works fine with 10,000 records.
>
>
> Ajaz
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page