In Integrated WebLogic (JDeveloper) this can be done with just few clicks:
- Open "IntegratedWeblogicServer - Log" window. On the right-hand top corner click "Actions" and choose "Configure Oracle Diagnostic Logging"
- For getting SQL statements in the output, in the opened logging.xml choose "oracle.jbo" logger with desired logging level. Level "Finest" will generate maximum output. SQL staements shoud definitely be there.
Be careful not to choose too many loggers with quite fine logging level. Otherwise log output can become too massive, flooded and be difficult to find useful info in there.
In standalone WebLogic can accomplish this task using Fusion Middleware Control:
Open Oracle Enterprise Manager, right click on ADF server (i.e. adf_server1), choose Logs -> Log Configuration:
Here You find similar structure like in JDeveloper:
Labels: ADF, JDeveloper, SQL, Weblogic