Page History
This section includes the following topics:
- About Precise for Oracle tabs
- How most tabs are structured
- About drilling down in context
- Tasks common to most tabs
- About role management in Precise for Oracle
- How information is collected
- Launching Precise for Oracle from Precise StartPoint
| Anchor | ||||
|---|---|---|---|---|
|
The Precise for Oracle user interface is made up of seven or eight tabs depending on whether Oracle Applications is installed or not. Each tab has a different focus and provides a different view into your application and database performance. You can move between these tabs to examine the information necessary to successfully track your database performance and to identify patterns in resource consumption.
...
Table 2-1 Tabs in Precise for Oracle
Tab Description
Dashboard Lets you quickly identify which Oracle instance has a performance problem, providing the first glimpse into where the problem lies. The Dashboard tab also lets you compare performance and statistics among your Oracle instances.
Current Lets you identify and solve the performance problems that are happening now.
Activity Lets you examine the application's performance over time and helps locate performance bottlenecks in its behavior.
Objects Lets you browse Oracle database objects. It can help you understand the relationships and associations between database schema objects and the SQL statements that access them. It is primarily used for object tuning.
SQL Lets you tune problematic SQL statements.
What-If Lets you simulate the effect of any index change on SQL statements running in your application.
Statistics Lets you examine Oracle's own statistics and see graphs of their variation over time. It is primarily used for instance tuning.
Oracle Applications Lets you identify problems in Oracle Applications concurrent managers and requests. Note that this tab is only available if you have Interpoint for Oracle Applications installed.
| Anchor | ||||
|---|---|---|---|---|
|
Though each tab is structured differently, most tabs consist of two different areas. Each area can include different control elements, such as tabs and view controls, and displays information in various formats, such as tables, graphs, or charts. The various areas are related to each other in that performing an action in one area affects the information displayed in other areas on the page. For example, the Current tab contains an upper and a lower area. The lower area (Association area) shows information in a table format. Each row in the table represents an application. The upper area (Main area) displays general information on the selected entity as well as related applications.
...
For more information, see “Oracle Findings” on page 183.
| Anchor | ||||
|---|---|---|---|---|
|
The term 'in-context' means that you can display additional information on a selected item by drilling down to another tab or view. The filter settings you defined (for example, the selected time frame you chose) and the entity you selected are carried over to the other view or tab, to allow you to continue analyzing your subject from a different perspective. This concept takes on slightly different meanings depending upon where you are attempting to drill down in context from.
...
The Tab heading displays the name of the currently selected entity on this screen. When you drill down to a new entity in the Association area, the Tab heading changes to reflect the name of the newly selected entity.
| Anchor | ||||
|---|---|---|---|---|
|
The following settings allow you to control the appearance and behavior of the user interface. They can be configured from the Settings menu in the Precise Menu area:
...
You can determine the resolution of the data that is displayed in the overtime graphs using the Time Frame Settings dialog box. By using this dialog box you can define the default time frame to display.
| Anchor | ||||
|---|---|---|---|---|
|
The following tasks are commonly performed in most tabs:
...
- Right-click the graph.
- Select Export to the Precise Custom Portal Portlet.
- Insert a name in the name field that clearly describes the graph view.
- Click OK.
| Anchor | ||||
|---|---|---|---|---|
|
The Roles management feature in Precise for Oracle lets you assign roles to users and control whether they will be able to do the following operations:
...
For more information on configuring permissions and roles see the Precise Administration Guide.
| Anchor | ||||
|---|---|---|---|---|
|
Precise for Oracle collects and displays performance data that enables quick and accurate performance monitoring and analysis. To understand the information displayed in the various graphs, tables, and views, it is important to understand how information is collected.
...
It is important to understand how Precise for Oracle can aid you with this latter activity. Precise for Oracle provides two different views of device performance. The Activity tab shows the time waited on devices used by the currently selected instance: you use this tab to find the performance bottlenecks within your application. The Objects tab shows performance counters for all devices, not just those used by the current instance. This gives you a view of the overall performance of the storage arrays and lets you choose less busy devices to move your Oracle files to.
| Anchor | ||||
|---|---|---|---|---|
|
Precise is a Web-based application. You can access the Precise user interface using the Internet Explorer browser, version 6.0 or later. The syntax of the Precise URL address is: http://<server>:<port>, where <server> refers to the Precise FocalPoint server and <port> refers to the port number used by the GUI Web server. By default, the port number is 20790 (20760 for J2EE). For example: http://beanotown:20790.
...