Re: How to find out concrete ORACLE_HOME via SQL?

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. Received on Tue Aug 15 2006 - 13:55:17 CDT