Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problems with refresh
Welcome.
We have distributed database (Oracle 7) with one master site and several snaphot sites. We had to suspend one of the snapshot sites. The problem is that master site still generate logs for suspended site. Our log table (mlog$_<table_name>) is growing which couse that refresh other sites is very slow (mlog$_.. table contains 2000000 records). Does anyone knows how to turn off snapshot site ? I can't delete all snaphots because this base is suspend only temporary.
Maybe somebody could send me complete descripton of refresh mechanism. I want detailed description with role of each system table (in schemas SYS and SYSTEM). --
Łukasz Rzepa
programista
ComArch SA
ul.Czarnowiejska 66 tel: +48 12 4234570 fax: +48 12 6339229
30-054 Kraków
mailto:rzepa_at_ComArch.PL http://www.comarch.plReceived on Thu Oct 08 1998 - 07:05:19 CDT
___________________________________________________________________