欧美视频在线第一页_午夜影视日本亚洲欧洲精品_成人性生交xxxxx网站_国产精品99久久久久久有的能看 _精品国产一二三四区_国产精品久久久久久久久果冻传媒_国产夫妻自拍一区_蜜桃久久精品一区二区_欧美极品欧美精品欧美视频_日本丰满少妇xxxx_欧美精品一区二区蜜桃_99视频精品在线

始創于2000年 股票代碼:831685
咨詢熱線:0371-60135900 注冊有禮 登錄
  • 掛牌上市企業
  • 60秒人工響應
  • 99.99%連通率
  • 7*24h人工
  • 故障100倍補償
您的位置: 網站首頁 > 幫助中心>文章內容

Oracle tablespace 監控項目版

發布時間:  2012/8/29 17:49:29

主要實現功能:

1、監控表空間,通用版

2、采用PHP進行格式化輸入輸出,并下發監控郵件報表

3、自動維護、優化涉及到的文件及表

4、對特殊格式輸入進行demo說明

目前該版本已有升級加強版,對于目前提供的腳本足夠大家使用,謝謝指正!

#--SETUP.sql
[Oracle@clement datafile_monitor]$ more SETUP.sql
-
 

/*DESCRIBE
  VI SETUP.sql
  REM INITIALIZATION FILE TO INSTALL THE MONITORING
  AUTHOR : Clement Ge
  MAIL: Clement.gejun@gmail.com
 */


SET TIMING ON;
SET SERVEROUTPUT ON; 
TRUNCATE TABLE DATAFILES_GE_MONITORING;
DROP TABLE DATAFILES_GE_MONITORING;
/* Create table*/
create table DATAFILES_GE_MONITORING
(
  TABLESPACE_NAME    VARCHAR2(50) not null,
  FILE_NAME          VARCHAR2(200) not null,
  IGBYTES            NUMBER(16,6) not null,
  CURRENTDAYGBYTES   NUMBER(16,6) default 0 not null,
  LASTDAYSGBYTES     NUMBER(16,6) default 0 not null,
  CURRENTWEEKGBYTES  NUMBER(16,6) default 0 not null,
  LASTWEEKSGBYTES    NUMBER(16,6) default 0 not null,
  CURRENTMONTHGBYTES NUMBER(16,6) default 0 not null,
  LASTMONTHSGBYTES   NUMBER(16,6) default 0 not null,
  ALIVEVALUE         VARCHAR2(40) default (to_char(SYSDATE,'YYYY-MM-DD') || ',,5') not null,
  STATUS             CHAR(1) default 0 not null
)
/* The current default specified tablespace or whatever*/
--tablespace USERS
  pctfree 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 1M
    next 1M
    minextents 1
    maxextents unlimited
  );


/* Create/Recreate primary, unique and foreign key constraints */
ALTER TABLE DATAFILES_GE_MONITORING
  ADD CONSTRAINT UNK_DATAFILES_GE_MONITORING PRIMARY KEY (TABLESPACE_NAME, FILE_NAME)
  USING INDEX;
/* KEEP TABLE*/
ALTER TABLE DATAFILES_GE_MONITORING STORAGE (BUFFER_POOL KEEP);
/* Initialization value is not less than 1G, and to be calculated in units of G*/
INSERT INTO DATAFILES_GE_MONITORING
      SELECT T.TABLESPACE_NAME TABLESPACE_NAME,
             T.FILE_NAME FILE_NAME,
             T.BYTES / 1024 / 1024 / 1024 IGBYTES,
             0 CURRENTDAYGBYTES,
             0 LASTDAYSGBYTES,
             0 CURRENTWEEKGBYTES,
             0 LASTWEEKSGBYTES,
             0 CURRENTMONTHGBYTES,
             0 LASTMONTHSGBYTES,
             (TO_CHAR(SYSDATE,'YYYY-MM-DD') || ',,5') ALIVEVALUE,
             (CASE WHEN T.BYTES / 1024 / 1024 / 1024 > 31 THEN 6 ELSE 0 END) STATUS
        FROM DBA_DATA_FILES T
       WHERE EXISTS (SELECT 1
                FROM DBA_DATA_FILES X
               WHERE T.TABLESPACE_NAME = X.TABLESPACE_NAME
                 AND X.BYTES / 1024 / 1024 / 1024 >= 0)
       ORDER BY T.TABLESPACE_NAME ASC,T.BYTES DESC;
SHOW ERRORS;      
COMMIT;


#--DATAFILES_GE_MONITORING.sh
[Oracle@clement datafile_monitor]$ more DATAFILES_GE_MONITORING.sh
#!/bin/sh
source /home/Oracle/.bash_profile
#select userenv('language') from dual
#export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
today=`date +%Y_%m_%d -d "$(echo -1) day"`
dirs=`pwd`
cd $dirs
find $dirs -name '*_*_MonitoringDatafileSpace.html' -type f -mtime +7 |xargs rm -rf
sed -e "/html/c\\spool "$dirs/$today"_MonitoringDatafileSpace.html" DATAFILES_GE_MONITORING.sql > TEMP_DATAFILES_GE_MONITORING.sql
mv TEMP_DATAFILES_GE_MONITORING.sql DATAFILES_GE_MONITORING.sql
#sqlplus scott\/\"scott\@\#\$331804\"\@ucc<<!
sqlplus 'scott/tiger'<<!
@DATAFILES_GE_MONITORING.sql
exit
!


