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

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