| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> How to get a log of all previous snap shot refresh times?
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
 |
 |