slow icx_session query on unused database

We're using an SQL statement that is functionally OK, but which takes around 30 seconds, 1 minute to complete, on Production, but also on all non-productions databases, which are very much unused. In fact, I've never ever seen it go fast, no matter what the circumstances, no matter what environment. Acceptable for me is 5 to 10 seconds. This is the query in question: 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