Differences between revisions 15 and 26 (spanning 11 versions)
⇤ ← Revision 15 as of 2016-05-17 09:34:31 →
Size: 2239
Editor: localhost
Comment:
← Revision 26 as of 2016-05-18 12:50:13 → ⇥
Size: 6362
Editor: localhost
Comment:
Deletions are marked like this. Additions are marked like this.
Line 20: Line 20:
mkdir /oracle/BIP/sapdata2/sr3_102/
mkdir /oracle/BIP/sapdata2/sr3_103/
Line 21: Line 23:
mkdir /oracle/BIP/sapdata2/sr3_102/
Line 23: Line 24:
mkdir /oracle/BIP/sapdata2/sr3_103/
Line 25: Line 25:

# 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;
/
}}}

== ZYBPRD2 ==
{{{
/oracle/BPP/sapdata2/sr3_13
}}}

== 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;
Line 37: Line 63:
sqlplus / as sysdba
ALTER TABLESPACE PSAPCRM ADD DATAFILE '/oracle/CRP/sapdata4/crm_10/crm.data10' SIZE 2G AUTOEXTEND ON NEXT 20M MAXSIZE 3G;
/
Line 43: Line 65:
ALTER TABLESPACE PSAPCRM ADD DATAFILE '/oracle/CRP/sapdata4/crm_11/crm.data11' SIZE 2G AUTOEXTEND ON NEXT 20M MAXSIZE 3G;  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;
Line 48: Line 71:
sqlplus / as sysdba
ALTER TABLESPACE PSAPCRMDB ADD DATAFILE '/oracle/CRP/sapdata4/crmdb_4/crmdb.data4' SIZE 2G AUTOEXTEND ON NEXT 20M MAXSIZE 3G;
/
Line 53: Line 73:
ALTER TABLESPACE PSAPCRMDB ADD DATAFILE '/oracle/CRP/sapdata4/crmdb_4/crmdb.data5' SIZE 2G AUTOEXTEND ON NEXT 20M MAXSIZE 3G;  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;
Line 55: Line 76:

# 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;
Line 56: Line 85:

=== 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.
}}}

Contents

  1. 中烟
    1. 时间慢半小时
    2. 表空间调整策略
    3. SGA值太小
    4. ZYBPRD2
    5. ZYBPRD2
    6. ZYBPCPRD2
    7. ZYCPRD2
      1. free/used space per tablespace
      2. Show MAX_SIZE datafile

中烟

  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/
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; 
/

ZYBPRD2

/oracle/BPP/sapdata2/sr3_13

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.

首頁/2016-05-17 (last edited 2016-05-18 13:05:26 by localhost)