SELECT COUNT(*) FROM V$SESSION WHERE USERNAME IS NOT NULL ORDER BY MACHINE;

SELECT * FROM V$SESSION WHERE USERNAME IS NOT NULL ORDER BY MACHINE;

SELECT COUNT(*) FROM V$SESSION WHERE USERNAME IS NOT NULL AND MACHINE='TEST1' ORDER BY MACHINE ;

SELECT COUNT(*) FROM V$SESSION WHERE USERNAME IS NOT NULL AND MACHINE='LOCALHOST.LOCALDOMAIN' ORDER BY MACHINE ;

SELECT * FROM V$PROCESS WHERE USERNAME IS NOT NULL ;

SELECT * FROM V$SHARED_SERVER_MONITOR ;

SELECT * FROM V$OPEN_CURSOR;

SELECT SQL_TEXT,COUNT(*) FROM V$SQL S, V$SESSION SE WHERE SE.PREV_HASH_VALUE =S.HASH_VALUE GROUP BY SQL_TEXT;

AAAAA