/** * 物理读 * * @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; }