how do i check how many instances running?

[lofat]

How do I check to see how many instances runing via sql plus? what is the command.

thanks.

[stmontgo]

windooze or unix?

though unix you can grep for a backgroun process like PMON,
throuhg sql may you might create db links to all your instances and the query status from v$instance

[clio_usa]

That's one way ot doing it:

SQL> !ps -ef | grep ora_dbwr_ | grep -v grep | wc -l

Of course - you need to be on UNIX, or have the Win32 ports of the UNIX commands. if you need the link to these bin's - let me know.


Hope that helps,

clio_usa

OCP 8/8i/9i DBA

[onlysimon]

the cygwin 'ps' command doesn't pick it up (maybe there's a version in the windows resource kit??).

another way is to look at the output of the 'net start' command.. or look in the services applet in control panel.