A tool to automate repetitive tasks associated with the SQL tuning process on the Oracle Database. Run query to get statistics, run EXPLAIN PLAN, capture plan from V$SQL_PLAN, set bind variables, etc. Also has an interface to Oracle's Tuning Advisor.
Sep 13, 2011 19:57:36
Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003
Description: Priodata Select Fast! is a tool to automate the repetitive tasks associated with the SQL tuning process on the Oracle Database. With Select Fast!, you can easily write and keep track of all alternative query versions you create during the tuning process, run them at once to collect statistics, run EXPLAIN PLAN, capture plan from V$SQL_PLAN, set bind variables and session level initialization parameters, etc. Its multi-threaded UI lets you run queries on several databases at the same time, and continue working on new ideas.
Better yet, you can save all that information (the complete analysis, with the queries, statistics results and execution plans) in a single file, for your own future reference or to share your work and thoughts with coworkers. Select Fast! also has a simple-to-use window interface to Oracle10g's Tuning Advisor functionality.
Select Fast! really improves performance of the process of tuning Oracle applications. This product is also ideal for consultants, because of its small footprint, easy to install and uninstall. A unique and innovative product, with a price very low compared to other high-featured tuning tools.
Compatible with Oracle 9i and later. Requires .Net Framework 1.1 installed on the machine.
Query Plan 1.1 A tool to browse Oracle's library cache to locate SQL statement to tune. Shows the execution plan in the classical hierarquical view, shows complete SQL text (without having to
Alt SQL Developer for Oracle 1.8.38 The Best IDE tool for Oracle database objects and provides convenient opportunities for creating, editing, testing, debugging, and optimizing SQL queries, stored procedures in
Programs: a Checklist for Tuning Up Your PC You change the oil in your carevery 5,000 miles or so. You clean your house every week ortwo. Your PC needs regular maintenance as well -- especially ifyou're using Windows and you spend a lot of time on theInternet.