Oracle analysis

[Quoted] I'm currently working on a Utilty that will be used to trubleshoot our financial application. It supports Oarcle as well as SQL Server. This tool will examine the system, re-register dll's and ocx's, print their version numbers and similar things. The utility can also access Oracle using ADO.

What I want to do is to issue SQL queries that give me valuble information [Quoted] about Oracle itself. On SQL serevr I Isuue queries such as SELECT _at__at_VERSION

[Quoted] Waht do you think I should do with Oracle, what kind of information can I get. Sometimes, our customers don'y have a DBA, insted they rely on outside [Quoted] expertise which can make it difficult. Furthermore, our own Oracle expert - [Quoted] and he is very skilled, may not be at the office.. See the problem? The idea [Quoted] is that the utility should collect ALL kind of information that he would get [Quoted] over the phone and automatically detect bad settings or whatever it may be. [Quoted] Well, most of this information anyway.

Any help would be most appreciated.

Regards,
Fredrik Received on Fri Sep 21 2001 - 22:35:52 CEST