How to monitor the instance activity on Oracle
statement o monitor the instance activity
Execute the following query to monitor the instance activity
col SERVER format a15
col ACTIVITY format a10
select host_name SERVER, status ACTIVITY from v$instance;
exit;