Browse, Search and Download Shareware, Freeware, Demos, Games at Download 32!
  
 
WindowsWindows
MacintoshMacintosh
Palm OSPalm OS
LinuxLinux
 
 
 
 
Business / Databases & Tools

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 write complex joins to V$SQLTEXT). Compatible with Oracle 9i and later.



>>
>>
>>

Broken Link?
   
   
Rating: 0 Star0 Star0 Star0 Star0 Star
Current Version: 1.1
Release Date: Mar 3, 2006
License: Shareware
Price: $42
Downloads: 20


Software Description:
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.
Software Requirements:
.NET Framework 1.1

This software is designed to run on the following operating systems:
Windows 98, Windows, Windows Me, Windows NT, Windows 2000, Windows XP, Windows 2003

Keywords:
Library Cache Oracle Sql Tuning Cursors V$sql V$sql_plan V$sqltext

Download Link:

Screenshot
Query Plan - 1.1 Screenshot

Query Plan - 1.1 Screenshot Full Screenshot
Feedback Summary: Show All Feedback (0)
Overall Rating: 0 Star0 Star0 Star0 Star0 Star
Ease Of Use: 0 Star0 Star0 Star0 Star0 Star
Functionality: 0 Star0 Star0 Star0 Star0 Star
Price: 0 Star0 Star0 Star0 Star0 Star
Add You Feeback
Query Plan related software
Title / Version / Description Size License Price
Select Fast! 1.0243.0 KBShareware $129 
Priodata Select FastPriodata 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...
OraSphere: Query Master 1.42.2 MBShareware $199 
Query Master is a fast multi-threaded SQL and PL/SQL tool with a script library and an advanced grid for developers and database administratorsQuery Master is a fast multi-threaded SQL and PL/SQL tool with a script library and an advanced grid for developers and database administrators. Features: script library; SQL and PL/SQL editor; single, multiple and for update statement execution; bind variables; describe objects; powerful grid; SQL statement execution plan; popup window with database objects; script import; transaction queue; oracle home selector; DDL generator, DB object...
RBIndex7 for ORACLE 1.0531.0 KBFreeware  
A performance tuning utility for ORACLE databasesA performance tuning utility for ORACLE databases. The utility will analyze ORACLE indexes, evaluate whether they need to be rebuilt, and generate the necessary SQL scri`pt to perform the rebuild. Works with ORACLE versions 7.3.x, 8.0.x, and 8.1.x. Standalone native executable for Windows NT uses the Oracle7 OCI (no installation routine required), and is a self-documenting console-mode application that canbe batched and scheduled. C source...
Fast Plans 11.12.8 MBShareware $57 
CAD floor plan design software, very easy to use - takes care of drawing and MATH - leaving you to design This version includes wizards and a Custom Drawn Items function to add baths, beds, stairs, tables & chairs etc,   all at your sizes colours and style to make home plan design so much easierCAD floor plan design software, very easy to use - takes care of drawing and MATH - leaving you to design This version includes wizards and a Custom Drawn Items function to add baths, beds, stairs, tables & chairs etc, all at your sizes colours and style to make home plan design so much easier
Biz-Plan 3.01.6 MBFreeware  
Business Plan Guide and TemplateBusiness Plan Guide and Template. The Word-based Template (48 pages) contains a detailed framework and structure for writing a business plan. It is complemented by a comprehensive Guide (supplied as a 90+ topic Help file and as a 100+ page PDF file for printing) which offers extensive section-by-section help related to the Template. This includes sample text, typical tables and charts. Matters discussed include planning to plan, length of a...
Other popular software in this category
Title / Version / Description Size License Price
MSSQL to MySQL Database Converter 2.0.1.51.3 MBShareware 1980INR 
Database converter is a powerful tool which makes the conversion from MS SQL server to MySQL easy and reliableDatabase converter is a powerful tool which makes the conversion from MS SQL server to MySQL easy and reliable. You can even convert your large database which contains thousands of records in a matter of a few seconds even if your database merges multiple tables or rows. The database converter software is fully capable to convert entire database or selected table's records easily and efficiently. MSSql to MySql database migrator supports all...
EMS SQL Manager 2008 Lite for InterBase/Firebird 5.027.6 MBFreeware  
EMS SQL Manager Lite for InterBase/FireBird is an excellent freeware tool for InterBase and FireBird administrationEMS SQL Manager Lite for InterBase/FireBird is an excellent freeware tool for InterBase and FireBird administration. It has minimal required set of instruments for those users who are new to InterBase server and needs only its basic functionality. It provides an easy-to-use graphical interface for maintaining databases and database objects, managing table data, simply edit SQL queries, run SQL scripts, administering users and their privileges...
Free Database Compare 1.0435.0 KBFreeware  
The SQL Compare application will allow you to compare the structure of two SQL server databases and display all the differences between themThe SQL Compare application will allow you to compare the structure of two SQL server databases and display all the differences between them. You can compare databases online or you can take snapshots of the structure of the databases and compare them off-line, which is ideal for when you have a regularly update database and want to check if the all the changes to the database were committed successfully. After comparing you will be allowed to...
Data Export - Text2Oracle 1.1.0182.1 MBShareware $31.85 
Hxtt Data Export - Text2Oracle is a program to import TXT(CSV, TSV, PSV) into Oracle(8, 8i, 9, 9i, 10g) databaseHxtt Data Export - Text2Oracle is a program to import TXT(CSV, TSV, PSV) into Oracle(8, 8i, 9, 9i, 10g) database. The software are completely written in Java and can be deployed on any platform with Java VM (1.4.X, 1.5.X, 1.6.X), which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, OS2, UNIX, and LINUX. It includes a wizard, which allows you to set convert options for each table visually (destination filename, exported...
ModelRight Community 326.0 MBFreeware  
Do you need to design, visualize or document your databaseDo you need to design, visualize or document your database?ModelRight 3 can reverse engineer your existing database to get a graphical view of it, generate all the SQL statements to create the database, or synchronize your database model with the database to keep your design up to date. Do you need to control the most detailed aspects of your physical database? ModelRight 3 has more complete and in-depth support for your database.ModelRight 3...
 
  
All software information on this site, is solely based on what our users submit. Download32.com disclaims that any right and responsibility for the information go to the user who submit the software, games, drivers. Some software may not have details explanation or their price, program version updated. You should contact the provider/actual author of the software for any questions. There are also user reviews/comments posted about various software downloads, please contact us if you believe someone has posted copyrighted information contained on this web site.   Copyright © 1996-2009 Download 32.