Re: Looking for a scalable solution for many DB links

Hi Paul,

You should consider security as you would now potentially have one database with easy connections to all of the other databases in your organisation. So you may have security with firewalls stopping you pushing data but if someone gains access to this monitoring database you are building they will have access to all of the others. You should take great care to screw down this database very tightly!. See many links about Oracle security documents, papers, presentations and checklists on my site http://www.petefinnigan.com/orasec.htm

From a performance point of view just because you are monitoring 100 databases does it necessarily mean that you access all 100 databases simultaneously? - probably you can schedule your monitoring tasks to keep only a smaller subset of links open at any one time. You can also close database links after use, look at "alter session" command.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.