Re: Trigger on redo log switch?

From: DA Morgan <>
Date: Sat, 15 Mar 2008 17:43:44 -0700
Message-ID: <>

Ana C. Dent wrote:
> Oracle 10GR2 -
> How can I get custom PL/SQL to be invoked upon every redo logfile switch?

You could put substantial overhead on your system by watching gv$log with a regularly running job but I'm with Fitzjarrell on this: Why?

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Mar 15 2008 - 19:43:44 CDT

Original text of this message