#-- sendDataFileSpaceMonitoring.php
[Oracle@clement datafile_monitor]$ more sendDataFileSpaceMonitoring.php
#!/usr/bin/php   -q
<?
$email="clement.ge@finalist.hk";
$currenthour=date("H");
$pathnames=dirname(__FILE__)."/".date('Y_m_d',mktime($currenthour-24))."_MonitoringDatafileSpace.html";
$file=fopen("$pathnames","r");
echo $file;
send_email_tj($email,$file);
function send_email_tj($email,$file){
$header= "Content-type:text/html;charset=gb2312\r\n ";
$header .='From:<clement.ge@finalist.hk>' ."\r\n ";
$from= "clement.ge@finalist.hk";
$subject= "日常數據庫數據文件監控列表(統計監控截至時間是當前執行時間)";
$message=" <html><body> ";
$message .= " <br> <br><h1><center>日常數據庫監控維護列表<center></h1> <br> <br> ";
$message .=$file;
while (!feof($file))
  {
  $message .=fgetc($file);
  }
fclose($file);
$message .= "<br></body></html> ";
mail($email,$subject,$message,$header) or die( "Sorry,Failure ");
}
?>


#--DATAFILES_GE_MONITORING.sql
[Oracle@clement datafile_monitor]$ more DATAFILES_GE_MONITORING.sh
#!/bin/sh
source /home/Oracle/.bash_profile
#select userenv('language') from dual
#export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
today=`date +%Y_%m_%d -d "$(echo -1) day"`
dirs=`pwd`
cd $dirs
find $dirs -name '(*_*_)每日數據維護工作一.html' -type f -mtime +7 |xargs rm -rf
sed -e "/txt/c\\spool "$dirs/$today"_每日數據維護工作一.txt" DATAFILES_GE_MONITORING.sql > TEMP_DATAFILES_GE_MONITORING.sql
mv TEMP_DATAFILES_GE_MONITORING.sql DATAFILES_GE_MONITORING.sql
#sqlplus scott\/\"scott\@\#\$331804\"\@ucc<<!
sqlplus 'scott/tiger'<<!
--SET LINESIZE 1000
--SET TERM OFF VERIFY OFF FEEDBACK OFF PAGESIZE 999
--SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
@DATAFILES_GE_MONITORING.sql
exit
!


--DATAFILES_GE_MONITORING.sql
[Oracle@clement datafile_monitor]$ more DATAFILES_GE_MONITORING.sql
/*  DESCRIBE
  vi DATAFILES_GE_MONITORING.sql
  REM Monitoring analyze
  REM Deployment CRON use Oracle user
  AUTHOR : Clement Ge*/
 /* Insert into datas */
MERGE INTO DATAFILES_GE_MONITORING S
USING (SELECT /*+ NO_CPU_COSTING */ T.TABLESPACE_NAME TABLESPACE_NAME,
             T.FILE_NAME FILE_NAME,
             T.BYTES / 1024 / 1024 / 1024 IGBYTES
        FROM DBA_DATA_FILES T
       WHERE EXISTS (SELECT 1
                FROM DBA_DATA_FILES W
               WHERE T.TABLESPACE_NAME = W.TABLESPACE_NAME
                 AND W.BYTES / 1024 / 1024 / 1024 BETWEEN 1 AND 32)
       ORDER BY T.TABLESPACE_NAME ASC,T.BYTES DESC) X
ON (S.TABLESPACE_NAME = X.TABLESPACE_NAME
    AND S.FILE_NAME = X.FILE_NAME)
WHEN MATCHED THEN
  UPDATE SET S.IGBYTES = X.IGBYTES,
             S.CURRENTDAYGBYTES = X.IGBYTES - S.IGBYTES,
             S.LASTDAYSGBYTES = S.CURRENTDAYGBYTES,
             S.CURRENTWEEKGBYTES = DECODE(TO_CHAR(SYSDATE-1,'DD'),'00',S.LASTDAYSGBYTES,S.CURRENTWEEKGBYTES + S.LASTDAYSGBYTES),
             S.LASTWEEKSGBYTES = DECODE(TO_CHAR(SYSDATE-1,'DD'),'00',S.CURRENTWEEKGBYTES,S.LASTWEEKSGBYTES),
             S.CURRENTMONTHGBYTES = DECODE(TO_CHAR(SYSDATE-1,'DD'),'01',
               S.LASTDAYSGBYTES,S.CURRENTMONTHGBYTES + S.CURRENTWEEKGBYTES),
             S.LASTMONTHSGBYTES = DECODE(TO_CHAR(SYSDATE-1,'DD'),'01',S.CURRENTMONTHGBYTES,S.LASTMONTHSGBYTES),
             S.ALIVEVALUE = (CASE WHEN REPLACE(SUBSTR(S.CURRENTDAYGBYTES,1,7),'-','') > 0 THEN
                                       TO_CHAR(SYSDATE,'YYYY-MM-DD') || ',,' || SUBSTR(S.ALIVEVALUE,INSTR(S.ALIVEVALUE,',',1,2)+1)
                                  ELSE
                                    (CASE WHEN NVL(SUBSTR(S.ALIVEVALUE,INSTR(S.ALIVEVALUE,',',1)+1,
                                       INSTR(S.ALIVEVALUE,',',1,2)-INSTR(S.ALIVEVALUE,',',1)-1),0)
                                               BETWEEN 0 AND SUBSTR(S.ALIVEVALUE,INSTR(S.ALIVEVALUE,',',1,2)+1) - 1 THEN
                                                 SUBSTR(S.ALIVEVALUE,1,INSTR(S.ALIVEVALUE,',',1)) ||
                                                 (NVL(SUBSTR(S.ALIVEVALUE,INSTR(S.ALIVEVALUE,',',1)+1,
                                                  INSTR(S.ALIVEVALUE,',',1,2)-INSTR(S.ALIVEVALUE,',',1)-1),0) + 1)||
                                                 SUBSTR(S.ALIVEVALUE,INSTR(S.ALIVEVALUE,',',1,2))
                                           ELSE
                                               S.ALIVEVALUE
                                       END)
                                  END)          
   WHERE S.STATUS < '9'
