Reading, writing and reporting on queries
Sorry, I don't have a ready-made script for you, but there are a number of ways you can do this and it would be a worthwhile exercise to develop a utility. One possibility is to store the queries in a database table, and in a PL/SQL procedure, fetch each query and then perform the EXPLAIN (the results go into PLAN_TABLE; it can hold the results of all 100 queries--just be sure to give each query an ID when you issue the EXPLAIN command). Finally, you can write a query to fetch the plans from the PLAN_TABLE, and save the results to a file.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments