Re: Trigger on redo log switch?

From: <vitalisman_at_gmail.com>
Date: Sun, 16 Mar 2008 07:26:24 -0700 (PDT)
Message-ID: <fd0849da-5f0b-4d11-9545-7e8d07938bde@x41g2000hsb.googlegroups.com>


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

Original text of this message