Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

djberg96 (2603)

djberg96
  (email not shown publicly)

Journal of djberg96 (2603)

Wednesday October 29, 2003
12:02 PM

DB Links

[ #15451 ]
We realized that we've been doing things in a clunky manner when it came to doing Oracle database monitoring. Originally, we just did a ping on the listener port + connection, and then a simple "select sysdate from dual" in a loop.

This is a bit expensive in that you have to create a separate connection for each database. Ok, it's not horrible, but we've found a better way - DB Links. This allows you to create a link from one database to another from *within* your table. Thus, you can make *one* connection, and then connect to the other databases via the links.

I think the drawback is that it doesn't test the listener, just the connection, but I could be wrong. Hey, I'm just learning about this, ok?

Oh, and Tora doesn't have support for DB Links yet - bummer. There is an RFE, though (#592157 on the sourceforge page if you'd like to chime in). At least TOAD supports it, though.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.