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.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.
Keywords : Oracle tuning SQL cursors library cache v$sql v$sql_plan v$sqltext
Conclusion
To conclude Query Plan works on Windows operating system(s) and can be easily downloaded using the below download link according to Shareware license. Query Plan download file is only 188 KB in size.Query Plan was filed under the Databases category and was reviewed in softlookup.com and receive 5/5 Score.
Query Plan has been tested by our team against viruses, spyware, adware, trojan, backdoors and was found to be 100% clean. We will recheck Query Plan when updated to assure that it remains clean.
Query Plan user Review
Please review Query Plan application and submit your comments below. We will collect all comments in an effort to determine whether the Query Plan software is reliable, perform as expected and deliver the promised features and functionalities.Popularity 10/10 - Downloads - 293 - Score - 5/5
Softlookup.com 2023 - Privacy Policy
| Category: | Databases |
| Publisher: | Priodata |
| Last Updated: | 02/19/2019 |
| Requirements: | .NET Framework 1.1 |
| License: | Shareware |
| Operating system: | Windows |
| Hits: | 574 |
| File size: | 188 KB |
| Price: | 42 USD |
| Name: * |
E-Mail: * |
| Comment: * |
|