Page History
...
The following table describes which tasks can be performed in each tab.
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 | ||||
---|---|---|---|---|
|
...
In the Association area, click the row of the application you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays information on the application you drilled down to, and the Association area shows information on statements executed by this application.
Figure 2- 1 How a typical tab is structured
...
The following table describes the function of each of the toolbar buttons.
Table 2-2 Precise bar functions
Icon | Name | Description |
---|---|---|
Back | During a work session, keeps track of where you have navigated to. The Back button enables you to navigate between previously visited views. The Back control displays your previous view. | |
Forward | Enables you to navigate to the next view. This button is only enabled if you clicked Back or if you chose a history option. | |
AdminPoint | Launches Precise AdminPoint. | |
Home | Navigates to the highest level entity, usually the instance or Tier (all instances). The time frame settings remain the same. | |
Stop | Stops a request for information from the server. | |
Refresh | Updates the data currently displayed. | |
Favorites | Enables you to add or remove favorites in your Favorites list. | |
Send | Opens a new email message in your email program with the link to the current application in context. | |
Settings | Opens the Findings Settings, General Settings, and Time Frame Settings dialog boxes. | |
Help | Opens the online help in context. |
About the Main area
The Main area displays general information on the selected entity. The structure of this area depends on the selected entity and tab.
...
The table below describes the information that is displayed in the Findings area.
Table 2- 3 Information displayed in the Findings area
Column | Description | ||
---|---|---|---|
Severity | The severity of the finding is calculated using a formula. The position of the finding in the list is determined by an internal scoring system that is based on the knowledge of Precise product experts. The severity is indicated by the following colors:
By default, findings are displayed according to severity. | ||
Finding | A short name of the Finding. | ||
Context | Entity/Method name (unless specified for the whole instance). The entity/method name is a short name but the long name is displayed in the ToolTip. Some of the findings are identified in specific Methods while others are relevant for the entire instance. In the latter case, a finding is specified as an instance-related finding.
| ||
Finding overview | Displays specific details regarding the finding in context.
| ||
Learn more (advice) | Provides recommendations for solving the selected finding. For each finding, it lists all relevant pieces of advice and all applicable solutions. You should carefully review all data for the finding and then choose the advice that best suits your needs.
| ||
Proceed with the following (bullets) | Provides expert knowledge about the selected finding. The information displayed will direct you if you have difficulties deciding which advice to take or which solution to implement.
|
Investigating a finding
Perform the following steps to investigate a finding.
...
Info |
---|
The favorite address is displayed in the Address field and cannot be edited. |
Anchor | ||||
---|---|---|---|---|
|
...
The following table lists the existing In Oracle states.
Table 2- 4 In Oracle states
In Oracle State | Icon | In Oracle Sub-State | Description | Typical Oracle Events |
---|---|---|---|---|
Using CPU | Using CPU | The session is using CPU executing SQL. | N/A | |
I/O Wait | Direct I/O Wait | The session is waiting on direct I/O. | direct path read; direct path write | |
I/O Wait | Scattered I/O Wait | The session is waiting on scattered I/O. | db file scattered read | |
I/O Wait | Sequential I/O Wait | the session is waiting on sequential I/O. | db file sequential read; control file sequential read | |
I/O Wait | Other I/O Wait | the session is waiting on another type of I/O. | db file parallel write; log file parallel write; control file parallel write; asynch disk I/O | |
I/O Wait |
|
Application Lock Wait | Row Lock Wait | the session is waiting on row locks. Enq: TX - row lock contention (Oracle 10g) |
Application Lock Wait | Table Lock Wait | The session is waiting on table locks. | Enq: TM - contention (Oracle 10g) | |
Internal Lock Wait | Other Lock Wait | The session is waiting on other Oracle locks, such as streams, latches, or internal locks. | STREAMS events; enqueue; other enq: events; latch activity; latch free; latch: events | |
Application Lock Wait |
|
Operating System Waits | CPU Wait | The session is in the operating system queue waiting for CPU. | N/A | |
Operating System Waits | Memory Wait | The session is waiting on a memory operation, such as page-in or page-out. This sub-state may also include memory-mapped I/O. | N/A | |
Operating System Waits | Other Host Wait | The session is waiting on another type of OS operation, such as sorting. | N/A | |
RAC/OPS/ Other Waits | RAC/OPS Wait | The session is waiting on RAC or OPS synchronization. | DFS events; DLM events; gc events; gcs events; ges events; global events | |
RAC/OPS/ Other Waits | Other Wait | The session is waiting on another, less common lock event. | N/A | |
Commit & Checkpoint Waits | Rollback Segment Wait | The session is waiting on a rollback segment operation. | alter rbs offline; undo segment events | |
Commit & Checkpoint Waits | Redo Log Buffer Wait | The session is waiting on a redo log buffer operation. | log buffer space; log file syn | |
Commit & Checkpoint Waits | Log Switch and Clear Wait | The session is waiting for a log switch and clear operation to occur. | checkpoint events; log file switch events | |
Oracle Server Wait | Parallel Query Server Wait | The session is waiting for a parallel query server to become available. | PX create server; PX server shutdown; parallel query; create server; parallel query; dequeue wait | |
Oracle Server Wait | Parallel Query Sync. Wait | The session is waiting for a parallel query server to get synchronized with another parallel query server. | Other PX events; other parallel query events | |
Oracle Server Wait | Resource Manager Wait | The session is waiting for a resource to become available (only if the database resource manager is enabled). | resmgr events | |
Oracle Server Wait | Multi-Threaded Server Wait | The session is waiting for a multi-threaded server to become available. | alter system set dispatcher; alter system set mts_dispatcher | |
Oracle Server Wait | Background Process Wait | The session is waiting for an Oracle background process, such as DBWR or LGWR. | LGWR events | |
Client Request Wait | Request wait | Request wait is generally considered as an idle event as the Oracle server process is waiting for the client process. | Client messages | |
Communication Wait | Oracle/Oracle Communication Wait | The session is waiting for another Oracle instance, usually as a result of a DBLINK event or a standby database. | SQL*Net break/reset to DBLINK; SQL*Net message from DBLINK; SQL*Net message to DBLINK; SQL*Net more data from DBLINK; SQL*Net more data to DBLINK | |
Communication Wait | Oracle/Client Communication Wait | The session is waiting for data sent to the client, usually as a result of a selected statement, or for data sent from a client, usually as a result of bind variables. | SQL*Net break/reset to client; SQL*Net message to client; SQL*Net more data from client; SQL*Net more data to client | |
Internal Lock Wait | Shared Pool Wait | The session is waiting for a shared pool operation. | library cache load lock; library cache lock; library cache pin | |
Internal Lock Wait | Buffer Wait | The session is waiting for a buffer cache operation. | buffer busy; buffer busy wait; buffer latch |
Anchor | ||||
---|---|---|---|---|
|
...
Duration time is the "wall clock time," including idle and non-idle consumption periods. The following calculations are used:
Table 2- 5 Calculations
Calculations | Description |
---|---|
In Oracle time (Avg.) | In Oracle time divided by the amount of executions. |
Duration time (Avg.) | Duration time divided by the amount of executions or sessions (the parameter depends on the entity that is used). |
The following is an explanation based on an example statement using a parallel query.
...
You can find information about how to install Oracle Applications, SAP, PeopleSoft, and Siebel Tier Collectors in the Precise Installation Guide.
Table 2- 6 Mapping of Precise Interpoint entities per technology
Technology | Entity without Interpoint Installed | Entity with Interpoint Installed |
---|---|---|
Oracle Applications | User | User |
Oracle Applications | Program | Form |
Oracle Applications | Module | Application |
Oracle Applications | Action | Request |
Oracle Applications |
Work Type: OA Batch, OA Interactive, OA Self-Service, OA CRM, or Other | ||
SAP | User | User |
SAP | Program | SAP Transaction |
SAP | Module | Function |
SAP | Action | Screen |
SAP |
Work Type: SAP Dialog, SAP Batch, SAP Spool, or SAP Lock/Enqueue | ||
PeopleSoft | User | User |
PeopleSoft | Machine | Machine |
PeopleSoft |
Work Type: PS Interactive, PS Batch, or Other | ||
Siebel | Program | Siebel Views |
Siebel | Module | Siebel Business Objects |
Siebel | Action | Siebel Applications |
Siebel |
Work Type: Interactive, Task Batch, Task Background, or Task Interactive |
Precise for Storage, Oracle version - how resource consumption of storage devices is examined
...
- Type the address of the StartPoint user interface into the Address bar of your browser and click Enter. The Precise login page opens. The login page provides secure access to Precise and to your specific product.
- Specify your authorized role name and password. By default, both role name and password are
admin
. For more information about role names, see the Precise Administration Guide. - Click Login. The StartPoint page opens. This is the Precise home page.
- On the Product Selection bar, from the drop-down list, select the product you want to launch.
Precise. Performance intelligence from click to storage. Learn more > >
...