Re: 10gR2 Trigger on redo log switch?

From: Ahbaid Gaffoor <>
Date: Sat, 15 Mar 2008 22:50:06 -0700
Message-ID: <>

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?

Received on Sun Mar 16 2008 - 00:50:06 CDT

Original text of this message