Re: Trigger on redo log switch?
Date: Sun, 16 Mar 2008 07:26:24 -0700 (PDT)
On 16 mar, 02:40, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote innews:19af45f7-a98e-4905-93ff-aceea05e7da1_at_8g2000hsu.googlegroups.com:
> > On Mar 15, 2:15 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> >> Oracle 10GR2 -
> >> How can I get custom PL/SQL to be invoked upon every redo logfile
> >> switch?
> > Why?
> > David Fitzjarrell
> So a manual Data Guard like implementation can be achieved
> & I'd prefer to avoid the overhead of polling.
Not that I really like the overall idea, but if you want to limit the polling overhead inside Oracle, you might want to code a system script that would check the switch events by reading the alert.log (sort of tail -f | grep). The overhead would be limited. Received on Sun Mar 16 2008 - 09:26:24 CDT