....151.191
1.5个表空间分别是:SYSTEM SYSAUX UNDOTBS USERS V_DATACENTER
表空间大小分别是: 768m, 640m, 5120m, 4m, 112G
块大小分别是: 96k, 80k, 640k, 0.5k, 14080k
自增长字节分别为: 2k, 2k, 5m, 0k, 96k
2.select * from v$sga;
Fixed Size 2m
Variable Size 848m
Database Buffers 2816m
Redo Buffers 29m
3.select name,value/1024/1024 from v$pgastat;
aggregate PGA target parameter 2480
--Business 8节点集群:
1.13个表空间分别是:SYSTEM SYSAUX USERS ODSDATA DMCDATA
表空间大小分别是: 12G, 3G, 128m, 100G, 1.2T
块大小分别是: 1502k, 384k, 16k, 12M, 156M
自增长字节分别为: 1.25k, 1.25k, 0m, 0k, 0k
(附8个undo表空间:
select tablespace_name,bytes/1024/1024,blocks/1024,increment_by from dba_data_files;
UNDOTBSTMP1 995.3125 124.4140625 1k
UNDOTBSTMP2 201.125 25.140625 1k
UNDOTBSTMP3 352.4375 44.0546875 1k
UNDOTBSTMP4 5430.3125 678.7890625 1k
UNDOTBSTMP5 4242.0625 530.2578125 1k
UNDOTBSTMP6 1283.125 160.390625 1k
UNDOTBSTMP7 766.9375 95.8671875 1k
UNDOTBSTMP8 6278.125 784.765625 1k
2.select name,value/1024/1024 from v$sga;
Fixed Size 2m
Variable Size 2304m
Database Buffers 2G
Redo Buffers 42.5M
3.select name,value/1024/1024 from v$pgastat;
aggregate PGA target parameter 2480