中烟

1. 需要出具季度巡检报告。
2. 等5月份的巡检结束之后付款。

时间慢半小时

表空间调整策略

SGA值太小

ZYBPRD2

TABLESPACE_NAME                MEGS_ALLOC  MEGS_USED   PCT_FREE MSG
------------------------------ ---------- ---------- ---------- ---------------------------
PSAPSR3                            990000  988972.56         .1 Critical (<5% free)

mkdir /oracle/BIP/sapdata2/sr3_101/
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/BIP/sapdata2/sr3_101/sr101.data101' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 10G; 
mkdir /oracle/BIP/sapdata2/sr3_102/
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/BIP/sapdata2/sr3_102/sr102.data102' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 10G; 
mkdir /oracle/BIP/sapdata2/sr3_103/
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/BIP/sapdata2/sr3_103/sr103.data103' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 10G; 

ZYCPRD2

TABLESPACE_NAME                MEGS_ALLOC  MEGS_USED   PCT_FREE MSG
------------------------------ ---------- ---------- ---------- ---------------------------
PSAPCRM                             28960      28940        .07 Critical (<5% free)
PSAPCRM701                          22880      21562       5.76 Warning (<15% free)
PSAPCRMDB                            5220    5211.13        .17 Critical (<5% free)

# For PSAPCRM
mkdir  /oracle/CRP/sapdata4/crm_10
mkdir  /oracle/CRP/sapdata4/crm_11
sqlplus / as sysdba
ALTER TABLESPACE PSAPCRM ADD DATAFILE '/oracle/CRP/sapdata4/crm_10/crm.data10' SIZE 2G AUTOEXTEND ON NEXT 20M MAXSIZE 5G; 
ALTER TABLESPACE PSAPCRM ADD DATAFILE '/oracle/CRP/sapdata4/crm_11/crm.data11' SIZE 2G AUTOEXTEND ON NEXT 20M MAXSIZE 5G; 
/

# For PSAPCRMDB
mkdir /oracle/CRP/sapdata4/crmdb_4
mkdir /oracle/CRP/sapdata4/crmdb_5
sqlplus / as sysdba
ALTER TABLESPACE PSAPCRMDB ADD DATAFILE '/oracle/CRP/sapdata4/crmdb_4/crmdb.data4' SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 2G; 
ALTER TABLESPACE PSAPCRMDB ADD DATAFILE '/oracle/CRP/sapdata4/crmdb_5/crmdb.data5' SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 2G; 
/

# For PSAPCRM701
mkdir /oracle/CRP/sapdata4/crm701_9/
mkdir /oracle/CRP/sapdata4/crm701_10/
sqlplus / as sysdba
ALTER TABLESPACE PSAPCRM701 ADD DATAFILE '/oracle/CRP/sapdata4/crm701_9/crm701.dat' SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 3G; 
ALTER TABLESPACE PSAPCRM701 ADD DATAFILE '/oracle/CRP/sapdata4/crm701_10/crm701.dat' SIZE 500M AUTOEXTEND ON NEXT 20M MAXSIZE 3G;