Sybase 12.5.1, Руководство пользователя

Страница: 196 / 210

Procedure cache statistics for recording session
182
Historical Server
"Logical Page Reads", "Rate for Session"
Note The count of the page I/Os collected by this view for a given database
table includes I/Os against indexes on the table, in addition to those performed
against the data pages of the table itself.
Procedure cache statistics for recording session
This view represents the effectiveness of the procedure cache of the Adaptive
Server since the start of the recording session. It shows the percentage of
requests for stored procedure executions that were satisfied by the procedure
cache.
The view also shows the number of logical reads and physical reads of stored
procedures since the start of the session, and the overall rate of logical and
physical reads of stored procedures since the start of the session.
hs_create_view session_procedure_cache_stats,
"Procedure Hit Percent", "Value for Session",
"Procedure Logical Reads", "Value for Session",
"Procedure Logical Reads", "Rate for Session",
"Procedure Physical Reads", "Value forSession",
"Procedure Physical Reads", "Rate for Session"
Procedure cache statistics for sample interval
This view represents the effectiveness of the procedure cache of the Adaptive
Server for the most recent sample interval. It shows the percentage of requests
for stored procedure executions that were satisfied by the procedure cache for
the most recent sample interval.
The view also shows the number of logical reads and physical reads of stored
procedures during the most recent sample interval, and the rate of logical and
physical reads of stored procedures for the most recent sample interval.
hs_create_view sample_procedure_cache_stats,
"Procedure Hit Percent", "Value for Sample",
"Procedure Logical Reads", "Value for Sample",