Page History
This section includes the following topics:
- About Precise for Oracle
- Components of Precise for Oracle
- How Precise for Oracle works
- What you can do with Precise for Oracle
- Where to get more information
| Anchor | ||||
|---|---|---|---|---|
|
Precise for Oracle lets you manage the performance of your applications. It provides you with the tools necessary for proactive monitoring, diagnosing, detecting, and correcting of performance problems before they become visible in your Oracle databases and related applications.
...
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 is my performance problem?” If Insight shows that the problem lies within Oracle, you can use Precise for Oracle to drill down further.
| Anchor | ||||
|---|---|---|---|---|
|
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 Installation Guide.
...
Precise provides a Web-based graphical user interface (GUI). Client requests are sent to Precise FocalPoint using HTTP. The Precise GUI is accessed through a browser. After you log in as an authorized user, the Precise StartPoint page opens. From the StartPoint, you can access the Precise for Oracle user interface and all other Precise products.
| Anchor | ||||
|---|---|---|---|---|
|
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.
...
- 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’ 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.
| Anchor | ||||
|---|---|---|---|---|
|
Use Precise for Oracle to detect, diagnose, and resolve performance problems in your Oracle database. Precise for Oracle lets you identify real-time performance problems (for example locking problems) and monitor a complete history of your Oracle database.
| Anchor | ||||
|---|---|---|---|---|
|
More information on Precise, its products, technical notes, and so on, can be found in the Release Notes document for this version.
...