LIST_ACTIVITY Procedure

This script prints recent activity log entries.

Syntax

APEX_INSTANCE_DEBUG.LIST_ACTIVITY (
    p_from_date      IN DATE     DEFAULT sysdate-5,
    p_to_date        IN DATE     DEFAULT sysdate,
    p_app_id         IN NUMBER   DEFAULT NULL,
    p_page_id        IN NUMBER   DEFAULT NULL,
    p_workspace_name IN VARCHAR2 DEFAULT NULL,
    p_session_id     IN NUMBER   DEFAULT NULL,
    p_user           IN VARCHAR2 DEFAULT NULL,
    p_ip_address     IN VARCHAR2 DEFAULT NULL,
    p_not_ip_address IN VARCHAR2 DEFAULT NULL,
    p_error          IN VARCHAR2 DEFAULT NULL,
    p_debug          IN NUMBER   DEFAULT NULL );

Paramaters

Parameter	Description
`p_from_date`	Start date/time of log entries (default sysdate - 5 min).
`p_to_date`	Start date/time of log entries (default `sysdate`).
`p_app_id`	Restrict to the given application ID (default null).
`p_page_id`	Restrict to the given application ID (default null).
`p_workspace_name`	Restrict to the given workspace name (default null).
`p_session_id`	Restrict to the given session ID (default null).
`p_user`	Restrict to the given user (default null).
`p_ip_address`	Restrict to log entries which match the given IP address using LIKE (default null).
`p_not_ip_address`	Restrict to log entries which do not match the given IP address using LIKE (default null).
`p_error`	Restrict to log entries which match the given p_error using LIKE (default null).
`p_debug`	Restrict to log entries with debug level `<= p_debug` (default null).

Example

List activity log entries of the last two days which had errors.

exec apex_instance_debug.list_activity(p_from_date=>sysdate-2,p_error=>'%')

34.4 LIST_ACTIVITY Procedure