Working with reports

BMC PATROL for Oracle e-Business Suite offers the following reports:

OA_CONM reports

The OA_CONM application class offers the following KM-specific reports:

Command

Reports

System Reports

Accesses the following reports:

  • Concurrent Manager Definition Report
  • Active Concurrent Manager Processes Report
  • Inactive Concurrent Managers Report
  • Problem Concurrent Managers Report
  • Running Managers Report

Performance Analysis

Accesses the following reports:

  • Waiting Time Statistics Report
  • Concurrent Manager Utilization Report
Concurrent Manager Definition report

The OA_CONM Concurrent Manager Definition report displays the following information:

Application Name

Responsible application

Q ID

Queue ID

Manager

Assigned concurrent manager

Running

Number of running processes

Max

Maximal amount of target processes

Buf

Buffer name

Sleep(s)

Sleep time in seconds

Active Concurrent Manager Processes report

The OA_CONM Active Concurrent Managers report displays the following information:

Conc Pid

The process ID of the concurrent manager

Oracle Pid

The process ID of the processes running on the Oracle database

System Pid

The process ID of the processes running on the system operator

Manager

Assigned concurrent manager

Node

Node path

Started at

Start time

Inactive Concurrent Managers report

The OA_CONM Inactive Concurrent Managers report displays the following information:

Application Name

Responsible application

Q ID

Queue ID

Manager

Assigned concurrent manager

Max

Maximal amount of target processes

Problem Concurrent Managers report

The OA_CONM Problem Concurrent Managers report displays the following information:

Concurrent PID

The process ID of the concurrent manager

Oracle PID

The process ID of the processes running on the Oracle database

System PID

The process ID of the processes running on the system operator

Manager

Assigned concurrent manager

Node

Node path

Started at

Start time

Running Managers report

The OA_CONM Running Managers report displays the following information:

Manager

Assigned concurrent manager

Request

Responsible concurrent request

Program

Program name

User name

Submitted user name

Started at

Start time

Waiting Time Statistics report

The OA_CONM Waiting Time Statistics report displays the following information:

Concurrent Manager

Assigned concurrent manager

Average Wait in Minutes

Average waiting time in minutes

Minimum Wait in Minutes

Minimum waiting time in minutes

Maximum Wait in Minutes

Maximum waiting time in minutes

OA_CONM Concurrent Manager Utilization report

The OA_CONM Concurrent Manager Utilization report displays the following information:

Concurrent Manager

Assigned concurrent manager

Minutes Consumed

Number of minutes consumed

Utilization (%)

The percentage of time this concurrent manager spent processing concurrent requests

OA_DB reports

The OA_DB application class offers the following KM-specific reports:

Command

Reports

System Reports

Accesses the following reports:

  • DB Initial Parameters Report
  • Database Invalid Objects Report
DB Initial Parameters report

The OA_DB DB Initial Parameters report displays the following information:

  • Parameter Name
  • Value
Database Invalid Objects report

The OA_DB Database Invalid Objects report displays the following information:

  • Owner
  • Object Type
  • Object Name
OA_MGR reports

The OA_MGR application class offers the following KM-specific reports:

  • Waiting Time Statistics Report
  • Concurrent Manager Utilization Report
Waiting Time Statistics report

The OA_MGR Waiting Time Statistics report displays the following information:

Concurrent Manager

Assigned concurrent manager

Average Wait in Minutes

Average waiting time in minutes

Minimum Wait in Minutes

Minimum waiting time in minutes

Maximum Wait in Minutes

Maximum waiting time in minutes

OA_MGR Concurrent Manager Utilization report

The OA_MGR Concurrent Manager Utilization report displays the following information:

Concurrent Manager

Assigned concurrent manager

Minutes Consumed

Number of minutes consumed

Utilization (%)

The percentage of time this concurrent manager spent processing concurrent requests

OA_PROCESS reports

The OA_PROCESS application class offers the following KM-specific reports:

Command

Reports

System Reports

Accesses the following reports:

  • All DB Processes Report
  • Application Processes Report
All DB Processes report

The OA_PROCESS All Database Processes report displays the following information about all database processes related to Oracle Applications:

OS User

OS user name

OS PID

The process ID of the Operating System

DB Srv/OS PID

Database server/OS process ID

Oracle User

Oracle user name

Oracle PID

The process ID of the processes running on the Oracle database

Oracle SID

The Oracle system ID

Audit SID

The Oracle audit system ID

Session Serial #

session serial number

Start Time

start time

Status

status

Background

background

Program Name

program name

Application Processes report

The OA_PROCESS Application Processes report displays the following information about all user logon processes on the Oracle Application (including child processes):

OS User

OS user name

OS PID

The process ID of the Operating System

DB Srv/OS PID

Database server/OS process ID

Oracle User

Oracle user name

Oracle PID

The process ID of the processes running on the Oracle database

Oracle SID

The Oracle system ID

Audit SID

The Oracle audit system ID

Session Serial #

Session serial number

Start Time

Start time

Status

Process status

Login

User logon status

Appl User

Oracle Applications user name

App

Short name of responsible application within Oracle Applications

Program Name

Program name

OA_REQUEST reports

The OA_REQUEST application class offers the following KM-specific reports:

Command

Report

System Report

Accesses the following reports:

  • Concurrent Request History Report
  • Error Warning Completed Report

