Page History
...
Table 9-3 Oracle Top Programs fields
Field Description
...
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
...
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
...
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
...
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 fieldsField Description
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
...
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
...
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
...
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
...
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.
...