oracle11g的体系结构有几种,Oracle11g 体系结构

Oracle11g 体系结构

一：Oracle11g 体系结构

二：逻辑储存结构

二、1：数据块(data blocks)

1 ----通过 v$parameter数据字典来查询oracle标准数据块的大小。

2 [email protected]> startup

3 ORACLE instance started.

4

5 Total System Global Area 1221992448 bytes

6 Fixed Size 1344596 bytes

7 Variable Size 771754924 bytes

8 Database Buffers 436207616 bytes

9 Redo Buffers 12685312 bytes

10 Database mounted.

11 Database opened.

12 [email protected]> col name format a30;

13 [email protected]> col value format a20;

14 [email protected]> select name,value from v$parameter where name=‘db_block_size‘;

15

16 NAME VALUE

17 ------------------------------ --------------------

18 db_block_size 8192

19

20 [email protected]> show parameter db_block

21

22 NAME TYPE VALUE

23 ------------------------------------ ----------- ------------------------------

24 db_block_buffers integer 0

25 db_block_checking string FALSE

26 db_block_checksum string TYPICAL

27 db_block_size integer 8192

二、2：数据区 extent

二、3：段  segment

二、4：表空间  tablespace

二、5： SYSTEM 表空间

1 [email protected]> col table_name for a30;

2 [email protected]> col comments for a30;

3 [email protected]> select * from dict;

4

5 TABLE_NAME COMMENTS

6 ------------------------------ ------------------------------

7 DBA_CONS_COLUMNS Information about accessible c

8 olumns in constraint definitio

9 ns

10

11 DBA_LOG_GROUP_COLUMNS Information about columns in l

12 og group definitions

13

14 DBA_LOBS Description of LOBs contained

15 in all tables

16

17 DBA_CATALOG All database Tables, Views, Sy

二、6：SYSAUX 表空间

二、7：UODO 表空间

二、8：USERS 表空间

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------