SQL> select FND_PROFILE.VALUE_SPECIFIC('LSH:ENABLE_DEBUGGING') from dual;
FND_PROFILE.VALUE_SPECIFIC('LSH:ENABLE_DEBUGGING')
--------------------------------------------------------------------------------
$YESNO$NO
SQL> select FND_PROFILE.VALUE_SPECIFIC('DMW:USER_DEBUGGING') from dual;
FND_PROFILE.VALUE_SPECIFIC('DMW:USER_DEBUGGING')
Note:
After you install Oracle DMW, you sign in and navigate to the
Administration page and click the Tracing & Logging tab to see that you
disabled logging and tracing in Active Sessions.