Problem with apex_activity_log in Apex 4.1
in the login page of our apex demo http://apex.oracle.com/pls/otn/f?p=23873:1 we make this query:
from apex_activity_log log
where userid = 'APEX_PUBLIC_USER'
and session_id = :APP_SESSION
and nvl(ip_address,'#') <> '#';
With Apex 4.0 there were no problems but with Apex 4.1 this query is very very slow and page freeze.
Edited by: Gianluigi Trento on 13-ott-2011 10.36