|
|
| 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. |
|
| Updated |
Mar 4, 2006 09:01:08 | | Size | 188 kb | | Licence | Shareware | | Status | Major Update | | Languages | English | | Tags | Oracle tuning SQL cursors library cache v$sql v$sql_plan v$sqltext | | OS | Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003 | | Homepage | priodata.com | | Email | contact@priodata.com | | Author | Ilidio J. Antunes |
|
|
 click for full size
|
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. | Short tags:
Oracle, tuning, SQL, cursors, library, cache, v$sql, v$sql_plan, v$sqltext | System Requirements:
.NET Framework 1.1 | Change Info:
minor bug fixes and new Where Clause Assistant window | |
| | Freeware alternatives Query Plan 1.1 |
|  Free Download Query Plan 1.1 from priodata.com |
| Similar software shotlights: | - CachГ© Monitor 0.58 — Cache Monitor is the SQL development tool for InterSystems database Cache. It supports developers with features, like: advanced SQL Query Editor with FK-JOIN hints,SQL Syntax highlighting,SQL Code…
- Select Fast! 1.0 — A tool to automate repetitive tasks associated with the SQL tuning process on the Oracle Database. Run query to get statistics, run EXPLAIN PLAN, capture plan from V$SQL_PLAN, set bind variables, etc…
| | Find all software similar on Query Plan 1.1 |
| Similar smart reviews: | - OraLoader - simple, fast and flexible data conversion tool for Oracle databases — As a database developer dealing with Oracle databases, you may face the problem of converting your database data to more conventional formats or, on the opposite, filling your database with data provided in standard spreadsheets or even plain text files. These operations may take a lot of time that could otherwise be spent on developing and refining more important aspects of your…
- GNCutter32 1.1. Let a Professional Library Do It — Some obvious tasks in the area of «practical algorithms» seem to be easy at the first glance, but as you try to complete them, you more and more tend to think you can’t do it! A good example of that is a frequent material-cutting planning task, which is completely solved by the GNCutter32 library. The library’s most outstanding feature…
- Active Multimedia SFX Library — Three common types of media create digital content: text, image, and sound. They are similar as they can have various origins and various means, be used for various purposes and in various amounts. But the difference between the three types of content is the ease of production. As for text — anybody can write text, with any computer (or even without it), texts are easy to compile and…
- ClockWise 3.30b, Tune Your Time! — ClockWise is an ultimately wise time control center. It plays as an all-in-one smartly organized app, handling all accounting, scheduling, and informational functions related to dates and times. The program’s main window shows as much information as you really need in as small amount of screen space required to not bothering you. There is the Expanded View, showing you…
- DecryptSQL, Conquer Encrypted Queries — Remember the plot of any blockbuster or spy movie you watched recently? A good guy pursues a bad but clever secret agent, almost captures him, but… Suddenly, the bad guy’s traces disappear, and the good guy has little or no clue of where the trace would continue. Dealing with someone else’s code is a lot similar. As soon as you decide you’ve figured…
- Select Fast! Improve query performance. — Select Fast! is unique software created by a professional developer to ease the life and work of colleagues. Select Fast! for Oracle is a tool for automating the repetitive tasks associated with the SQL tuning process on Oracle databases. The vital purpose of this program is to help you find the best action to improve the performance of the query. Check out this excellent…
- Tidycode Pl/Sql Formatter 2.4.2, Making It Pretty — This utility can seem «just a small helper», but detailed analysis can say you it is really smart and really helpful (I’ll even say indispensable) for almost any database programmer. Its functionality can be easily guessed by name: it just formats PL/SQL code (as well as plain good SQL), and the way he does it can be characterized as «just right»…
- WinSpeedUp: Precise Tune-Up of Your Computer System — Noticed your computer running slower than it did when it was just out of the box? Don’t think it’s because the hardware is getting old — most likely, the deceleration is caused by a typical misalignment of the operating system. So, why rush to buy a new computer when you can just tune up your system — say, with WinSpeedUp? This speedy…
- Visual SQL Designer. Ease Your Work With Data. — Visual SQL-Designer is powerful software that can easily create complex SQL queries for any database. With this useful tool, you will be able to construct the most part of necessary queries using just visual interface of the user. That is really convenient. Now, when you have got Visual SQL designer, you do not have to spend hours creating queries, whether you are good at SQL or have…
| | Find all smart reviews similar on Query Plan 1.1 |
|
