Hi team ,
I need to track all the activity in oracle Apex database from apex applications …
Apart of the query that i receive from oracle support. SR 3-42329639161
is there any way to track the session info ( i could with this query ) and the SQL executed in APEX session .... ? because i have an security requeriment to audit all the apex activity from the database ….
select *
from apex_workspace_sessions s
where s.session_idle_timeout_on > sysdate
and s.session_life_timeout_on > sysdate
and user_name <> 'nobody'
and exists ( select 1
from apex_workspace_activity_log l
where l.workspace_id = s.workspace_id
and l.apex_session_id = s.apex_session_id
and l.view_date >= sysdate - 0.006944444444 -- last 10 minutes ( 1/24/60*10 )
)
order by 1