Page History
...
In some tabs, you can filter the contents of the view by clicking the Filter button. See “Filtering data” on page 29 Filtering data.
About the Association area
...
The Association area lets you drill down to another entity by clicking a row. The information displayed in both the Main area and the Association area will change to reflect your selection. See “Filtering data” on page 29 and “Associating Filtering data and Associating entities with data that meets specific criteria” on page 30criteria.
About the Findings area
For selected tabs in Precise products, the association area includes the Findings area, displaying problematic findings for the application. The findings feature is a high level tool, designed to provide the user with an overview of performance issues within the monitored application and enable quick and efficient navigation to the relevant tab for further analysis and handling. The displayed performance findings may indicate performance deterioration as well as incorrect methods usage. Each finding appears as a row in the displayed table of findings. Hover the mouse indicator over the single-line displayed finding to expand the finding. When expanded, the finding details area provides important guidelines as to what may be the root cause for the reported problem, and what the recommended steps are to resolve this problem.
...
For more information, see “Oracle Findings” on page 183 Oracle Findings.
| Anchor | ||||
|---|---|---|---|---|
|
...
- When Precise for Oracle carries out an explain plan operation, it needs to connect to the database. By default, it uses the Oracle account specified during the installation. This option lets you override the database user and password that will be used.
- Precise for Oracle's own parsing functions can be disabled at the expense of some of the formatting features of the explain plan. This option is useful when Precise for Oracle cannot parse a statement. See “About About Precise for Oracle tabs” on page 21tabs.
- You can fine-tune the way that Precise for Oracle generates alternatives to SQL in a number of ways:
- You can control the maximum number of alternative SQL statements.
- You can control the percentage of the items that are highlighted in the Oracle explain tree based on “In Oracle Time”.
- You can have Precise for Oracle ignore alternatives that generate the same execution plan.
- When Precise for Oracle generates alternatives (referred to as Related SQL), any views are expanded to show the full view text, rather than just the name.
- If a Precise for Oracle view is expanded, Precise for Oracle may consider rewriting the text of the view itself, not just the statement that uses the view, when it generates alternatives.
- You can have Precise for Oracle use different Oracle Optimizer modes.
...
Selecting a predefined time frame from the toolbar displays transaction performance data for the selected time period up to the current time. See “Selecting Selecting a predefined time frame from the Precise for Oracle toolbar” on page 29toolbar.
Selecting the time frame using the calendar icon, you can choose to define a time range independent of the current time, or to define a time range up to the current time. See “Selecting Selecting a time frame using the calendar icon” on page 29icon.
The predefined time frame options are:
...
The time frame selected affects all information displayed in Precise for Oracle. Only data that falls within the selected time frame is shown in these areas.
| Anchor | ||||
|---|---|---|---|---|
|
To select a predefined time frame, in the Precise Menu area, select one of the predefined time frames.
| Anchor | ||||
|---|---|---|---|---|
|
To select a time frame
- Click the calendar icon. In the dialog box that is displayed perform one of the following:
- To define a time frame independent from the current time, select the ‘Time Frame’ option and select the Start and End dates and times.
- To define a time frame up to the current time, select the ‘Last’ option and enter the desired time frame.
- To use one of the three previously used time frames, select the ‘Recently used’ option and from the drop- down menu select the desired time frame.
- To use a previously saved time frame, select Use a previously saved time frame and from the drop-down menu select the desired time frame.
- To save your settings for future access, select Save these definitions for future use as: and enter a name in the corresponding field.
- Click OK.
...
The other In Oracle wait states, such as Using CPU, do not apply to an object. See “In Oracle” on page 36 Wait States - In Oracle.
Statement identifier vs. Oracle hash value
...