Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Listing all Oracle instances in UNIX
You can use ps -ef | grep -i smon to see which ones are running
-- Regards Steve janet <janet_at_telesph.com> wrote in article <32A301C2.713_at_telesph.com>...Received on Tue Dec 03 1996 - 00:00:00 CST
> Hi,
> How, using unix, does one list all existing
> instances (ORACLE_SIDs)? There _MUST_ be a way!
>
> I am just trying to monitor them to make sure
> too many don't get created.
>
> thanks in advance!
> janet
>