Re: Trigger on redo log switch?

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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org