Performance - EBS (MOSC)

MOSC Banner

slow ICX_SESSIONS statement

edited May 23, 2023 9:23PM in Performance - EBS (MOSC) 5 commentsAnswered ✓

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center