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