Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


IT staff frequently search for answers to questions like “Why "Why did the application run so slowly last night?” or “Where ," or "Where is the application spending its time?"

Precise for Oracle can help IT staff find the answer to these questions. The first step is to establish a baseline level of database resource consumption by understanding the behavior of the average application. The behavior of the average application represents the average percentage of the total time that all applications spend consuming or waiting for each resource. These aggregate figures provide a broad picture of the operation of your database. They enable you to identify major bottlenecks in your system, for example CPU and I/O limitations, Oracle database waits due to locks, remote queries, and so on.


Precise for Oracle is fully integrated with other Precise products. You can receive alerts using Alerts, examine Oracle reports within Report Manager, and view Oracle data in Insight and the Precise Custom Portal. You can launch Precise for Oracle from Insight, Alerts, Report Manager, Precise for SAP, and Precise for J2EE. For more information on the individual components, see the user 's guide of the relevant product.


Report Manager gathers and organizes historical information that enables the IT team to focus on infrastructure hot-spots. You can use Report Manager to compare period-to-period performance against a baseline and identify response time problems “at"at-a-glance," before they affect your users. It queries the PMDB and displays the results in reports that are generated on a scheduled basis or on demand.

If you are following the Precise tuning methodology, both Alerts and Report Manager enhance your ability to detect performance problems by answering the question “Do , "Do I have a performance problem?"

The Precise Custom Portal, is a lightweight, configurable portal application that provides access to various types of data from different applications. The Precise Custom Portal features a Web-based view. It is highly customizable and extensible, allowing you to build a dashboard for each user or each function within your organization. For example, you can build a dashboard for all the information that a system administrator or director of IT operations would need to constantly follow up on. This component is automatically installed as part of the Precise framework installation.

Insight gives you an end-to-end view of your applications performance, across all your Tiers. It helps you find the source of performance problems in multi-tier applications by allowing you to compare the resource consumption of each Tier. In this way, you can answer the question “Where , "Where is my performance problem?" If Insight shows that the problem lies within Oracle, you can use Precise for Oracle to drill down further.


To understand the Precise for Oracle architecture, it is important to know the overall architecture of the Precise product suite. For more information, see the Precise the Installation Guideand Administration.

Precise for Oracle employs client/server architecture to provide comprehensive 24 x 7 performance monitoring, vital for both short and long-term monitoring of your Oracle database.


  • Report Manager FocalPoint
  • Alerts FocalPoint
  • Alerts InformPoint
  • Insight FocalPoint

See the Precise See Installation Guide and the Precise Administration Guide.

Precise Listener


Within Precise for Database & Storage, it is possible to browse device-specific mappings and statistics information. For more information, see the Precise Installation Guideand Administration.

ERP extensions (also known as Interpoints) are available for the following technologies:


Precise for Oracle stores a complete history of your database activity in the PMDB. This provides you - with a performance tracking tool that gives you the ability to assess database performance trends and analysis changes in database activities over long periods of time. This data is vital for identifying patterns in resource consumption and predicting future resource consumption in your Oracle database.


This interface lets you submit queries in a flexible intuitive manner, and then displays responses to your queries in a format that easily permits you to detect performance problems, drill down to the source of these problems, and subsequently tune your applications and database. The user interface is divided into a number of tabs to enable quick, accurate, and focused monitoring and performance analysis.See “About  See About Precise for Oracle tabs” on page 21tabs.

The interface and tabs support the Precise tuning model of Detect, Find, Focus, Improve, and Verify. The following example shows how you might follow the tuning model in some of the tabs:

  • The Dashboard tab, with its at-a-glance view of all Oracle instances side-by-side, lets you detect which is the most problematic instance. You can drill down, in context, to find and focus on the problem in the Current, Activity, or Statistics tabs. Automatic findings will guide you to the problems which, in turn, will take you to the next step of the problem solving action.
    The Dashboard tab also lets you compare performance and statistics among your Oracle instances.
  • The Current tab gives a near real-time picture of activity in your instance and lets you easily find problematic conditions that are occurring now.
  • The Activity tab lets you find and focus on the top resource consumers within your application over time. It also lets you identify patterns in resource consumption and predict future resource consumption in your Oracle database, such as:
    • When comparing business cycles
    • When comparing software releases
    • In capacity planning or trend analysis
  • The Statistics tab lets you focus on instance-wide statistics that affect all applications.
  • Having identified a performance problem, you can either improve the performance of your application, or use one of the automated tuning tools in Precise for Oracle, such as:
    • The SQL tab, where ‘Alternative SQL’ Alternative SQL suggests more efficient SQL, and Advice recommends index changes.
    • The What-If tab, where you can simulate the effect of any proposed index change without physically creating the index.
  • After implementing a performance improvement, return to the Activity tab and check if the change created the desired effect on your application or database. For example, return to the Activity tab to see if resource consumption was reduced.