Program: Query Plan - Tool to browse SQL statements and tune them.

More Programs

SoftSamba.co.uk Program Category SoftSamba   >  Disk N DeskTop   >  DeskTop   >  Cursors

Browse Category: Cursors By Price By Release Date By Program Name

< Cheaper Price: US$ 42.00 Dearer > < * LAST Release: 03/2006 After > Browse Screen Slides Off-line

All Categories for Disk N DeskTop

Main Sections SoftSamba.co.uk

More Info. Program: 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 info related (taken from V$SQL view) and the complete SQL statement and its execution plan (taken from V$SQL_PLAN). Also captures info from the optimiser statistics (last_analysed 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 to do a proper tuning of the database. Although the product is simple, it is and the price is extremely low compared to other high-featured Oracle tools. Compatible with Oracle 9i and later.

Main Sections SoftSamba.co.uk

• Build Site
• Business N Finance
• Disk N DeskTop
• Games
• Home
• Learning
• Pics N Drawings
• Programming
• Screen Savers
• Sound N Video
• Surfing