目前使用的数据库探讨

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