WHEN NOT MATCHED THEN
  INSERT (S.TABLESPACE_NAME,S.FILE_NAME,S.IGBYTES,S.CURRENTDAYGBYTES,S.LASTDAYSGBYTES,S.CURRENTWEEKGBYTES,S.LASTWEEKSGBYTES,
          S.CURRENTMONTHGBYTES,S.LASTMONTHSGBYTES,S.ALIVEVALUE,S.STATUS)
  VALUES (X.TABLESPACE_NAME,X.FILE_NAME,X.IGBYTES,0,0,0,0,0,0,(SYSDATE || ',,5'),
          (CASE WHEN X.IGBYTES / 1024 / 1024 / 1024 > 31 THEN 2 ELSE 0 END));
/* Update Status*/
UPDATE DATAFILES_GE_MONITORING UNM
   SET UNM.STATUS = (CASE
                         WHEN UNM.IGBYTES < 26 AND NOT EXISTS (SELECT '1'
                                   FROM DATAFILES_GE_MONITORING UNM1
                                   WHERE UNM1.TABLESPACE_NAME = UNM.TABLESPACE_NAME having count(*) > 1 ) THEN
                              (CASE WHEN (NVL(SUBSTR(UNM.ALIVEVALUE,INSTR(UNM.ALIVEVALUE,',',1)+1,
                                                     INSTR(UNM.ALIVEVALUE,',',1,2)-INSTR(UNM.ALIVEVALUE,',',1)-1),0) >=
                                          SUBSTR(UNM.ALIVEVALUE,INSTR(UNM.ALIVEVALUE,',',1,2)+1) - 1)
                                             AND (UNM.STATUS = '0' OR UNM.STATUS = '1') THEN
                                         '1' 
                                    ELSE
                                        '0'
                               END)
                         WHEN (SELECT COUNT(UNM1.FILE_NAME) * 31.998 - SUM(UNM1.IGBYTES)
                               FROM DATAFILES_GE_MONITORING UNM1 WHERE UNM1.TABLESPACE_NAME = UNM.TABLESPACE_NAME) > 6 AND
                               EXISTS (SELECT '1' FROM DATAFILES_GE_MONITORING UNM1
                               WHERE UNM1.TABLESPACE_NAME = UNM.TABLESPACE_NAME having count(*) > 1 ) THEN
                              (CASE WHEN (SELECT NVL(MIN(NVL(SUBSTR(UNM1.ALIVEVALUE,INSTR(UNM1.ALIVEVALUE,',',1)+1,
                                                     INSTR(UNM1.ALIVEVALUE,',',1,2)-INSTR(UNM1.ALIVEVALUE,',',1)-1),0)),0)
                                          FROM DATAFILES_GE_MONITORING UNM1
                                          WHERE UNM1.TABLESPACE_NAME = UNM.TABLESPACE_NAME
                                            AND UNM1.STATUS NOT IN ('2','4')) >=
                                          SUBSTR(UNM.ALIVEVALUE,INSTR(UNM.ALIVEVALUE,',',1,2)+1) - 1   THEN
                                          '1'
                                    WHEN NVL(SUBSTR(UNM.ALIVEVALUE,INSTR(UNM.ALIVEVALUE,',',1)+1,
                                                     INSTR(UNM.ALIVEVALUE,',',1,2)-INSTR(UNM.ALIVEVALUE,',',1)-1),0) >=
                                         SUBSTR(UNM.ALIVEVALUE,INSTR(UNM.ALIVEVALUE,',',1,2)+1) - 1 THEN
                                         '3'
                                    ELSE
                                         '0'
                               END)
                         WHEN (SELECT COUNT(UNM1.FILE_NAME) * 31.998 - SUM(UNM1.IGBYTES) FROM
                               DATAFILES_GE_MONITORING UNM1
                               WHERE UNM1.TABLESPACE_NAME = UNM.TABLESPACE_NAME) BETWEEN 3 AND 6 THEN '5'
                         WHEN (SELECT COUNT(UNM1.FILE_NAME) * 31.998 - SUM(UNM1.IGBYTES)
                               FROM DATAFILES_GE_MONITORING UNM1
                               WHERE UNM1.TABLESPACE_NAME = UNM.TABLESPACE_NAME) BETWEEN 0 AND 2 THEN '6'
                       ELSE UNM.STATUS
                      END)
