SELECT
s.saddr,
s.sid,
s.serial#,
s.username,
s.lockwait,
s.status,
s.schemaname,
s.process,
s.machine,
s.program,
s.logon_time,
s.event,
s.wait_time,
sql.sql_t,
sql.sql_i,
sql.SHARA,
sql.OPTIM ,
sql.OPTIM ,
sql.CPU_T
FROM
v$session s,
v$sql sql
WHERE
s.sql_id=sql.sql_i
and s.username = 'schema';