Tag Archive: sql trace

SQL Trace for Oracle MWA

Occasionally the need arises to enable SQL trace for Oracle Mobile Web Applications (MWA) for WMS or MSCA related E-Business Suite modules to track down the source of poor performing queries.  Enabling this is quite easy but may not be obvious when looking at the options in the configuration file.  This particular example is assuming E-Business Suite 12.1.3. Let’s take a look at the MWA configuration file (mwa.cfg) located in $INST_TOP/admin/install.  It’s interesting to note that the parameter that we modify to enable SQL Trace, mwa.LogLevel, doesn’t list the value we need for performing a SQL Trace.  It appears that the…
Read more