|
|
Query Plan v1.1 by Priodata
 |
Program type: Shareware
Developer Name: Priodata
Release Date: 2006-03-03
System requirements:
Win98, WinME, WinNT 4.x, Windows2000, WinXP, Windows2003
.NET Framework 1.1
Limitations:
Program cost: $42 (click to order)
Query_Plan
File size: 187Kb
Install support: Install and Uninstall
Program language: English
What is new: minor bug fixes and new Where Clause Assistant window
|
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). All this with a fine graphical interface, without having to write your own queries and joins.
Download Query Plan v1.1
Order Query Plan v1.1
| Description of Query Plan v1.1
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. |
| Links, related to Query Plan | query plan - oracle - tuning - sql - cursors - library - cache - plan - sqltext - scorpio software |
Programs, similar to Query Plan | JSPMaker is a powerful yet easy-to-use code generator that creates a full set of JSP (JavaServer Pages) quickly from MySQL or Oracle. Download · Screenshot · more information |
 | WINner Tweak is a tools suite for tweaking, optimizing and tuning of Windows XP/2003/2000. It helps you increase performance and manage your system using various tweaks and utilities for settings including Windows, Hardware, Security, Network and Software. In addition to the tweaks, the program also offers several additional tools (Power Utilities). Download · Screenshot · more information |
 | Tune your musical instrument quickly and accurately with this digital tuner. Uses microphone or direct electric guitar input for tuning. You can tune guitar, bass guitar, banjo, mandolin, violin, viola, cello, double bass, and other instruments using the pitch selector. Has choice of gauge and pitch graph views. Download · Screenshot · more information |
 | Databrid is a browsing, retrieval and manipulation tool designed for the novice to the expert user. Databrid works on an Oracle Database (versions 8 and above although not all functionality in the Browser is available for the lower versions). The core functionality of Databrid revolves around the tabbed areas within the Databrid application. The five tabs in the main screen of Databrid are: SQL Editor, Browser, File, Jobs and Help. Download · Screenshot · more information |
 | Oracle-to-MSSQL is a program to migrate Oracle databases to MS SQL server. All Oracle data types (except BFILE and MLSLABEL) and attributes are supported. The program has easy-to-use wizard style interface and supports command line. Download · Screenshot · more information |
 | MySQL-to-Oracle is a program to convert MySQL databases into Oracle format. All MySQL data types and attributes are supported. The program has easy-to-use wizard style interface and supports command line. Download · Screenshot · more information |
 | MSSQL-to-Oracle is a program to move MS SQL databases to Oracle server. All MS SQL data types and attributes are supported. The program has easy-to-use wizard style interface and works with all versions of Oracle server. Download · Screenshot · more information |
 | OracleRecovery is a comprehensive tool designed to recover data from damaged Oracle databases and backups. Special wizard-style interface gives users more control over the recovery process. OracleRecovery restores tables, fields, fields types and values, as well as all backup objects, including views, triggers, stored procedures etc. OracleRecovery 2.0 supports all moder Oracle versions, such as 10g, 7.3, 8i and 9i. Download · Screenshot · more information |
 | Oracle-to-Access is a program to convert Oracle databases into MS Access format. All Oracle data types (except BFILE and MLSLABEL) and attributes are supported. The program has easy-to-use wizard style interface and supports command line. Download · Screenshot · more information |
|
