I am using Optimize Indexes to gather SQL statements from the AWR logs to try to identify possible improvements by adding indexes.
I have about 120 different user all submit SQL against tables in a central schema. What I would like to do is analyse all the SQL statements submitted against the central schema.
The only option I can find is “Collect SQL for parsing schema” but I want to collect SQL for target Schema. Is this possible?
Many thanks for any help