|
|
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. Query Plan is a shareware categorized under business databases, tools tools.
Keywords: optimizer oracle applications performance sql graphical interface cursor query plan most commonly used tuning oracle queries execution performance sql statement oracle database application developers execution plan captures oracle tools oracle 9i sql view us dollars page zoom
|
|
|
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. business databases, tools shareware listed in business databases, tools section.
Keywords: bind variables session level queries window interface repetitive tasks initialization parameters sql tuning explain plan oracle applications coworkers collect statistics innovative product oracle database execution plans single file footprint tuning oracle tuning tools oracle 9i ui r9 r10 browser print
|
