We need to review our database access schemes. All our SQL is in JDBC Adapters. Does anyone know how I can extract the SQL (not custom) so I can stuff it into an Oracle Explain Plan?
Alternately is there a way to run Explain Plan against individual jdbc adapter services? Or is there some easier way to get to this information?
Ideas greatly appreciated