Re: How to determine all the instances on a server

I was looking for a command that you could enter from within an SQLPLUS session so that you could do connects to different instances. Is there something like that for oracle? Sybase has a command "sp_helpdb" that can be entered from within a sql session that returns all the instances currently running on a server. Albert Borrull wrote:

> This is OS dependent. For instance:
>
> Netware 4.X: display oracle status
> Unix: ps -el | grep -i dbwr
> NT: see control-panel -> Services
> ....
>
> Randy Watts <wrwatts_at_pacbell.com> escribió en artículo
> <358004A6.B1306F71_at_pacbell.com>...
> > Is there a select statement or system command dimilar to sysbase's
> > sp_helpdb
> > that you can use to determine all the instances running on a particular
> > server
> >
> >
> >
> >

--

+++++++++++++++++++++++++++

Randy Watts
(415) 545-0444
wrwatts_at_PacBell.Com

+++++++++++++++++++++++++++