Performance Analysis

Accesses the following reports:

  • Top 10 Time Consuming Requests Report
  • Concurrent Request Summary Report
Concurrent Request History report

The OA_REQUEST Concurrent Request History report displays the following information:

Starting Time

Starting time

Completion Time

Completion time

Execution Time

Execution time in seconds

Requested By

Name of user submittng the request

App

Responsible application within Oracle Applications

Manager

Assigned concurrent manager

Status

Status of the concurrent request

Error/Warning Completed report

The OA_REQUEST Error/Warning Completed report displays the following information:

Req ID

Concurrent request ID

Program

Concurrent program name

Starting Time

Starting time

Requested By

Name of user submittng the request

App

Responsible application within Oracle Applications

Manager

Assigned concurrent manager

Status

Status of the concurrent request

Log File Name

Path of the log file location

Top 10 Time Consuming Requests report

The OA_REQUEST Top 10 Time Consuming Requests report displays the following information for all applications (Overall) or for selected applications (By Application):

Program name

Concurrent program name

Starting Time

Starting time

Requested By

Name of user submittng the request

App

Responsible application within Oracle Applications

Secs

Running time in seconds

Concurrent Request Summary report

The OA_REQUEST Concurrent Request Summary report displays the following information, sorted either by program name or by average execution time:

Program Name

Concurrent program name

Type

Request type

Total Count

Total execution count

Avg Wait Time (sec)

Average waiting time from the requested starting time

Min Wait Time (sec)

Minimum waiting time from the requested starting time

Max Wait Time (sec)

Maximum waiting time from the requested starting time

Avg Exec Time (sec)

Average running time for normally completed requests

Min Exec Time (sec)

Minimum running time for normally completed requests

Max Exec Time (sec)

Maximum running time for normally completed requests

OA_SYSTEM reports

The OA_SYSTEM application class offers the following KM-specific reports:

Command

Description

System report

Accesses the following reports:

  • Installed Modules Report
  • Application Environment Variable Values Report
Installed Modules report

The OA_SYSTEM Installed Modules report displays the following information:

  • Application name
  • Short name
  • Version
  • Status
Application Environment Variable Values report

The OA_SYSTEM Installed Modules report displays the following information:

  • Name
  • Value
OA_TABLESPACE reports

The OA_TABLESPACE application class offers the following KM-specific reports:

Command

Report

System Report

Accesses the following reports:

  • Object with Big Next Event Report
  • Object with Events that Exceed Threshold Report
  • Data File Information Report
Object with Big Next Event report

The OA_TABLESPACE Object with Big Next Event report displays the following information:

  • Segment name
  • Segment type
  • Extents
  • Next Extent Size
  • Bytes
Object with Events that Exceed Threshold report

The OA_TABLESPACE Object with Events that Exceed Threshold report displays the following information:

  • Segment Name
  • Segment Type
  • Extents
  • Owner
  • Tablespace
Data File Information report

The OA_TABLESPACE Data File Information report displays the following information:

  • File Name
  • Size
  • File ID
  • Status
OA_SELF_APP_USERS reports

The OA_SELF_APP_USERS application class offers the following KM-specific reports:

Command

Report

System Report

Accesses the following reports:

  • Application User Logins Report
  • Application User Detail Report
OA_USER reports

The OA_USER application class offers the following KM-specific reports::

Command

Report

System Report

Accesses the following reports:

  • Application User Logins Report
  • Application User Detail Report
Application User Logins report

The OA_USER Application User Logins report displays the following information:

Application User Name

Application User Name

Oracle User Name

Oracle user name

OS User Name

OS user name

OS PID

The process ID of the Operating System

Oracle PID

Oracle process ID

# Oracle sessions

number of Oracle sessions

Connection Time

Connection time

Terminal

Terminal

Appl Abbr

Responsible application within Oracle Applications

Application User Detail report

The OA_USER Application User Detail report displays the following information:

Admin Information

  • user name
  • user ID
  • name
  • phone number
  • e-mail address
  • location

Session Information

OS user name

OS user name

OS PID

The process ID of the Operating System

PPID

The parent process ID of the Operating System

CPU%

The percentage of CPU usage

Proc Size

Process size

DB Srv PID

The process ID of the database server

DB Srv PPID

The parent process ID of the database server

DB CPU%

The CPU usage of the database server

DBPr Size

The size of the database server process

Oracle User Name

Oracle User Name

Oracle SID

The Oracle system ID

Audit SID

The Oracle audit system ID

Start Time

Start Time

Status

Status

Blocked/Idle Time (min)

Blocked or Idle Time in minutes

Program

Program name

Note

If you select the Session Info, the report also displays the SQL address and the related SQL command.

Related topics

OA_CONM
OA_CONM-menu
OA_DB
OA_DB-menu
OA_MGR
OA_MGR-menu
OA_USER
OA_USER-menu
OA_SELF_APP_USERS
OA_SELF_APP_USERS-menu
OA_PROCESS
OA_PROCESS-menu
OA_REQUEST
OA_REQUEST-menu
OA_REQUEST concurrent request summary
OA_SYSTEM
OA_SYSTEM-menu
Identifying top 10 Time Consuming Requests
OA_USER
OA_USER-menu
OA_SELF_APP_USERS
OA_SELF_APP_USERS-menu

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*