Re: How to find out concrete ORACLE_HOME via SQL?

Getting back to the initial question:
Why is there no dictionary view that gives out ORACLE_HOME and/or password file location?

Oracle has no need for "security by obscurity" as mentioned above. Nevertheless, to satisfy the safety-conscious DBAs, oracle could protect it by the SELECT ANY DICTIONARY grant and/or the 07_dictionary_accessibility pfile parameter. IMHO, the advantages (better configuation transparency) outweigh the disadvantages (maybe less security).

Thanks to all of you for participating the discussion. Good luck for your DBA work. Received on Mon Aug 14 2006 - 14:52:58 CDT