Page History
...
Table 9-1 Oracle Activity by Instance fields
| Field | Description |
|---|---|
| Instance | Displays the Oracle database instances included in the same application. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database, using the database link. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database, using the database link. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of Oracle programs with SLA settings that did not meet Oracle programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of Oracle programs with SLA settings that are close to their Oracle programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of Oracle programs with SLA settings that did meet the Oracle programs' SLA. |
See “About About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining portlets, Configuring the portlet, and Defining the portlet data preferences” on page 34preferences.
| Anchor | ||||
|---|---|---|---|---|
|
...
Table 9-2 Oracle Activity Over Time fields
| Field | Description |
|---|---|
| Date and Time | Displays the date and timestamp of the data available in the selected time frame. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database, using the database link. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database, using the database link. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of Oracle programs with SLA settings that did not meet Oracle programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of Oracle programs with SLA settings that are close to their Oracle programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of Oracle programs with SLA settings that did meet the Oracle programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...
Table 9-3 Oracle Top Programs fields
| Field | Description |
|---|---|
| Program | Displays the top Oracle program or programs. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database, using the database link. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database, using the database link. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of Oracle programs with SLA settings that did not meet Oracle programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of Oracle programs with SLA settings that are close to their Oracle programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of Oracle programs with SLA settings that did meet the Oracle programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...
Table 9-4 Oracle Top Statements fields
| Field | Description |
|---|---|
| Statement | Displays the hash values of the top SQL statements running in an Oracle database. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database, using the database link. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database, using the database link. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of Oracle programs with SLA settings that did not meet Oracle programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of Oracle programs with SLA settings that are close to their Oracle programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of Oracle programs with SLA settings that did meet the Oracle programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...
Table 9-5 Oracle Top Users fields
| Field | Description |
|---|---|
| User | Displays the top Oracle users in the selected application. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database, using the database link. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database, using the database link. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of Oracle programs with SLA settings that did not meet Oracle programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of Oracle programs with SLA settings that are close to their Oracle programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of Oracle programs with SLA settings that did meet the Oracle programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...
Table 9-6 SQL Server Activity by Database field
| Field | Description |
|---|---|
| Database | The names of the SQL Server databases within SQL-Server instances. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of SQL Server programs with SLA settings that did not meet SQL Server programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of SQL Server programs with SLA settings that are close to their SQL Server programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of SQL Server programs with SLA settings that did meet the SQL Server programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...
Table 9-7 SQL Server Activity Over Time fields
| Field | Description |
|---|---|
| Date and Time | Displays the date and timestamp of the data available in the selected time frame. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of SQL Server programs with SLA settings that did not meet SQL Server programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of SQL Server programs with SLA settings that are close to their SLAs SQL Server programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of SQL Server programs with SLA settings that did meet the SQL Server programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...
Table 9-8 SQL Server Top Programs fields
| Field | Description |
|---|---|
| Program | Displays the top SQL Server program or programs. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of SQL Server programs with SLA settings that did not meet SQL Server programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of SQL Server programs with SLA settings that are close to their SQL Server programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of SQL Server programs with SLA settings, that did meet the SQL Server programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...
Table 9-9 SQL Server Top Statements fields
| Field | Description |
|---|---|
| Statement | The hash values of top SQL statements running in the SQL server instance. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of SQL Server programs with SLA settings that did not meet SQL Server programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of SQL Server programs with SLA settings that are close to their SQL Server programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of SQL Server programs with SLA settings that did meet the SQL Server programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...
Table 9-10 Sybase Activity by Database fields
| Field | Description |
|---|---|
| Database | The names of the Sybase databases within Sybase instances. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of SQL Server programs with SLA settings that did not meet SQL Server programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of SQL Server programs with SLA settings that are close to their SQL Server programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of SQL Server programs with SLA settings that did meet the SQL Server programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...
Table 9-11 Sybase Top Statements fields
| Field | Description |
|---|---|
| Statement | The hash values of top statements running in the Sybase instance. |
| Response Times (Summed) | Displays the elapsed time from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Times (Summed) | Displays the sum of the processing time spent in the local database. |
| Remote DB Times (Summed) | Displays the time the SQL statement waited for a response from the remote database. |
| Response Time (Avg) | Displays the average time that elapsed from when a request is received by the server to the time a response is sent back to the computer that made the request. The response time is measured on the server-side. |
| Work Time (Avg) | Displays the average processing time spent in the local database. |
| Remote DB Time (Avg) | Displays the average time the SQL statement waited for a response from the remote database. |
| Executions | Displays the number of times an SQL statement was executed. |
| SLA Breach | Displays the percentage of SQL Server programs with SLA settings that did not meet SQL Server programs' SLAs (as defined by the breach thresholds settings). |
| SLA Near-Breach | Displays the percentage of SQL Server programs with SLA settings that are close to their SQL Server programs' SLAs (as defined by the near-breach thresholds settings). |
| SLA OK | Displays the percentage of SQL Server programs with SLA settings that did meet the SQL Server programs' SLA. |
See “About the Tools portlets” on page 30, “Configuring the portlet” on page 33, and “Defining the portlet data preferences” on page 34.
...