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
I'm stmontgo and I approve of this message
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
Oracle DBA Resources | Oracle DBA Forums | | Oracle Usenet newsgroups
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.
Forum Rules