Pasha,

Just to add to Kirti's note, and based on the text of the error, you may be
hitting the upper limit on process memory in the NT model. By default, a
process in NT can grab upto 2Gb only. Keeping in mind that Oracle on NT is a
multi-threaded single process and all of the SGA and UGA/PGA is held by one
single process, you *may* be reaching this limit and Oracle burps with an
ORA-600. This may not be repeatable under different load conditions. The
solution would be reduce your SGA (and the
SORT_AREA_SIZE/SORT_AREA_RETAINED_SIZE) is case they are set to inordinately
high values. Another would be to check your NT System error log to see if
there was some other errors. Btw, where are replicating from/to - if the
other system is also NT, then you may want to check both systems...

John Kanagaraj

>-----Original Message-----
>From: Deshpande, Kirti [mailto:kirti.[Email Address Removed] Friday, June 29, 2001 12:11 PM
>To: LazyDBA.com Discussion
>Subject: RE: Out of Process Memory
>
>
>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/iorabugfinde
>r.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 documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepa>ge
>To
>unsubscribe: send a blank email to
>oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] 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