数据库现状

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE	11.2.0.4.0	Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> set pagesize 0;
select tablespace_name ,sum(bytes)/1024/1024/1024 as GB from dba_data_files group by tablespace_name;
SQL> aaaa10			       66.7578125
SYSAUX				 .6640625
UNDOTBS1		       4.83886719
aaaa3			       165.399414
aaaa8			       66.7578125
aaaa1			       165.399414
aaaa7			       66.7578125
USERS			       .004882813
aaaa6			       165.399414
SYSTEM				 .7421875
aaaa2			       165.399414
aaaa4			       165.399414
aaaa5			       165.399414
aaaa9			       66.7578125
aaaa11			       66.7578125
SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';
Session altered.
SQL> select max(LAST_ANALYZED) from dba_tables;
2020-02-25 22:20:26

数据文件大小

 du -sh  /test-nvme/oradata/orcl 
1.4T	/test-nvme/oradata/orcl

修改linux内核参数shmmax和shmall

修改之前共享内存

[oracle@base-test-01 ~]$ ipcs -m

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status      
0x00000000 114458624  oracle     640        4096       0                       
0x00000000 114491393  oracle     640        4096       0                       
0x00000000 114524163  oracle     640        4096       0                       
0x00000000 1212420    root       644        80         2                       
0x00000000 1245189    root       644        16384      2                       
0x00000000 1277958    root       644        280        2                       
0x00000000 297435143  root       600        524288     2          dest         
0x00000000 114556936  oracle     640        4096       0                       
0x00000000 114589705  oracle     640        4096       0                       
0x00000000 114622474  oracle     640        4096       0                       
0x00000000 114655243  oracle     640        4096       0                       
0x00000000 114688012  oracle     640        4096       0                       
0x00000000 114720781  oracle     640        4096       0                       
0x00000000 114753550  oracle     640        4096       0                       
0x00000000 114786319  oracle     640        4096       0                       
0x00000000 114819088  oracle     640        4096       0                       
0x00000000 114851857  oracle     640        4096       0                       
0x00000000 114884626  oracle     640        4096       0