Re: 10gR2 Trigger on redo log switch?

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

Ahbaid

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?

--
http://www.freelists.org/webpage/oracle-l