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: getting instance-name

Re: getting instance-name

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: 2000/05/14
Message-ID: <391EF3E6.E6E25A9@0800-einwahl.de>#1/1

Hi Harald,

in 8.1.5 you can call the function

dbms_utility.active_instances

and

dbms_utility.current_instance

Martin

Harald Mitterhofer wrote:
>
> hi!
>
> is there a way to query the instance-name of the database in a
> pl/sql-procedure running as a normal (non-dba-privileged) user?
> I guess there is some system-view, but cannot find it;
>
> thanx;
> mitt
Received on Sun May 14 2000 - 00:00:00 CDT

Original text of this message

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