does SGA inspector have way to get sql that contains specific table

SQL Optimizer SQL Optimizer for Oracle
1

this would make it easier to get all sql using a specific table so you could then feed just that sql to “Impact Analser” when adding an index to that table.
i am finding I get over 10,000 sql in “Sga Inspector” and I cannot reduce this to the
30 or 40 sql i need for “impact Analyser”.
I do not seem to be able to save all the sql to repository, it always aborts.

2

Hi,

Thank you for providing this feedback. The product currently doesn’t have the feature to send SQL to Analyzer by criteria. I will create an enhancement request based on your suggestion. I think it will be a good enhancement to the product.

Thanks again for the feedback.

Alex