How can I find which query is being executed from an Oracle ADF 12c Form? We have ADF applications integrated with Oracle EBS 12.2 which make several calls to the database; I want to track the queries executed by these ADF forms. E.g., when I press a popup button a SQL query is executed from the backend, etc.
2 Answers
You can overwrite the ViewObjectImpl class and add a command to dump the query and its parameters to a special logger or the console. The advantage over the debugoutput=console is that you do not get every debug message, and there are many of them. You can look at https://blog.virtual7.de/adf-dump-query-and-all-vo-query-parameters/ how this can be done.
Related