cache_statistics Stored Procedures

Provide aggregations of cache activities over a date range for a mobile business object.

Procedure	Parameters	Result
`get_package_mbo_maxfullrefereshtime` `get_package_mbo_minfullrefereshtime`	@packagename varchar(128) mboname varchar (128) startdate datetime endate datetime	The minimum or maximum value of the duration for the mobile business object over the start date and end date range for a refresh activity.
`get_package_mbo_maxcachewaittime` `get_package_mbo_mincachewaittime`	packagename varchar(128) mboname varchar(128) startdate datetime endate datetime	The minimum or maximum value of the duration for the mobile business object over the start date and end date range for a cache activity.
`get_package_mbo_averageachewaittime` `get_package_mbo_averagefullrefereshtime`	packagename varchar(128) cachename varchar(128) startdate datetime endate datetime	The average value of the duration for the mobile business object over the start date and end date range for a cache or a refresh activity.
`get_package_mbo_access_count` `get_package_mbo_ondemandrefresh_count`	packagename varchar(128) cachename varchar(128) startdate datetime endate datetime	The count of access and on demand refresh activities for mobile businss object over the start date and end date range.