Question On Connection Metadata (hostname/port/internal name)

2010-05-27 Thread Barlow, Ed
Hi Guys For the past few years have been writing an advanced enterprise monitor for databases My database autodiscovery process is fairly good - but I have one issue. I cant figure out how to fetch the information underlying a DSN on unix - specifically I want to discover the

Re: Question On Connection Metadata (hostname/port/internal name)

2010-05-27 Thread John Scoles
Barlow, Ed wrote: Hi Guys For the past few years have been writing an advanced enterprise monitor for databases My database autodiscovery process is fairly good - but I have one issue. I cant figure out how to fetch the information underlying a DSN on unix - specifically I want to

Re: Question On Connection Metadata (hostname/port/internal name)

2010-05-27 Thread Jeffrey Seger
I don't have an Oracle database at hand at the moment, but I believe that querying v$database, v$instance and/or v$parameter should get you most of what you want in Oracle. On Wed, May 26, 2010 at 8:37 AM, Barlow, Ed ed.bar...@mlp.com wrote: Hi Guys For the past few years have been writing