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

SCHEMANAME	OSUSER	MACHINE	PROGRAM
SYSTEM	jettl	lfpplm	JDBC Thin Client