Versions Compared

Key

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

...

Info

If you are working with Oracle Applications, SAP, PeopleSoft, or Siebel and ERP support is installed, the Activity tab displays information on the historical Oracle activity in relation to the ERP application and users, and specific information on executed forms (Oracle Applications) and transactions (SAP).

See “Precise Precise Interpoint - how resource consumption of packaged applications is examined” on page 40examined.

Anchor
HowtheActivitytabisstructured
HowtheActivitytabisstructured
How the Activity tab is structured

...

You can use the Filter dialog box to filter the Association area so that only the contribution of certain entities is included. See “Filtering data” on page 29 Filtering data.

About the Table view

The Table view is divided into two areas, the Main area and the Association area. Information on the entity you are analyzing is displayed in the Main area. The entities that are associated with the entity displayed in the Main area are displayed in Association area.

...

The duration value displayed next to each entry reflects the duration of each instance in the selected entity, according to the sort parameter you selected. The sort parameter is displayed next to each entity. The default entity for the top entity in the tree is In Oracle time. You change this setting in the Settings dialog box. See “About About configuring Tree view settings” on page 27settings.

Info

The following entities are not displayed in the Tree view: Recent Sessions, Extended Collections and Imported Statements. The Database entity is only displayed when All Instances is selected.

...

You can also save a statement. See “Editing Editing the properties of a statement” on page 31statement.

The following views are available for a statement and PL/SQL entity:

...

ItemDescription
Parsing UserOracle user name used to explain and parse the statement.
CabinetName of the cabinet where the statement is stored.
FolderName of the folder where the statement is stored.
Origin

Source of the statement. The Collector captures most statements automatically when they execute. The following values are possible:

  • Unknown
  • Automatically collected
  • Generated as related SQL
  • Predicted plan (What-If)
  • Entered by user
  • Imported from source file
  • Generated as related SQL by user
CommentUser-defined comment associated with the statement.

See “Editing Editing the properties of a statement” on page 31. See “About statement and “About the SQL tab” on page 131.

...

  • Overview
  • In Oracle
  • Overall Activity

See “Defining extended collections” on page 80 and “Filtering data” on page 29 Defining extended collections and Filtering data.

About the overview of an extended collection

...

ItemDescription
StatusStatus of the collection, which can be one of the following: Pending, Completed, Running, or Stopped.
CriteriaList of programs and other criteria that are included or excluded in the collection.
Current SizeSize of the collection. The size is limited when the collection is created. See “Defining extended collections” on page 80 Defining extended collections.
Start Collecting atStart date and time of the collection.
Stop Collecting atEnd date and time of the collection.

...

ItemDescription
Explained onThe date and time of the last explain.
Parsing UserOracle user name used to explain and parse the statement.
CabinetName of the cabinet where the statement is stored.
FolderName of the folder where the statement is stored.
OriginSource of the statement. In this case, it is always Imported from source file.
CostThe cost of the imported statement.
Saved onInformation on when the imported statement was saved.
StatementThe name of the imported statement.
Oracle Hash ValueThe Oracle Hash value of the imported statement.
CommentUser-defined comment associated with the statement. This is blank until the statement has been saved.

See “Editing Editing the properties of a statement” on page 31 and statement and “About the SQL tab” on page 131.

...

See “Editing Editing the properties of a statement” on page 31statement.

Anchor
Definingextendedcollections
Definingextendedcollections
Defining extended collections

...

The Import Statement button opens the Import Statements from File dialog box, allowing you to import SQL statements from a file. This dialog box includes three tabs: Source, Catalog, and Options. See “Editing Editing the properties of a statement” on page 31. See “About statement and “About the Imported Statement entity” on page 78.

...