34.6 LIST_PAGE_VIEWS Procedure

This procedure emits a report of the most recent Oracle APEX requests which had debug enabled.

Syntax

APEX_INSTANCE_DEBUG.LIST_PAGE_VIEWS (
    p_session_id             IN              NUMBER DEFAULT NULL,
    p_max_rows               IN              NUMBER DEFAULT 30,
    p_show_d2                IN              BOOLEAN DEFAULT FALSE);

Parameters

Parameter	Description
p_session_id	Optionally restrict output to the given APEX session.
p_max_rows	Restrict output to the given number of rows (default 30). The value must be between 1 and 10,000.
p_show_d2	If TRUE, emit @d2 prefix before page view IDs, to easily copy/paste in SQL. The d1.sql and ds.sql scripts set this parameter.

Example

List 30 most recent page views.

SQL> set lines 190 serveroutput on size unlimited
SQL> exec apex_instance_debug.list_page_views;