Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to get a log of all previous snap shot refresh times?

How to get a log of all previous snap shot refresh times?

From: Bala Muru <muru321_at_yahoo.com>
Date: Mon, 11 Dec 2000 15:15:01 -0800 (PST)
Message-Id: <10707.124257@fatcity.com>


Hello Lists,

I have NT4.0 and Oracle 8.1.5.1.1 with one master and several slaves. Each slave has 15 snapshots refreshing every night during off-production hours. To monitor these snapshots, I require a script which will show me a log of all snapshot refresh times including the last refresh time, so that I can be sure the slaves refreshed without eny errors such as network etc. I am not sure, if this can be obtained from any of the available dictionary tables such as
all_snapshot_refresh_times (which shows only the last refresh time). To my knowledge, this will require few customized table and triggers. Am I right?

If you can share your idea on how this can be achieved, I will greatly appreciate it. Any level of input is most welcome.

Thanks in advance,
Muru



Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ Received on Mon Dec 11 2000 - 17:15:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US