Capture SQL Running on MDM Database
Forgive me for my ignorance, but is there an easy way to capture the queries being run against the database. MDM is running on Oracle 11g. The environment in question is a sandbox environment. We do not license products like Oracle's OEM for sandbox machines. The call is from an external Webdynpro call. The developer is saying the query is taking 6-7 seconds and we are wanting to investigate it for using an index, but are unable to view the query in the database.