How do I check to see how many instances runing via sql plus? what is the command.
thanks.
Printable View
How do I check to see how many instances runing via sql plus? what is the command.
thanks.
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
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
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.