slow ICX_SESSIONS statement
R12.2 on Linux
A given statement on a standard eBS objects is very slow (about 1 minute per query):
select to_char(last_connect,'dd/mm/yyyy hh24:mi') last_connect
, usr.user_name
, resp.responsibility_key
, function_type fntype
, (SYSDATE-last_connect)*24*60 Mins_Idle
, (select node_name from fnd_nodes nod where nod.node_id = icx.node_id) node_name
from apps.icx_sessions icx
join apps.fnd_user usr on usr.user_id=icx.user_id
left join apps.fnd_responsibility resp on resp.responsibility_id=icx.responsibility_id
where last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24
and disabled_flag != 'Y' and pseudo_flag = 'N'