Cancel Request
Toggle Request Hold
Terminate Request
Kill Session
Kill Session
Applications System Overview
This class includes the following charts:
Form Sessions and Concurrent Requests Activity
This class includes the following data items:
This class includes the following charts:
Form Sessions Instance ID
This class includes the following charts:
Current Form Session Instance ID
This class includes the following data items:
This class includes the following charts:
Top Form Sessions Aud Sid
This class includes the following data items:
This class includes the following charts:
Form Sessions Waiting on Locks
This class includes the following data items:
This class includes the following charts:
Number of Forms Sessions per User
This class includes the following data items:
This class includes the following charts:
Forms Sessions Details for User
This class includes the following data items:
This class includes the following charts:
Number of Forms Sessions per Application
This class includes the following data items:
This class includes the following charts:
Forms Sessions Details for Application
This class includes the following data items:
This class includes the following charts:
Number of Form Sessions per Responsibility
This class includes the following data items:
This class includes the following charts:
Forms Sessions Details for Responsibility
This class includes the following data items:
This class includes the following charts:
Concurrent Request ID
This class includes the following charts:
Overview of Active Requests on the System by Status
This class includes the following data items:
This class includes the following charts:
Number of Active Requests by User
This class includes the following data items:
This class includes the following charts:
Standby Requests for a Specific User
This class includes the following data items:
This class includes the following charts:
Pending Requests for a Specific User
This class includes the following data items:
This class includes the following charts:
Running Requests for a Specific User
This class includes the following data items:
This class includes the following charts:
Number of Active Requests by Application
This class includes the following data items:
This class includes the following charts:
Standby Requests for a Specific Application
This class includes the following data items:
This class includes the following charts:
Pending Requests for a Specific Application
This class includes the following data items:
This class includes the following charts:
Running Requests for a Specific Application
This class includes the following data items:
This class includes the following charts:
Number of Active Requests by Responsibility
This class includes the following data items:
This class includes the following charts:
Standby Requests for a Specific Responsibility
This class includes the following data items:
This class includes the following charts:
Pending Requests for a Specific Responsibility
This class includes the following data items:
This class includes the following charts:
Running Requests for a Specific Responsibility
This class includes the following data items:
This class includes the following charts:
Running Requests Sorted by Selection
This class includes the following data items:
This class includes the following charts:
10 Longest Running Requests
This class includes the following data items:
This class includes the following charts:
Locked Session ID and Locking Session ID
This class includes the following data items:
This class includes the following charts:
10 Longest Pending or Standby Requests
This class includes the following data items:
This class includes the following charts:
Completed Requests by Status
This class includes the following data items:
This class includes the following charts:
Requests Completed With Warning
This class includes the following data items:
This class includes the following charts:
Requests Completed With Error
This class includes the following data items:
This class includes the following charts:
All Standby Requests
This class includes the following data items:
This class includes the following charts:
All Pending Requests
This class includes the following data items:
This class includes the following charts:
All Running Requests
This class includes the following data items:
This class includes the following charts:
Requests Waited on
This class includes the following data items:
This class includes the following charts:
Concurrent Managers Data
This class includes the following charts:
Number of pending requests per manager
This class includes the following data items:
This class includes the following charts:
Pending Request Details for Manager
This class includes the following data items:
This class includes the following charts:
Number of standby requests per manager
This class includes the following data items:
This class includes the following charts:
Standby Request Details for Manager
This class includes the following data items:
This class includes the following charts:
Number of running requests per manager
This class includes the following data items:
This class includes the following charts:
Running Requests Details for Manager
This class includes the following data items:
This class includes the following charts:
Maximum Number of Allotted Processes per manager
This class includes the following data items:
This class includes the following charts:
Concurrent processes for a particular manager
This class includes the following data items:
This class includes the following charts:
Sessions Currently Blocking CRM/ICM Activity
This class includes the following data items:
This class includes the following charts:
Oracle Database Session
Session Details
This class includes the following data items:
This class includes the following charts:
Session Details
This class includes the following data items:
This class includes the following charts:
Session Details
This class includes the following data items:
This class includes the following charts:
Session Details
This class includes the following data items:
This class includes the following charts:
Session Statistics
This class includes the following data items:
This class includes the following charts:
Session Statistics
This class includes the following data items:
This class includes the following charts:
Session Statistics
This class includes the following data items:
This class includes the following charts:
Session Statistics
This class includes the following data items:
This class includes the following charts:
Current SQL for Session
This class includes the following data items:
This class includes the following charts:
Current SQL for Session
This class includes the following data items:
This class includes the following charts:
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
Help not available.
This chart group pulls together interactive user and concurrent request information to give an overview of system activity.
This chart group identifies the processes consuming the greatest amounts of a specified resource in an Applications system.
The Form Sessions and Concurrent Requests chart displays the number of open form sessions, the number of standby requests, the number of pending requests, and the number of running requests. You can drill down to the following charts: Current Form Sessions Chart, All Standby Requests Chart, All Pending Requests Chart, and All Running Requests Chart.
This chart includes the following data items:
The Form Sessions Summary chart group gives an overview of active sessions per user, application, and responsibility.
The Current Form Sessions chart shows the currently active form sessions. You can set the collection options for this chart to limit the number of rows returned. For a given form session, you can drill down to the Session Details Chart and the Session Statistics Chart.
This chart includes the following data items:
The Top Form Sessions chart shows form sessions consuming the greatest amounts of a specified resource. You can choose from the following resources in the collection options: Session UGA Memory, Session PGA Memory, CPU Used by this Session, Physical Reads, Physical Writes, Open Cursors, User Commits, and User Rollbacks. Also, the number of rows displayed by this chart can be limited in the collection options. For a particular form session, you can drill down to the Session Details Chart and the Session Statistics Chart.
This chart includes the following data items:
The Form Sessions Waiting on Locks chart shows the form sessions waiting on database locks. You can set the collection options for this chart to limit the number of rows returned. You can drill down to the following charts for both the waiting and the locking sessions: Session Details Chart and the Session Statistics Chart.
This chart includes the following data items:
The Form Sessions per User chart shows the count of the active form sessions for a user. A user will not appear in the chart unless that user has at least one active session. You can set the collection options for this chart to limit the number of rows returned. For a given user, you can drill down to the Forms Sessions Details for User Chart.
This chart includes the following data items:
The Form Sessions Details for User chart is similar to the Current Form Sessions Chart except that it only includes the form sessions for a specific user. For a given form session, you can drill down to the Session Details Chart and the Session Statistics Chart.
This chart includes the following data items:
The Form Sessions per Application chart shows the count of the active form sessions for an application. An application will not appear in the chart unless that application has at least one active session. For a given application, you can drill down to the Forms Sessions Details for Application Chart.
This chart includes the following data items:
The Form Sessions Details for Application chart is similar to the Current Form Sessions Chart except that it only includes the form sessions for a specific application. You can set the collection options for this chart to limit the number of rows returned. For a given form session, you can drill down to the Session Details Chart and the Session Statistics Chart.
This chart includes the following data items:
The Form Sessions per Responsibility chart shows the count of the active form sessions for a responsibility. A responsibility will not appear in the chart unless that responsibility has at least one active session. You can set the collection options for this chart to limit the number of rows returned. For a given responsibility, you can drill down to the Forms Sessions Details for Responsibility Chart.
This chart includes the following data items:
The Form Sessions Details for Responsibility chart is similar to the Current Form Sessions Chart except that it only includes the form sessions for a specific responsibility. For a given form session, you can drill down to the Session Details Chart and the Session Statistics Chart.
This chart includes the following data items:
An active request is a concurrent request that is pending, standby, or running. This chart group provides several different views of the volume of active requests on a system.
This group contains the following charts: Standby Requests for User Chart, Pending Requests for User Chart, and Running Requests for User Chart.
This group contains the following charts: Standby Requests for Application Chart, Pending Requests for Application Chart, and Running Requests for Application Chart.
This group contains the following charts: Standby Requests for Responsibility Chart, Pending Requests for Responsibility Chart, and Running Requests for Responsibility Chart.
The Active Requests by Status chart shows the numbers of pending, standby, and running requests on the system. This chart deals with requests that are currently being processed by the system and filters out scheduled requests and requests that are on hold. You can drill down to the following charts: All Standby Requests Chart, All Pending Requests Chart, and All Running Requests Chart. Note: The All Standby Requests, All Pending Requests, and All Running Requests charts do not filter out scheduled requests and requests that are on hold.
This chart includes the following data items:
The Active Requests per User chart shows the count of the active requests for a user. A user will not appear in the chart unless that user has at least one active request. For a given user, you can drill down to the following charts: Active Requests Detail for User Group, Standby Requests for User Chart, Pending Requests for User Chart, and Running Requests for User Chart.
This chart includes the following data items:
The Standby Requests for User chart lists the standby requests for a specific user. For a given request, you can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The Pending Requests for User chart lists the pending requests for a specific user. For a given request, you can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu
This chart includes the following data items:
The Running Requests for User chart lists the running requests for a specific user. For a given request you can drill down to the Session Details Chart and the Session Statistics Chart. You can terminate the request by selecting Terminate Request from the drill-down menu.
This chart includes the following data items:
The Active Requests per Application chart shows the count of the active requests for each application. An application will not appear in the chart unless that application has at least one active request. For a given application, you can drill down to the following charts: Active Requests Detail for Application Group, Standby Requests for Application Chart, Pending Requests for Application Chart, and Running Requests for Application Chart.
This chart includes the following data items:
The Standby Requests for Application chart lists the standby requests for a specific application. For a given request, you can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The Pending Requests for Application chart lists the pending requests for a specific application. For a given request, you can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The Running Requests for Application chart lists the running requests for a specific application. For a given request, you can drill down to the Session Details Chart and the Session Statistics Chart. You can terminate the request by selecting Terminate Request from the drill-down menu.
This chart includes the following data items:
The Active Requests per Responsibility chart shows the count of the active requests for a responsibility. For a given responsibility, you can drill down to the following charts: Active Requests Detail for Responsibility Group, Standby Requests for Responsibility Chart, Pending Requests for Responsibility Chart, and Running Requests for Responsibility Chart.
This chart includes the following data items:
The Standby Requests for Responsibility chart lists the standby requests for a specific responsibility. For a given request, you can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The Pending Requests for Responsibility chart lists the pending requests for a specific responsibility. For a given request, you can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The Running Requests for Responsibility chart lists the running requests for a specific responsibility. For a given request, you can drill down to the Session Details Chart and the Session Statistics Chart. You can terminate the request by selecting Terminate Request from the drill-down menu.
This chart includes the following data items:
The Top Running Requests chart shows running requests consuming the greatest amounts of a specified resource. You can choose from the following resources in the collection options: Session UGA Memory, Session PGA Memory, CPU Used by this Session, Physical Reads, Physical Writes, Open Cursors, User Commits, and User Rollbacks. Also, the number of rows displayed by this chart can be limited in the collection options.
This chart includes the following data items:
The Longest Running Requests chart lists the longest running request on a system. The number of rows that are displayed by this chart can be limited in the collection options. For a given request, the user can drill down to the Session Details Chart and the Session Statistics Chart. You can terminate the request by selecting Terminate Request from the drill-down menu
This chart includes the following data items:
The Requests Waiting on Locks chart shows the running requests waiting on database locks. You can set the collection options for this chart to limit the number of rows returned. You can drill down to the Session Details Chart and the Session Statistics Chart for both the waiting and the locking sessions.
This chart includes the following data items:
The Longest Pending Requests chart lists the requests that have been pending or on standby for the longest time. The number of rows that are displayed by this chart can be limited in the collection options. For a given request, you can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The Completed Requests by Status chart shows the numbers of requests that completed with success, warning, and error. You can drill down to the Completed with Warning Chart and the Completed with Error Chart.
This chart includes the following data items:
The Completed with Warning chart lists the requests that have completed with warnings. The number of rows that are displayed by this chart can be limited in the collection options.
This chart includes the following data items:
The Completed with Error chart lists the requests that have completed with errors. The number of rows that are displayed by this chart can be limited in the collection options.
This chart includes the following data items:
The All Standby Requests chart lists all standby requests. You can set the collection options for this chart to limit the number of rows returned. You can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The All Pending Requests chart lists all pending requests.You can set the collection options for this chart to limit the number of rows returned. You can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The All Running Requests chart lists all running requests. You can set the collection options for this chart to limit the number of rows returned. You can drill down to the Session Details Chart and the Session Statistics Chart. You can terminate the request by selecting Terminate Request from the drill-down menu.
This chart includes the following data items:
For a given pending or standby concurrent request X, the Requests Waited On chart lists all the requests that must complete before request X can begin. For each request that appears in this chart, a reason is given for its appearance. Valid reasons include: Incompatible with request X, Single-threaded with request X, Parent waiting for child request X, and Run-alone ahead of request X. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The Concurrent Managers Status chart group gives an overview of the status of the concurrent managers. The charts in this group deal with requests that are currently being processed by the system. They filter out scheduled requests and requests that are on hold.
The Pending Requests per Manager chart shows the number of requests pending for each manager. It does not include standby requests or requests on hold. For a given manager, you can drill down to the Pending Request Details for Manager Chart.
This chart includes the following data items:
The Pending Request Details for Manager chart lists the pending requests for a particular manager. You can set the collection options for this chart to limit the number of rows returned. For a given request, you can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The Standby Requests per Manager chart shows the number of standby requests for each manager. For a given manager, you can drill down to the Running Requests Details for Manager Chart.
This chart includes the following data items:
The Standby Request Details for Manager chart lists the standby requests for a particular manager. You can set the collection options for this chart to limit the number of rows returned. For a given request, you can drill down to the Requests Waited On Chart. You can also cancel or toggle hold the request by selecting Cancel Request or Toggle Request Hold from the drill-down menu.
This chart includes the following data items:
The Running Requests per Manager chart shows the number of running requests for each manager. For a given manager, you can drill down to the Running Requests Details for Manager Chart.
This chart includes the following data items:
The Running Requests Details for Manager chart lists the running requests for a particular manager. You can set the collection options for this chart to limit the number of rows returned. For a given request, you can drill down to the Session Details Chart and the Session Statistics Chart. You can terminate the request by selecting Terminate Request from the drill-down menu.
This chart includes the following data items:
The Processes per Manager chart shows the number of "worker" processes or "slots" that each manager has to run requests. For a given manager, you can drill down to the Process Details for Manager Chart.
This chart includes the following data items:
The Process Details for Manager chart lists the concurrent processes for a particular manager. You can set the collection options for this chart to limit the number of rows returned. For a given process, you can drill down to the Session Details Chart and the Session Statistics Chart.
This chart includes the following data items:
Because there is only one Internal Concurrent Manager (ICM) process and one Conflict Resolution Manager (CRM) process, system performance is reduced when either of these processes is blocked. The Sessions Blocking CRM/ICM Activity chart shows the sessions currently blocking ICM and CRM activity. You can drill down to the Session Details Chart and the Session Statistics Chart.
This chart includes the following data items:
The Session Details chart gives information about a single database session from the V$SESSION table. For a given session, you can drill down to the Current SQL for Session Chart or you can delete the session by selecting Kill Session from the drill-down menu.
This chart includes the following data items:
The Session Details chart gives information about a single database session from the V$SESSION table. For a given session, you can drill down to the Current SQL for Session Chart or you can delete the session by selecting Kill Session from the drill-down menu.
This chart includes the following data items:
The Session Details chart gives information about a single database session from the V$SESSION table. For a given session, you can drill down to the Current SQL for Session Chart or you can delete the session by selecting Kill Session from the drill-down menu.
This chart includes the following data items:
The Session Details chart gives information about a single database session from the V$SESSION table. For a given session, you can drill down to the Current SQL for Session Chart or you can delete the session by selecting Kill Session from the drill-down menu.
This chart includes the following data items:
The Session Statistics chart gives the statistics from V$SESSTAT for a given database session. Note: To collect certain session statistics, such as session CPU time, the TIMED_STATISTICS database parameter must be set to true in the init.ora file. Some overhead may be incurred if the TIMED_STATISTICS parameter is set to true. If the parameter is set to false, then certain statistics, such as session CPU time, will always be 0. Refer to the Oracle database documentation for more information about timed statistics.
This chart includes the following data items:
The Session Statistics chart gives the statistics from V$SESSTAT for a given database session. Note: To collect certain session statistics, such as session CPU time, the TIMED_STATISTICS database parameter must be set to true in the init.ora file. Some overhead may be incurred if the TIMED_STATISTICS parameter is set to true. If the parameter is set to false, then certain statistics, such as session CPU time, will always be 0. Refer to the Oracle database documentation for more information about timed statistics.
This chart includes the following data items:
The Session Statistics chart gives the statistics from V$SESSTAT for a given database session. Note: To collect certain session statistics, such as session CPU time, the TIMED_STATISTICS database parameter must be set to true in the init.ora file. Some overhead may be incurred if the TIMED_STATISTICS parameter is set to true. If the parameter is set to false, then certain statistics, such as session CPU time, will always be 0. Refer to the Oracle database documentation for more information about timed statistics.
This chart includes the following data items:
The Session Statistics chart gives the statistics from V$SESSTAT for a given database session. Note: To collect certain session statistics, such as session CPU time, the TIMED_STATISTICS database parameter must be set to true in the init.ora file. Some overhead may be incurred if the TIMED_STATISTICS parameter is set to true. If the parameter is set to false, then certain statistics, such as session CPU time, will always be 0. Refer to the Oracle database documentation for more information about timed statistics.
This chart includes the following data items:
The Current SQL for Session chart gives the SQL statement from V$SQLTEXT for a given session.
This chart includes the following data items:
The Current SQL for Session chart gives the SQL statement from V$SQLTEXT for a given session.
This chart includes the following data items: