Re: 10gR2 Trigger on redo log switch?
Date: Sat, 15 Mar 2008 22:50:06 -0700
Aside from why, I don't know if there is a db trigger that can be created on a redo log switch.
You could try monitoring v$log under the status column to see when a switch occurs or monitor v$loghist, externally you could monitor your alert log.
hope this helped
sol beach wrote:
> I want to invoke some custom PL/SQL after every redo logfile switch.
> If/how can a "trigger" be created to fire after every redo logfile switch?