select distinct a.session_id,a.session_serial#,c.username,c.osuser,c.machine,c.program,a.sql_ID,B.SQL_TEXT
from v$active_session_history a,v$sqlarea b ,v$session c
where a.sql_id=b.sql_id
and a.session_id=c.sid
and upper(a.WAIT_CLASS)='CONFIGURATION'
order by b.sql_text
from v$active_session_history a,v$sqlarea b ,v$session c
where a.sql_id=b.sql_id
and a.session_id=c.sid
and upper(a.WAIT_CLASS)='CONFIGURATION'
order by b.sql_text