Oracle11g 體系結(jié)構(gòu)

一：Oracle11g 體系結(jié)構(gòu)

二：邏輯儲(chǔ)存結(jié)構(gòu)

二、1：數(shù)據(jù)塊(data blocks)

1 ----通過(guò) v$parameter數(shù)據(jù)字典來(lái)查詢(xún)oracle標(biāo)準(zhǔn)數(shù)據(jù)塊的大小。

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：數(shù)據(jù)區(qū) 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 表空間

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

總結(jié)

以上是生活随笔為你收集整理的oracle11g的体系结构有几种,Oracle11g 体系结构的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。