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