Index >> Business >> Databases & Tools >> Query Plan
Report SpywareQuery Plan 1.1
Query Plan Download

Query Plan Screenshot Click to enlarge screenshot

Downloads:     210
Star Rating: 0 / 0    Rated by: 0 user ( s )   
Developer:      Priodata  
License, Price:Shareware, $42.00
Size, OS :       188 KB   |   Windows System
Last Updated: March 03, 2006, Friday
Software ID:   33781   |   Use this software ID to contact us
Read user reviews Submit a review Check last version on developer's site

Software Description:

Query Plan - Tool to browse Oracle's library cache to locate SQL statement to tune.
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.
What's New: minor bug fixes and new Where Clause Assistant window
Limitations: 30 Days Trial

Feature List:

  • Oracle connection through .NET Data Provider (no need to install any lib, only the Oracle Client)
  • Stores recent connections list for convenience
  • Fine and intuitive user interface
  • Assistant Dialog to help the user edit the WHERE clause for selecting cursors
  • Practical User Manual
  • Resolves user id to user names
  • Automatic conversion of time units for elapsed time and CPU time for readability
  • Automatic retrieval of complete SQL statement piece-to-piece from V$SQLTEXT
  • Automatic retrieval of execution plan (from V$SQL_PLAN) and presentation in a tree view

100% Clean:

100% Clean Query Plan 1.1 is 100% clean
This download (query_plan_1.zip) was tested thoroughly and was found 100% clean. Click "Report Spyware" link on the top if you found this software contains any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.

 

Related Software:

  1. Select Fast! 1.0 - A unique tool to automate repetitive tasks in the SQL tuning process on Oracle.
  2. SQLite Analyzer 3.0.4.27 - Process SQLite databases visually with SQLite Analyzer! Free trial!
  3. Full Convert Professional SQL Server Ed. 1.3 - Full Convert provides powerful and comfortable way to convert databases.
  4. Full Convert Standard SQL Server Edition 1.3 - Full Convert provides powerful and comfortable way to convert databases.
  5. Full Convert Standard MySQL Edition 1.3 - Full Convert provides powerful and comfortable way to convert databases.
  6. Full Convert Professional MySQL Edition 1.3 - Full Convert provides powerful and comfortable way to convert databases.
  7. Mobile Database Viewer(Access,xls,Oracle)for UIQ 1.1 - View Access,Foxpro,dBase,Excel and any ODBC enable Database on UIQ mobile phone.
  8. Cornolius Database Application 1.4.300 - A secure multi-user database creator and manager for individuals and businesses!
  9. DBConvert for Access & MySQL 6.0.0 - Bi-directional db conversion tool for MS Access and MySQL databases
  10. SQL Data Examiner 2010 R2 4.1.0 - SQL compare and synchronization for SQL Server, Oracle, MySQL, SQL Azure, Acces.

recommended software

  • A VIP Organizer
    A VIP Organizer
    VIP Organizer is a time and task management software which uses To Do List method to help you get through more work spending less time. It increases y...
  • Salon Calendar
    Salon Calendar
    Salon Calendar is a software tool designed specially for hair salons, beauty, manicure or aesthetic shops, tanning salons, fitness studios, wedding sa...