Looking for Tuning tool
From: Rob Rebmann <rob.rebmann_at_londonlife.com>
Date: Thu, 27 May 1999 21:22:47 GMT
Message-ID: <HIi33.1377$U86.1308_at_198.235.216.4>
We are at 7.3.4 of Oracle running on AIX/Unix platform. I am looking for a product that will perform an explain plan(listing all the access paths for all the queries) on all or selective Packages and Stored Procedures. I don't want to have to actually execute the Package or procedure to get the results.
The primary reason for having such a tool is to be able to keep a historical record of the access paths as changes occur to the procedures.
Date: Thu, 27 May 1999 21:22:47 GMT
Message-ID: <HIi33.1377$U86.1308_at_198.235.216.4>
We are at 7.3.4 of Oracle running on AIX/Unix platform. I am looking for a product that will perform an explain plan(listing all the access paths for all the queries) on all or selective Packages and Stored Procedures. I don't want to have to actually execute the Package or procedure to get the results.
The primary reason for having such a tool is to be able to keep a historical record of the access paths as changes occur to the procedures.
We are planning on migrating from rule to cost based optimizer. It would be very beneficial to have such a product to analyze the potential differences in access paths between the two optimizers.
If you know of such a product please respond to the newsgroup and/or e-mail me at rob.rebmann_at_londonlife.com. Received on Thu May 27 1999 - 23:22:47 CEST