WHERE UNM.STATUS < '9';
COMMIT;
SET LINESIZE 2000;
SET TERM OFF VERIFY OFF FEEDBACK OFF PAGESIZE 2000;
SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF;
spool /wins/test/datafile_monitor/2011_05_13_每日數據維護工作一.html;

SELECT ALARM.TABLESPACE_NAME "需處理的表空間名稱",
       DENSE_RANK() OVER(PARTITION BY ALARM.STATUS,ALARM.TABLESPACE_NAME ORDER BY ALARM.STATUS DESC,
       NVL(SUBSTR(ALARM.ALIVEVALUE,INSTR(ALARM.ALIVEVALUE,',',1)+1,
                  INSTR(ALARM.ALIVEVALUE,',',1,2)-INSTR(ALARM.ALIVEVALUE,',',1)-1),0) ASC,
                  ALARM.IGBYTES DESC) "處理優先級",
       (CASE WHEN ALARM.STATUS = '6' THEN
                  (CASE WHEN (SELECT COUNT(UNM1.FILE_NAME) * 31.998 - SUM(UNM1.IGBYTES)
                              FROM DATAFILES_GE_MONITORING UNM1
                              WHERE UNM1.TABLESPACE_NAME = ALARM.TABLESPACE_NAME) > 0 THEN                  
                           (CASE WHEN NVL(SUBSTR(ALARM.ALIVEVALUE,INSTR(ALARM.ALIVEVALUE,',',1)+1,
                                          INSTR(ALARM.ALIVEVALUE,',',1,2)-INSTR(ALARM.ALIVEVALUE,',',1)-1),0) > 0 THEN
                                      '報警!需立即處理,否則影響數據正常入庫,目前已'|| SUBSTR(ALARM.ALIVEVALUE,
                                         INSTR(ALARM.ALIVEVALUE,',',1)+1,
                                              INSTR(ALARM.ALIVEVALUE,',',1,2)-INSTR(ALARM.ALIVEVALUE,',',1)-1) ||'天未增長!'
                                ELSE
                                      '報警。≌埩⒓刺幚恚。!'
                           END)
                       ELSE '報警。!請立即處理,該空間達到或超過最大文件自動擴展空間界限,將要影響該空間所有數據正常運行!'
                    END)
       --警告提示級別統計
             ELSE
                  (CASE WHEN (SELECT COUNT(UNM1.FILE_NAME) * 31.998 - SUM(UNM1.IGBYTES)
                              FROM DATAFILES_GE_MONITORING UNM1
                              WHERE UNM1.TABLESPACE_NAME = ALARM.TABLESPACE_NAME) > 3 THEN
                            (CASE WHEN NVL(SUBSTR(ALARM.ALIVEVALUE,INSTR(ALARM.ALIVEVALUE,',',1)+1,
                                       INSTR(ALARM.ALIVEVALUE,',',1,2)-INSTR(ALARM.ALIVEVALUE,',',1)-1),0) > 0 THEN
                                       '警告 !需按照業務增長量確定是否立刻調整,目前已'|| SUBSTR(ALARM.ALIVEVALUE,
                                        INSTR(ALARM.ALIVEVALUE,',',1)+1,
                                       INSTR(ALARM.ALIVEVALUE,',',1,2)-INSTR(ALARM.ALIVEVALUE,',',1)-1) ||'天未增長!'
                                  ELSE
                                      '警告 !可能需要立即調整!'
                              END)
                        ELSE '警告。!該空間達到或超過警告最大文件空間界限,為了不影響數據的正常運行,請立即處理!'
                    END)
         END) "監控描述信息",
       ALARM.IGBYTES "數據文件大小(G)",
       ALARM.FILE_NAME "數據文件路徑"  
FROM DATAFILES_GE_MONITORING ALARM
WHERE ALARM.STATUS IN ('5','6');

UPDATE DATAFILES_GE_MONITORING UNM
   SET UNM.STATUS = (CASE WHEN (SELECT COUNT(UNM1.FILE_NAME) * 31.998 - SUM(UNM1.IGBYTES)
                                FROM DATAFILES_GE_MONITORING UNM1
                                WHERE UNM1.TABLESPACE_NAME = UNM.TABLESPACE_NAME) < 0 THEN
                                '4'
                          ELSE
                               UNM.STATUS
                     END)
WHERE UNM.STATUS IN ('5','6');
COMMIT;

