Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out concrete ORACLE_HOME via SQL?

Re: How to find out concrete ORACLE_HOME via SQL?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 15 Aug 2006 14:19:57 -0700
Message-ID: <1155676797.934260@bubbleator.drizzle.com>


boogab00_at_yahoo.com wrote:

> DA Morgan wrote:
>> 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> set linesize 131
>>>> SQL> set pagesize 20
>>>> SQL> col host_name format a30
>>>> SQL> col home_name format a20
>>>> SQL> col home_location format a50
>>>> SQL> SELECT *
>>>> 2 FROM sysman.mgmt$software_homes;
>>> 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.org
> 
> SYSMAN has nothing to do withe StatsPack.

You're correct. I was a bit muddled and was thinking StatsPack, PerfStat, they are all Stats. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 15 2006 - 16:19:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US