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 licensed as shareware, the cost of the registered version is $42 and full download size is 0.18 MB. You can download a free version of Query Plan by following download link at Free Downloads section of this page. Query Plan is developed or distributed by Priodata and is listed under business databases & tools.

Software Screen Shot

Tool to browse Oracle's library cache to locate SQL statement to tune.

Related Software

execution performance execution plan tuning oracle oracle applications query plan oracle 9i sql view oracle tools oracle database graphical interface application developers dbas sql statement cursor oracle queries statistics

Free Software Download

Download Link:

Download Now!

Publisher:

Priodata

Cost:

$42

License Type:

Shareware

File Size:

0.18 MB

Release Date:

3/3/2006

Platforms: Win98, WinME, WinNT 4.x, Windows 2000, XP, Windows 2003

Keywords: library tuning oracle v$sql_plan cursors v$sqltext cache v$sql sql

Review and Awards

Put it on your website!

Query Plan Software Downloads

ADEX Shares - ADEX Shares is a COM component for VB / ASP

technical drawing puzzle - Try to restore the initial 3D projection at 2D projections.

Webstyle - A quick and easy way to produce quality graphics and photos for the web

Finding Nemo Movie Screensaver - Cool Freeware Animated Screensaver includes 16 images from funny movie.

InterFAX - Interfax is a utility that lets you send free faxes from your computer.

QuakeSaver - Shows recent earthquakes geolocalized on a world map as screensaver

CYTSoft Psychrometric Calculator - A highly accurate moist air calculator for engineers and scientists.

abc DVD 95 Copy Pro - Copy any DVD to a regular DVD recordable with just 1 click within 30 mins

Word Web-stream - CGI-script allow to read any MS Word file on server and return the html-content

Air Hockey - Air Hockey plays just like the arcade version. You play against the computer and

WinRescue 95 - Four tools in one to protect against crashes and data loss. Be prepared.

TMCHintBox component for Delphi - A smart way to display diagnostic messages without dialog boxes

Solitaire - Solitaire card game, free klondike solitaire. Play solitaire without download.

PathQuest 1: The Phoenix Arisen - A unique story-driven adventure game experience, with high-res graphics!

Boilsoft DVD Ripper - Ripping DVD to AVI, Xvid, WMV, VCD, SVCD, DVD, iPod MP4, PSP MP4 etc

Office Password Recovery Toolbox - The solution for instant password recovery in MS Office documents.

Phonotics Alert Engine - Receive instant alerts about crucial info to your cell, email, desktop, etc.

Xtreeme MailXpert Standard Edition - Mail processing software for Windows: bulk mailer, discussion lists server.

Outlook Mp3 Player - This add-on makes Microsoft Outlook to play Mp3 alarms.

Animated Christmas Flavor Screensaver - Free Animated Christmas Flavor Screensaver