qMenu

Updated: Aug 30, 2018

Oracle Sql Performance


DBG Now Offers the qMenu Product


Oracle SQL Performance is increasing in complexity and proliferation. The task of gathering efficient SQL performance management information can become quite cumbersome and time consuming. Much of a database administrator's effort can be consumed by researching multiple areas and multiple tools.


QMenu has greatly consolidated the ability to gather vital SQL performance information and allows the DBA to focus on the SQL performance directly from a single tool, consolidating functions and effectiveness. Using a set of SQL Plus* features, this software goes beyond just a single consolidation location for scripts. Features, exclusive to qMenu, such as automatic spooling and consolidated spool locations, multiple users to different spool locations, prompt driven inputs, and proprietary logic to gather information for efficient and rapid analysis are a great complement to the Oracle DBA skillset.

Creating a customized, efficient SQL performance management strategy is imperative to today's Oracle shops. Involved in this process are several constraints (delivered manual Oracle scripts, Oracle OEM GUI tool understanding, manual gathering and aggregating of AWR data, etc.) And can, depending on the number of Oracle databases involved, require a great deal of effort from the DBA. QMenu offers tools and features to make this process much easier.

QMenu's outstanding features are its ease of use and the robust nature of the intuitive menu driven system. Virtually no training is required to use this product. DBAs will be especially impressed at the power and flexibility behind qMenu's intuitive screens.

There is no other product on the market dedicated to consolidate Oracle SQL performance metrics with this much functionality and user performance. QMenu makes it simple to pull your SQL performance information and gather it for ease of analysis.

QMenu is very useful for generating ad-hoc SQL metric reports such as Database SQL Metrics (DSM) with a time range and multiple other possible filtering criteria, statistics, current SQL performance, space usage, etc. for a database.