/**
* 物理读
*
* @param dbId
* @param beginTime
* @param endTime
* @param sqlId
* @param request
* @param response
* @return
*/
@RequestMapping(
value = "/data/diskread/{dbId}/{beginTime}/{endTime}/{sqlId}",
method = RequestMethod.GET)
public @ResponseBody MultipleGeneralReportDataBO diskRead(
@PathVariable("dbId") String dbId,
@PathVariable("beginTime") String beginTime,
@PathVariable("endTime") String endTime,
@PathVariable("sqlId") String sqlId,
HttpServletRequest request,
HttpServletResponse response) {
DbConfigDomain dbConfigDomain = dbConfigDAO.getDataBaseConfig(dbId);
MultipleGeneralReportDataBO dto =
oracleHisSQLStatManager.listSQLStatReportData(
beginTime,
endTime,
new String[] {
SQLStatTypeEnum.disk_reads_total.getKey(), SQLStatTypeEnum.disk_reads_seconds.getKey()
},
dbConfigDomain.getOraDataBaseId(),
dbConfigDomain.getOraInstanceId(),
sqlId);
dto.setReportName(
String.format("%s[%s],物理读", dbConfigDomain.getDbName(), dbConfigDomain.getIpAddr()));
return dto;
}
@RequestMapping(value = "/sqlstatlistview", method = RequestMethod.GET)
public ModelAndView sqlStatListView(HttpServletRequest request, HttpServletResponse response) {
ModelAndView model = new ModelAndView();
String dbId = request.getParameter("oracle_monitors");
String sqlId = request.getParameter("sqlId");
String timeParam = request.getParameter("times");
if (StringUtils.isBlank(timeParam)) {
timeParam = "0";
}
if (StringUtils.isBlank(dbId)) {
dbId = StringUtils.EMPTY;
}
if (StringUtils.isBlank(sqlId)) {
sqlId = StringUtils.EMPTY;
}
Integer times = Integer.valueOf(timeParam);
List<OracleDbaSqlStatListDomain> list =
oracleHisSQLStatManager.listOracleSqlStatBySqlId(sqlId, dbId, times);
model.addObject("dbId", dbId);
model.addObject("sqlId", sqlId);
model.addObject("times", times);
model.addObject("list", list);
model.setViewName(QUOTA_REPORT_LIST_VIEWS);
return model;
}