OBIEE11g - Enable Log-Level from Advanced Tab

In the Advanced tab, Add below tag in the prefix and click Apply SQL.

SET VARIABLE LOG_LEVEL = 2;

Log from Administration > Manage Sessions.