Versions Compared

Key

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

...

The following table describes which tasks can be performed in each tab.

Table 2- 1 Tabs in Precise for Oracle

TabDescription
DashboardLets 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.
CurrentLets you identify and solve the performance problems that are happening now.
ActivityLets you examine the application's performance over time and helps locate performance bottlenecks in its behavior.
ObjectsLets 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.
SQLLets you tune problematic SQL statements.
What-IfLets you simulate the effect of any index change on SQL statements running in your application.
StatisticsLets you examine Oracle's own statistics and see graphs of their variation over time. It is primarily used for instance tuning.
Oracle ApplicationsLets 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
Howmosttabsarestructured
Howmosttabsarestructured
How most tabs are structured

...

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

IconNameDescription
Image Modified
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.

Image Modified
ForwardEnables you to navigate to the next view. This button is only enabled if you clicked Back or if you chose a history option.
Image Modified
AdminPointLaunches Precise AdminPoint.
Image Modified
HomeNavigates to the highest level entity, usually the instance or Tier (all instances). The time frame settings remain the same.
Image Modified
StopStops a request for information from the server.
Image Modified
RefreshUpdates the data currently displayed.
Image Modified
FavoritesEnables you to add or remove favorites in your Favorites list.
Image Modified
SendOpens a new email message in your email program with the link to the current application in context.
Image Modified
SettingsOpens the Findings Settings, General Settings, and Time Frame Settings dialog boxes.
Image Modified
HelpOpens 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

ColumnDescription
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:

  • Red. High severity
  • Orange. Medium severity
  • Yellow. Low severity
  • Blue. No severity - the finding is strictly informative

By default, findings are displayed according to severity.

FindingA 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.

Info

Rows are aggregated by finding and the URI/method/SQL name and not by ID.

Finding overview

Displays specific details regarding the finding in context.

Info

This is displayed in the expanded view only.

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.

Info

This is displayed in the expanded view only.

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.

Info

This is displayed in the expanded view only.

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
Determiningwhichtablecolumnstodisplay
Determiningwhichtablecolumnstodisplay
Determining which table columns to display

...

The following table lists the existing In Oracle states.

Table 2- 4 In Oracle states

In Oracle StateIconIn Oracle Sub-StateDescriptionTypical Oracle Events
Using CPU
Image Modified
Using CPUThe session is using CPU executing SQL.N/A
I/O Wait
Image Modified
Direct I/O WaitThe session is waiting on direct I/O.direct path read; direct path write
I/O Wait
Image Modified
Scattered I/O WaitThe session is waiting on scattered I/O.db file scattered read
I/O Wait
Image Modified
Sequential I/O Waitthe session is waiting on sequential I/O.db file sequential read; control file sequential read
I/O Wait
Image Modified
Other I/O Waitthe 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
Image Modified
 

Info

The I/O sub-states Direct I/O Wait, Scattered I/O Wait, Sequential I/O Wait, and Other

I/O Wait only apply to Oracle files, objects, and storage entities. For other entities, the sub-state is simply shown as I/O Wait.

 


Application Lock Wait
Image Modified 
Row Lock Waitthe session is waiting on row locks. Enq: TX - row lock contention (Oracle 10g)
 

Application Lock Wait
Image Modified
 Table Lock WaitThe session is waiting on table locks.Enq: TM - contention (Oracle 10g)
Internal Lock Wait
Image Modified
Other Lock WaitThe 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
Image Modified
 

Info

Enqueue may appear in Row Lock Wait and Table Lock Wait, depending on the values of the P1, P2, and P3 parameters. The Collector captures these parameters and assigns the wait state accordingly. This can be seen in the Current and Activity tabs. However, the Collect Instance Statistics PMDB process does not capture the parameters so that in the Statistics tab, the wait is always shown as Other Lock Wait.   

 

Operating System Waits
Image Modified
CPU WaitThe session is in the operating system queue waiting for CPU.N/A
Operating System Waits
Image Modified
Memory WaitThe 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
Image Modified
Other Host WaitThe session is waiting on another type of OS operation, such as sorting.N/A
RAC/OPS/ Other Waits
Image Modified
RAC/OPS WaitThe session is waiting on RAC or OPS synchronization.DFS events; DLM events; gc events; gcs events; ges events; global events
RAC/OPS/ Other Waits
Image Modified
Other WaitThe session is waiting on another, less common lock event.N/A
Commit & Checkpoint Waits
Image Modified
Rollback Segment WaitThe session is waiting on a rollback segment operation.alter rbs offline; undo segment events
Commit & Checkpoint Waits
Image Modified
Redo Log Buffer WaitThe session is waiting on a redo log buffer operation.log buffer space; log file syn
Commit & Checkpoint Waits
Image Modified
Log Switch and Clear WaitThe session is waiting for a log switch and clear operation to occur.checkpoint events; log file switch events
Oracle Server Wait
Image Modified
Parallel Query Server WaitThe 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
Image Modified
Parallel Query Sync. WaitThe 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
Image Modified
Resource Manager WaitThe session is waiting for a resource to become available (only if the database resource manager is enabled).resmgr events
Oracle Server Wait
Image Modified
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
Image Modified
Background Process WaitThe session is waiting for an Oracle background process, such as DBWR or LGWR.LGWR events
Client Request Wait
Image Modified
Request waitRequest wait is generally considered as an idle event as the Oracle server process is waiting for the client process.Client messages
Communication Wait
Image Modified
Oracle/Oracle Communication WaitThe 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
Image Modified

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
Image Modified
Shared Pool WaitThe session is waiting for a shared pool operation.library cache load lock; library cache lock; library cache pin
Internal Lock Wait
Image Modified
Buffer WaitThe session is waiting for a buffer cache operation.

buffer busy; buffer busy wait; buffer latch

Anchor
IOwait
IOwait
I/O wait

...

Duration time is the "wall clock time," including idle and non-idle consumption periods. The following calculations are used:

Table 2- 5 Calculations

CalculationsDescription

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

TechnologyEntity without Interpoint InstalledEntity with Interpoint Installed
Oracle ApplicationsUserUser
Oracle ApplicationsProgramForm
Oracle ApplicationsModuleApplication
Oracle ApplicationsActionRequest
Oracle Applications
 

Work Type: OA Batch, OA Interactive, OA Self-Service, OA CRM, or Other
SAPUserUser
SAPProgramSAP Transaction
SAPModuleFunction
SAPActionScreen
SAP
 

Work Type: SAP Dialog, SAP Batch, SAP Spool, or SAP Lock/Enqueue

PeopleSoft

UserUser
PeopleSoftMachineMachine
PeopleSoft
 

Work Type: PS Interactive, PS Batch, or Other
SiebelProgramSiebel Views
SiebelModuleSiebel Business Objects
SiebelActionSiebel 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

...

  1. 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.
  2. 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.
  3. Click Login. The StartPoint page opens. This is the Precise home page.
  4. 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 > >

...