Trigger on redo log switch?

#1

Oracle 10GR2 -

How can I get custom PL/SQL to be invoked upon every redo logfile switch?

#2

On Mar 15, 2:15*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:

Quote:

Oracle 10GR2 -

How can I get custom PL/SQL to be invoked upon every redo logfile switch?

Why?

David Fitzjarrell

#3

On Mar 15, 2:15*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:

Quote:

Oracle 10GR2 -

How can I get custom PL/SQL to be invoked upon every redo logfile switch?

Why?

David Fitzjarrell

#4

On Mar 15, 2:15*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:

Quote:

Oracle 10GR2 -

How can I get custom PL/SQL to be invoked upon every redo logfile switch?

Why?

David Fitzjarrell

#5

On Mar 15, 2:15*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:

Quote:

Oracle 10GR2 -

How can I get custom PL/SQL to be invoked upon every redo logfile switch?

Why?

David Fitzjarrell

#6

Ana C. Dent wrote:

Quote:

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

#7

Ana C. Dent wrote:

Quote:

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

#8

Ana C. Dent wrote:

Quote:

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

#9

Ana C. Dent wrote:

Quote:

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

#10

"fitzjarrell (AT) cox (DOT) net" <fitzjarrell (AT) cox (DOT) net> wrote in
news:19af45f7-a98e-4905-93ff-aceea05e7da1 (AT) 8g2000hsu (DOT) googlegroups.com:

Quote:

On Mar 15, 2:15*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
Oracle 10GR2 -

How can I get custom PL/SQL to be invoked upon every redo logfile
switch?

Why?

David Fitzjarrell

So a manual Data Guard like implementation can be achieved
& I'd prefer to avoid the overhead of polling.