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