Skip to Main Content
This is a BETA environment
This environment is only for testing and may be reset multiple times during the testing period. We will be frequently upgrading this BETA environment, so check back often for changes. Please assist us by providing feedback via the bug icon to the left of your profile avatar. For the current active community, visit

Problem with apex_activity_log in Apex 4.1

Gianluigi TrentoOct 13 2011 — edited Oct 13 2011
in the login page of our apex demo we make this query:

select max(ip_address)
into va_address
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.

Any idea?


Gianluigi Trento

Edited by: Gianluigi Trento on 13-ott-2011 10.36
Post Details
Added on Oct 13 2011