|
|
Select Fast!
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.
Keywords: oracle sql tuning tools shareware explain plan statistics advisor output parameters shut down windows
|
|
|
Query Plan
Priodata Query Plan is a front-end to the most commonly used V$ views to investigate SQL execution performance in the Oracle Database. You can browse the shared cursor area looking for low-performance SQL, see all information related (taken from V$SQL view) and the complete SQL statement and its execution plan (taken from V$SQL_PLAN). Also captures information from the optimizer statistics (last_analyzed and num_rows) and place together with the execution plan, improving analysis. All this with a fine graphical interface, without having to write your own queries and joins. Query Plan really improves performance of the process of tuning Oracle applications. This product is ideal for consultants, DBAs and also application developers, because it automates some queries one must write in order to do a proper tuning of the database. Although the product is simple, it is innovative and the price is very low compared to other high-featured Oracle tools. Compatible with Oracle 9i and later.
Keywords: oracle tuning sql cursors library cache v$sql v$sql_plan v$sqltext private teacher vcd svcd
|
