中烟

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

时间慢半小时

表空间调整策略

SGA值太小

ZYEPRD2:172.16.33.131

mkdir /oracle/ECP/sapdata4/sr3_31
mkdir /oracle/ECP/sapdata4/sr3_32
mkdir /oracle/ECP/sapdata4/sr3_33
mkdir /oracle/ECP/sapdata4/sr3_34

ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/ECP/sapdata4/sr3_31/sr3.data31' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; 
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/ECP/sapdata4/sr3_32/sr3.data32' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; 
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/ECP/sapdata4/sr3_33/sr3.data33' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; 
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/ECP/sapdata4/sr3_34/sr3.data34' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; 

ZYBPRD2

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

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

# 20160518
mkdir /oracle/BIP/sapdata2/sr3_104/
mkdir /oracle/BIP/sapdata2/sr3_105/
mkdir /oracle/BIP/sapdata2/sr3_106/
mkdir /oracle/BIP/sapdata2/sr3_107/
mkdir /oracle/BIP/sapdata2/sr3_108/
mkdir /oracle/BIP/sapdata2/sr3_109/
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/BIP/sapdata2/sr3_104/sr104.data104' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G;
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/BIP/sapdata2/sr3_105/sr105.data105' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; 
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/BIP/sapdata2/sr3_106/sr106.data106' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; 
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/BIP/sapdata2/sr3_107/sr107.data107' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; 
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/BIP/sapdata2/sr3_108/sr108.data108' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; 
ALTER TABLESPACE PSAPSR3 ADD DATAFILE '/oracle/BIP/sapdata2/sr3_109/sr109.data109' SIZE 5G AUTOEXTEND ON NEXT 20M MAXSIZE 20G; 
/

ZYBPCPRD2

mkdir /oracle/BPP/sapdata3/sr3730_10
ALTER TABLESPACE PSAPSR3730 ADD DATAFILE '/oracle/BPP/sapdata3/sr3730_10/sr3730.dat' 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 1G AUTOEXTEND ON NEXT 20M MAXSIZE 3G;
ALTER TABLESPACE PSAPCRM701 ADD DATAFILE '/oracle/CRP/sapdata4/crm701_10/crm701.dat' SIZE 1G AUTOEXTEND ON NEXT 20M MAXSIZE 3G;

free/used space per tablespace

Tablespace                      Size (MB)  Free (MB)     % Free     % Used
------------------------------ ---------- ---------- ---------- ----------
PSAPCRMUSR                             20    19.5625         98          2
PSAPUNDO                             5620       5355         95          5
PSAPCRMDB                            6220    1008.75         16         84
PSAPCRM701                          24928   3365.875         14         86
PSAPCRM                             33356  4118.4375         12         88
SYSAUX                                280    23.0625          8         92
SYSTEM                                510     9.0625          2         98
PSAPTEMP                             1270         15          1         99

8 rows selected.

Show MAX_SIZE datafile

SQL> select tablespace_name, maxbytes/1024/1024 MAX_SIZE from dba_data_files;

TABLESPACE_NAME                  MAX_SIZE
------------------------------ ----------
SYSTEM                              10000
PSAPUNDO                            10000
SYSAUX                              10000
PSAPCRM                              5120
PSAPCRM                              5120
PSAPCRM                             10000
PSAPCRM                             10000
PSAPCRM                             10000
PSAPCRM                             10000
PSAPCRM                             10000
PSAPCRM                             10000

TABLESPACE_NAME                  MAX_SIZE
------------------------------ ----------
PSAPCRM                             10000
PSAPCRM                             10000
PSAPCRM                             10000
PSAPCRM701                           3072
PSAPCRM701                           3072
PSAPCRM701                          10000
PSAPCRM701                          10000
PSAPCRM701                          10000
PSAPCRM701                          10000
PSAPCRM701                          10000
PSAPCRM701                          10000

TABLESPACE_NAME                  MAX_SIZE
------------------------------ ----------
PSAPCRM701                          10000
PSAPCRM701                          10000
PSAPCRMUSR                          10000
PSAPCRMDB                            2048
PSAPCRMDB                            2048
PSAPCRMDB                           10000
PSAPCRMDB                           10000
PSAPCRMDB                           10000

30 rows selected.