WITH ESTIMATE_01 AS (SELECT DECODE(TX.STATUS,'0','監控','1','數據未增長','3','暫時空閑','4','暫停監控','5','警告','6','報警') DS,
                           TX.TABLESPACE_NAME TB,
                           TX.IGBYTES IG,
                           --SUM(TX.IGBYTES) OVER (ORDER BY TX.FILE_NAME) "表空間累計監控值(G)",
                           TX.CURRENTDAYGBYTES CD,
                           TX.LASTDAYSGBYTES LD,
                           (CASE WHEN TX.LASTDAYSGBYTES = 0 THEN
                                      (CASE WHEN TX.CURRENTDAYGBYTES >= 0 THEN
                                                 'Up Rate : ' || ROUND(TX.CURRENTDAYGBYTES*100,4) || '%'
                                            ELSE
                                                 'Down Rate : ' || ROUND(TX.CURRENTDAYGBYTES*100,4) || '%'
                                       END)
                                  WHEN TX.CURRENTDAYGBYTES = 0 THEN
                                       (CASE WHEN TX.LASTDAYSGBYTES > 0 THEN
                                                 'Down Rate : ' || ROUND(TX.LASTDAYSGBYTES*100,4) || '%'
                                            ELSE
                                                 'Up Rate : ' || ROUND(TX.LASTDAYSGBYTES*100,4) || '%'
                                       END)
                                  ELSE
                                      (CASE WHEN TX.CURRENTDAYGBYTES > 0 THEN
                                                 'Up Rate : ' || ROUND(TX.CURRENTDAYGBYTES/TX.LASTDAYSGBYTES*100,4) || '%'
                                            ELSE
                                                 'Down Rate : ' || ROUND(TX.CURRENTDAYGBYTES/TX.LASTDAYSGBYTES*100,4) || '%'
                                        END)
                             END) CLD,
                           TX.CURRENTWEEKGBYTES CW,
                           TX.LASTWEEKSGBYTES LW,
                           (CASE WHEN TX.LASTWEEKSGBYTES = 0 THEN
                                      (CASE WHEN TX.CURRENTWEEKGBYTES >= 0 THEN
                                                 'Up Rate : ' || ROUND(TX.CURRENTWEEKGBYTES*100,4) || '%'
                                            ELSE
                                                 'Down Rate : ' || ROUND(TX.CURRENTWEEKGBYTES*100,4) || '%'
                                       END)
                                  WHEN TX.CURRENTWEEKGBYTES = 0 THEN
                                       (CASE WHEN TX.LASTWEEKSGBYTES > 0 THEN
                                                 'Down Rate : ' || ROUND(TX.LASTWEEKSGBYTES*100,4) || '%'
                                            ELSE
                                                 'Up Rate : ' || ROUND(TX.LASTWEEKSGBYTES*100,4) || '%'
                                       END)
                                  ELSE
                                      (CASE WHEN TX.CURRENTWEEKGBYTES > 0 THEN
                                                 'Up Rate : ' || ROUND(TX.CURRENTWEEKGBYTES/TX.LASTWEEKSGBYTES*100,4) || '%'
                                            ELSE
                                                 'Down Rate : ' || ROUND(TX.CURRENTWEEKGBYTES/TX.LASTWEEKSGBYTES*100,4) || '%'
                                        END)
                             END) CLW,
                           TX.CURRENTMONTHGBYTES  CM,
                           TX.LASTMONTHSGBYTES LM,
                           (CASE WHEN TX.LASTMONTHSGBYTES = 0 THEN
                                      (CASE WHEN TX.CURRENTMONTHGBYTES >= 0 THEN
                                                 'Up Rate : ' || ROUND(TX.CURRENTMONTHGBYTES*100,4) || '%'
                                            ELSE
                                                 'Down Rate : ' || ROUND(TX.CURRENTMONTHGBYTES*100,4) || '%'
                                       END)
                                  WHEN TX.CURRENTMONTHGBYTES = 0 THEN
                                       (CASE WHEN TX.LASTMONTHSGBYTES > 0 THEN
                                                 'Down Rate : ' || ROUND(TX.LASTMONTHSGBYTES*100,4) || '%'
                                            ELSE
                                                 'Up Rate : ' || ROUND(TX.LASTMONTHSGBYTES*100,4) || '%'
                                       END)
                                  ELSE
                                      (CASE WHEN TX.CURRENTMONTHGBYTES > 0 THEN
                                                 'Up Rate : ' || ROUND(TX.CURRENTMONTHGBYTES/TX.LASTMONTHSGBYTES*100,4) || '%'
                                            ELSE
                                                 'Down Rate : ' || ROUND(TX.CURRENTMONTHGBYTES/TX.LASTMONTHSGBYTES*100,4) || '%'
                                        END)
                             END) CLM
                      FROM DATAFILES_GE_MONITORING TX
                      WHERE TX.STATUS < '9'
                      ORDER BY TX.STATUS DESC,TX.IGBYTES DESC)
select DS "文件狀態",TB "表空間名稱",IG || '' "當前數據文件大小(G)",
       CD || '' "當天數據量(G)",LD || '' "昨天數據量(G)",
       CLD "前/后兩天比率",
       CW || '' "本周累計總值(G)",LW || '' "上周總值(G)",
       CLW "前/后兩周比率",
       CM || '' "當月累計總值(G)",LM || '' "上月總值(G)",
       CLM "前/后兩月比率"
from ESTIMATE_01
UNION ALL
SELECT '統計匯總 ','監控總計:' || ESTIMATE_02.SUMS,'當前監控總計:' || SUM(ESTIMATE_01.IG),
       '當天增值總計:' || SUM(ESTIMATE_01.CD),'昨天增值總計:' || SUM(ESTIMATE_01.LD),
       '停止監控總計:' || ESTIMATE_02.UNM,
       '本周累計總計:' || SUM(ESTIMATE_01.CW),'上周增值總計:' || SUM(ESTIMATE_01.LW),
       '空間總計:' || ESTIMATE_03.UNCM,
       '本月累計總計:' || SUM(ESTIMATE_01.CM),'上月增值總計:' || SUM(ESTIMATE_01.LM),
       '未加入監控總計:' || TRUNC((ESTIMATE_03.UNCM - ESTIMATE_02.SUMS),6)
