Know Oracle Server details from Oracle client with the help of perl

rampec has asked for the wisdom of the Perl Monks concerning the following question:

Hi guys, please help me to find out the Oracle server details from the Oracle client using perl. I have only Oracle client and I need to fetch the details of the server. I am using HP UNX BOX. Thanks

Comment on Know Oracle Server details from Oracle client with the help of perl

Replies are listed 'Best First'.
Re: Know Oracle Server details from Oracle client with the help of perl by erix (Prior) on May 27, 2005 at 19:50 UTC
V$VERSION and V$DATABASE are probably the first ones you want; there are many more. A google search for 'oracle v$ tables' will find a lot of interesting links.	[reply]
Re^2: Know Oracle Server details from Oracle client with the help of perl by Anonymous Monk on May 28, 2005 at 06:18 UTC
Thanks for your help.	[reply]
Re: Know Oracle Server details from Oracle client with the help of perl by sasikumar (Monk) on May 27, 2005 at 17:47 UTC
Hi It would be better if you could send us what you have tried so far. Else how to get the information frm client without perl. Then it would be easy for us to show a perl method of doing it. Thanks SasiKumar	[reply]