select SCHEMANAME, OSUSER, MACHINE, PROGRAM from V$SESSION where SCHEMA# > 0

Connect time(ms): 63

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 31

SCHEMANAME|OSUSER|MACHINE|PROGRAM
WCUSER|Lawrence L Jett Jr|LarrySERVER|JDBC Thin Client
WCUSER|Lawrence L Jett Jr|LarrySERVER|JDBC Thin Client
WCUSER|Lawrence L Jett Jr|LarrySERVER|JDBC Thin Client
WCUSER|Lawrence L Jett Jr|LarrySERVER|JDBC Thin Client
WCUSER|Lawrence L Jett Jr|LarrySERVER|JDBC Thin Client
SYSTEM|Lawrence L Jett Jr|LarrySERVER|JDBC Thin Client