FROM ESTIMATE_01,
     (SELECT SUM(TT.IGBYTES)|| '' SUMS,TRUNC(SUM(DECODE(TT.STATUS,'9',TT.IGBYTES,0)),6)|| '' UNM
      FROM DATAFILES_GE_MONITORING TT) ESTIMATE_02,
     (SELECT TRUNC(SUM(BYTES)/ 1024 / 1024 / 1024,6) || '' UNCM FROM DBA_DATA_FILES) ESTIMATE_03
GROUP BY ESTIMATE_02.SUMS,ESTIMATE_02.UNM,ESTIMATE_03.UNCM;
SPOOL OFF;
ANALYZE TABLE DATAFILES_GE_MONITORING COMPUTE STATISTICS;


本文出自:億恩科技【www.beingsafe.com.cn】

服務器租用/服務器托管中國五強!虛擬主機域名注冊頂級提供商!15年品質保障!--億恩科技[ENKJ.COM]

  • 您可能在找
  • 億恩北京公司:
  • 經營性ICP/ISP證:京B2-20150015
  • 億恩鄭州公司:
  • 經營性ICP/ISP/IDC證:豫B1.B2-20060070
  • 億恩南昌公司:
  • 經營性ICP/ISP證:贛B2-20080012
  • 服務器/云主機 24小時售后服務電話:0371-60135900
  • 虛擬主機/智能建站 24小時售后服務電話:0371-60135900
  • 專注服務器托管17年
    掃掃關注-微信公眾號
    0371-60135900
    Copyright© 1999-2019 ENKJ All Rights Reserved 億恩科技 版權所有  地址:鄭州市高新區翠竹街1號總部企業基地億恩大廈  法律顧問:河南亞太人律師事務所郝建鋒、杜慧月律師   京公網安備41019702002023號
      0
     
     
     
     

    0371-60135900
    7*24小時客服服務熱線

     
     
    亚洲在线视频网站| 成人亲热视频网站| 97久久精品人人做人人爽50路| 日本sm残虐另类| 中日精品一色哟哟| 毛茸茸free性熟hd| 中文字幕第六页| 日韩女同强女同hd| 亚洲爆乳无码一区二区三区| av成人免费在线观看| 亚洲夂夂婷婷色拍ww47| 亚洲精品videosex极品| 久久免费电影网| 久久精品99国产精品日本| 欧美一区二不卡视频| 精品97人妻无码中文永久在线| 91在线观看免费观看| 欧美视频一区在线观看| 日韩在线观看一区二区| 欧美bbbbb| 亚州男人的天堂| 91亚洲国产成人久久精品麻豆| 三级网站在线播放 | 国产精品久久精品| 欧美在线一区二区三区四区| 一区二区三区在线视频111| 国产精品视频最多的网站| 久久影院资源网| 久久国产精品久久国产精品| 日本精品一级二级| 亚洲黄色片视频| 男男受被啪到高潮自述| 日韩电影免费观看高清完整| 男女啪啪免费观看| 日本一本草久p| 日韩电影免费观看高清完整| 91香蕉视频网址| 性农村xxxxx小树林| 免费一级片91| 精品欧美一区二区三区精品久久| 成人国产在线视频| jizzzz日本| 久久久久亚洲av无码专区首jn| 国模私拍视频在线观看| 精品1卡二卡三卡四卡老狼| 欧美熟妇激情一区二区三区| 九九九视频在线观看| 日本泡妞xxxx免费视频软件| 国产亚洲精品成人| 蜜桃久久精品一区二区| 亚洲资源在线播放| 国产一区二区在线视频| 一区二区三区久久| 日韩精品色哟哟| 一区二区三区日韩欧美精品| 91精品在线免费| 日韩中文字幕免费| 91精品中国老女人| 成人福利网站在线观看11| 国产精品久久久久久久小唯西川| 国产美女在线精品免费观看| 成人黄色片在线| 91高清免费在线观看| 91看片淫黄大片91| 免费无码毛片一区二区app| 国产一二三区精品| 国产视频www| 福利视频网站一区二区三区| 蜜桃久久精品一区二区| 亚洲国产一区二区在线播放| 日韩欧美一级二级三级久久久| 欧美高清激情视频| 91在线看网站| 国产精品一区二区三区在线观 | 日韩免费三级| 亚洲自拍小视频| 色综合电影网| 乱老熟女一区二区三区| 熟妇高潮一区二区三区| 波多野结衣在线一区| 午夜精品久久久久久不卡8050| 午夜在线成人av| 欧美一区在线视频| 国产v综合ⅴ日韩v欧美大片| 国产激情在线免费观看| 国产精品久久久久aaaa| 成人精品aaaa网站| 黄色片网站免费| 9色porny自拍视频一区二区| 亚洲va韩国va欧美va精品| 欧美日韩一区不卡| 久久久人成影片一区二区三区| 精品国产乱码久久久久久蜜柚| 肉大捧一出免费观看网站在线播放| 少妇人妻无码专区视频| 性猛交ⅹxxx富婆video| 亚洲国产精品激情在线观看| 色哟哟一区二区在线观看| 欧美精品日韩三级| 日本午夜在线亚洲.国产| 欧美 日韩 国产 成人 在线观看| 国精产品一区一区三区mba桃花 | 欧美日韩电影一区二区三区| 一级网站在线观看| 免费人成精品欧美精品| 欧美精品久久久久久久| 一本在线免费视频| 国产偷国产偷亚洲高清人白洁| 日韩有码在线播放| 亚洲一区二区精品在线观看| 在线免费视频一区| 在线观看一二三区| 欧美激情一区二区三区在线| 欧美一卡2卡三卡4卡5免费| 欧美一区二区视频在线观看2022| 九色精品美女在线| 水蜜桃av无码| 久久久久免费观看| 国产精品久久精品日日| 亚洲精品v天堂中文字幕| 日韩伦理一区二区三区av在线| 亚洲一区二区三区sesese| 国产3级在线观看| 97se亚洲国产综合自在线不卡| 97成人超碰免| 久久这里只有精品18| 粉嫩绯色av一区二区在线观看| 国内精品久久久久影院优 | 欧美日韩一区二区三区免费看| 日韩中文理论片| 大肉大捧一进一出好爽视频| 日韩美女黄色片| 亚洲激情av在线| 色综合久久88色综合天天6| xxxx性欧美| 男人天堂成人在线| 国产99久久久国产精品免费看| 欧美一区二区不卡视频| 欧美最大成人综合网| 久久机热这里只有精品| 蜜桃视频在线一区| 亚洲一区二区精品久久av| 成人欧美一区二区三区视频 | 理论片中文字幕| 国产成人精品在线| 秋霞网一区二区| 毛片精品免费在线观看| 国产肥白大熟妇bbbb视频| 久久精品亚洲精品国产欧美| 在线观看不卡av| 精品无码国产一区二区三区av| 久久午夜鲁丝片| 91国产免费看| 亚洲欧洲自拍偷拍| 欧美午夜精品久久久久久蜜| 右手影院亚洲欧美| 欧美丰满嫩嫩电影| 国产成人无码精品久久久性色| 久久精品国产亚洲av无码娇色 | 91杏吧porn蝌蚪| 亚洲综合久久av| 91社在线播放| 裸体在线国模精品偷拍| 国产精品扒开腿做爽爽爽男男| 麻豆视频在线观看| 中文字幕在线一区| 国外视频精品毛片| 999精品免费视频| 丁香另类激情小说| 欧美一区二区三区小说| 91在线网站视频| 日本视频免费观看| 欧美国产亚洲精品久久久8v| 永久免费的av网站| 久久99精品一区二区三区| 精品国产欧美一区二区五十路| 成年人午夜免费视频| 无码人妻精品一区二区50| 精品国精品自拍自在线| 五月花丁香婷婷| 91视频一区二区三区| 97神马电影| 亚洲成人生活片| 久久亚区不卡日本| 国产在线精品一区免费香蕉| 欧美日韩精品亚洲精品| aa级大片欧美| 永久免费看mv网站入口亚洲| 国产天堂在线播放| 欧美日韩亚洲一区二区三区| 91高清国产视频| 国产91精品免费| 亚洲在线免费视频| 一区二区三区午夜| 亚洲欧美经典视频| 国产中文一区二区| 久久夜色精品| 91中文字幕一区| 免费在线观看一区二区三区| 婷婷精品国产一区二区三区日韩| 91在线观看污| 亚洲资源视频| 日韩精品乱码免费| 精品毛片三在线观看| 国产毛片久久久久久国产毛片| 丝袜亚洲精品中文字幕一区| 一区二区亚洲精品国产| 手机av在线免费| 色窝窝无码一区二区三区| 婷婷精品国产一区二区三区日韩| 亚洲人成精品久久久久| 久久久久成人精品免费播放动漫| 91精品中文字幕| 国产91精品久久久| 国产做受高潮漫动| 国产午夜精品美女毛片视频| 快播亚洲色图| 狠狠色狠狠色合久久伊人| 亚洲国产精品嫩草影院| 日韩欧美在线播放视频| 波多野结衣理论片| 日韩国产中文字幕| 国产性生活毛片| 亚洲欧美日韩综合aⅴ视频| 91精品国产一区二区三区动漫 | 日韩伦理一区二区三区av在线| 97精品久久久久中文字幕| 97久久夜色精品国产九色| 日韩综合小视频| 日本10禁啪啪无遮挡免费一区二区 | 动漫av在线免费观看| 日韩欧美一区视频| 午夜av中文字幕| 精品国产一区二区三区久久影院| 丁香六月激情综合| 日韩一区二区在线观看视频 | 精品视频在线观看一区| 青青草原综合久久大伊人精品优势| 国产日韩欧美在线| 成人在线一区二区三区| 日本免费在线观看视频| 日韩在线观看免费全| 国产精品福利在线观看网址| 在线国产视频一区| 日本黄色三级视频| 永久免费精品影视网站| 小早川怜子久久精品中文字幕| 欧美性生交大片免费| 相泽南亚洲一区二区在线播放| 久久天堂成人| 欧美激情亚洲综合一区| 欧美日韩中文视频| 在线不卡a资源高清| 亚洲AV无码久久精品国产一区| 一区二区三区在线视频观看58| 激情五月婷婷六月| 丁香五精品蜜臀久久久久99网站| 国产99视频精品免费视频36| 亚洲精品一级片| 国产精品综合网站| 日本韩国在线观看| 97超碰人人模人人爽人人看| 人妻妺妺窝人体色www聚色窝| 国产精品免费小视频| 在线观看中文字幕码| 68精品国产免费久久久久久婷婷| 国产成人精品777777| 欧美高清视频在线观看| 欧美一区二区三区不卡视频| 国产视频欧美视频| 天天操天天操天天操天天操天天操| 欧美色窝79yyyycom| 日韩福利在线视频| 亚洲天堂男人天堂| 欧美三日本三级少妇99| 日韩中文在线中文网三级| 日韩免费观看一区二区| 中国黄色a级片| 韩曰欧美视频免费观看| 少妇精品无码一区二区| 亚洲精品一区二区三区福利| 性高潮久久久久久久| 亚洲午夜小视频| 国产精品一区无码| 国产精品视频白浆免费视频| 日韩和欧美一区二区| 国产精品亚洲综合| 国产视频一区二区在线| 久久久久久久片| 91精品国产91久久久久久一区二区| 久草福利资源在线| 亚洲国产一区自拍| 无码人妻av一区二区三区波多野| 欧美丰满少妇xxxx| 亚洲精品国产av| 在线观看日韩羞羞视频| 亚洲电影一区二区三区| 在线 丝袜 欧美 日韩 制服| 久久精彩免费视频| 亚洲国产精品无码久久| 一区二区三区视频| 亚洲高清不卡在线观看| 亚洲综合图片一区| 久久久久久久久爱| 国产中文字幕一区| 在线免费观看视频黄| 欧美日韩黄视频| 日本黄色片一级片| 这里只有精品免费| 一区二区视频网站| 成人免费网站在线| 久久久午夜精品| 男人操女人下面视频| 精品国产一区二区三区久久狼黑人 | 国产精品普通话| 国产亚洲精品中文字幕| 三级黄色片网站| 国产成人97精品免费看片| 91在线观看下载| 成人午夜福利一区二区| 国产精品v日韩精品| 国产欧美日韩三区| 伊人成人222| 成人福利电影精品一区二区在线观看| 东京干手机福利视频| 国产一二三在线视频| 日韩电影免费观看中文字幕| 视频在线观看国产精品| www.久久91| 欧美在线精品免播放器视频| 99久久精品免费观看| 日韩免费av一区二区三区| 疯狂做受xxxx欧美肥白少妇| 欧美另类高清videos的特点| 日本三级中文字幕在线观看| 欧美日韩国产在线播放网站| 手机看片国产1024| 午夜久久福利视频| 欧美在线一区二区视频| 亚洲免费在线电影| 免费黄色小视频在线观看| 国产伦精品一区二区三区视频孕妇 | 99久久免费观看| 国产婷婷97碰碰久久人人蜜臀| 国产一区二区三区久久悠悠色av| 一二三级黄色片| 成人精品在线观看| 精品视频999| 韩国av电影在线观看| 精品无码av一区二区三区不卡| 亚洲伊人成综合成人网| 色妹子一区二区| 久久成人综合网| 免费黄在线观看| 亚洲自拍三区| 欧美成人激情视频| 成人动漫中文字幕| 午夜一级黄色片| 日韩小视频在线播放| 国产福利成人在线| 亚洲曰韩产成在线| 黄色av免费观看| 蜜臀aⅴ国产精品久久久国产老师| 96pao国产成视频永久免费| 欧美精品一区二区三| 26uuu亚洲| 国产熟妇一区二区三区四区| 亚洲精品手机在线观看| 97夜夜澡人人双人人人喊| 亚洲国产精品字幕| 成人天堂资源www在线| 国产精品500部| 日韩精品视频一区二区| 色99中文字幕| 91国内在线视频| 日韩三级中文字幕| 国产日韩av一区二区| 国产精品嫩草影院桃色| 亚洲一区二区三区日韩| 亚洲欧美电影在线观看| 欧美日本中文字幕| 日韩欧美在线影院| 亚洲精品自拍动漫在线| 久久av资源站| 伊人亚洲综合网| 成人黄色免费网址| 婷婷久久五月天| 国产suv精品一区二区| 日韩精品黄色网| 亚洲激情自拍偷拍| 大白屁股一区二区视频| 国产成人久久精品77777综合 | www亚洲欧美| 91精品国产麻豆| 夜夜嗨av一区二区三区网页| 国产剧情在线观看一区二区| 午夜精品久久久久久久91蜜桃| 免费成人深夜夜行p站| 久久久久久免费看| 台湾成人av| 国产噜噜噜噜久久久久久久久| 欧美xxxx18国产| 亚洲欧美国产高清va在线播| 精品视频1区2区| 国产精品久久久久久久久动漫| 西西人体44www大胆无码| 一级二级三级视频| 欧美精品韩国精品| 亚洲一区 欧美| 无码少妇精品一区二区免费动态|