Previous Next JavaScript must be enabled to correctly display this content

## 24.2.7 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.

Related Topics

- SET_PARAMETER Procedure in Oracle APEX API Reference

Parent topic: Utilizing Debug Mode