Controlling the Debug Level for an Instance

Change the default instance-wide Debug Level using the APEX_INSTANCE_ADMIN API.

For example, to set the Debug Level to Application Trace (LEVEL6), execute a statement similar to the following as SYS or the database user who has been granted the APEX_ADMINISTRATOR_ROLE database role.

BEGIN
    APEX_INSTANCE_ADMIN.SET_PARAMETER(
        p_parameter => 'SYSTEM_DEBUG_LEVEL',
        p_value     => '6');
    COMMIT;
END;

To disable instance-wide debugging, set SYSTEM_DEBUG_LEVEL parameter to NULL.

Note: The APEX engine will generate a substantial amount of debug messages when instance-wide debugging is enabled, which will impact instance and application performance. Oracle recommends enabling SYSTEM_DEBUG_LEVEL parameter only for short periods.

For more information, see:

• SET_PARAMETER Procedure in Oracle APEX API Reference