select *
from v$sqlarea
where sql_id in (select sql_id
from v$session
where username = 'GJK'
and status = 'ACTIVE'
and program != 'plsqldev.exe')
order by elapsed_time desc;
from v$sqlarea
where sql_id in (select sql_id
from v$session
where username = 'GJK'
and status = 'ACTIVE'
and program != 'plsqldev.exe')
order by elapsed_time desc;