RE: How to know which are the snapshots suposed to be getting ref

From: Fowler, Kenneth R <kenneth_r_fowler_at_groton.pfizer.com>
Date: Wed, 07 Mar 2001 17:39:51 -0800
Message-ID: <F001.002C68E2.20010307165536@fatcity.com>

Version of oracle?? I know from personal that 8.1.6 has problems with snapshot logs not being purged.

-----Original Message-----
Sent: Wednesday, March 07, 2001 4:17 PM
To: Multiple recipients of list ORACLE-L refreshed from master?

Hello Forumists,

How to know which are the snapshots supposingly to get refreshed from the master? In my situation, I have around 40 databases refreshing from a single master and seems to be all the 40 databases' snapshots are getting refreshed. So, why my snapshot still grows without purging automatically is the question. If I manually purge the snapshots using
dbms_snapshot.purge() procedure then, I have to make a COMPLETE refresh for all these snapshots which will involve more efforts. So, I would like to know if there is a way to find which are the snapshots supposed to refresh from master. Perhaps there is a way to find this out at the master using some dictionary tables etc..which I am not aware of. If anybody has an idea please let me know.

Thank you very much,
Muru

---

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Muru
  INET: muru_oracle_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Fowler, Kenneth R
  INET: kenneth_r_fowler_at_groton.pfizer.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 07 2001 - 19:39:51 CST