Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out concrete ORACLE_HOME via SQL?
NitelyJoy wrote:
>> I don't think this is about different people having different ideas of
>> their job. It is just a fact of life that there are a lot of installs
>> where internal rules, or bad DBAs, or outside vendors, move stuff all
>> over the place.
> > Absolutely right: Badly skilled DBAs and outside vendors, whose > developers never got in touch with oracle books or documentation! > Welcome in reality... :-(( >>> SQL> col home_location format a50
>> SQL> set linesize 131
>> SQL> set pagesize 20
>> SQL> col host_name format a30
>> SQL> col home_name format a20
> > I'm afraid, there are oracle installations running without the sysman > user.
That also means running without StatsPack. Not a good idea in either case.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Aug 14 2006 - 15:43:44 CDT
![]() |
![]() |