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,

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
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).

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
postedMar 7, '01 at 9:38p
activeMar 7, '01 at 9:38p

1 user in discussion

Muru: 1 post



site design / logo © 2022 Grokbase