[20130325]表Initrans的數量.txt
[20130325]表Initrans的數量.txt
--可以發現檢視顯示Initrans的數量為1.
2.使用bbed檢視:
--確實預設Initrans的數量為3個。
SQL> @ver
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
CREATE TABLESPACE TESTMSSM DATAFILE
'/u01/app/oracle11g/oradata/test/testmssm01.dbf' SIZE 64M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;
CREATE TABLESPACE TEST DATAFILE
'/u01/app/oracle11g/oradata/test/test01.dbf' SIZE 64M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
create table t1 tablespace testmssm as select * from dept;
create table t2 tablespace test as select * from dept;
SQL> select table_name,ini_trans from dba_tables where table_name in ('T1','T2') and wner=USER;
TABLE_NAME INI_TRANS
---------- ----------
T2 1
T1 1
--可以發現檢視顯示Initrans的數量為1.
2.使用bbed檢視:
SQL> alter system checkpoint;
System altered.
SQL> select rowid,t1.* from t1 ;
ROWID DEPTNO DNAME LOC
------------------ ---------- -------------- -------------
AABCn5AAJAAAACBAAA 50 TEST aaaaa
AABCn5AAJAAAACBAAB 10 ACCOUNTING NEW YORK
AABCn5AAJAAAACBAAC 20 RESEARCH DALLAS
AABCn5AAJAAAACBAAD 30 SALES CHICAGO
AABCn5AAJAAAACBAAE 40 OPERATIONS BOSTON
AABCn5AAJAAAACBAAF 80 aaaa BBBB
6 rows selected.
SQL> select rowid,t2.* from t2 ;
ROWID DEPTNO DNAME LOC
------------------ ---------- -------------- -------------
AABCn6AAIAAAACTAAA 50 TEST aaaaa
AABCn6AAIAAAACTAAB 10 ACCOUNTING NEW YORK
AABCn6AAIAAAACTAAC 20 RESEARCH DALLAS
AABCn6AAIAAAACTAAD 30 SALES CHICAGO
AABCn6AAIAAAACTAAE 40 OPERATIONS BOSTON
AABCn6AAIAAAACTAAF 80 aaaa BBBB
6 rows selected.
SQL> @lookup_rowid AABCn5AAJAAAACBAAA
OBJECT FILE BLOCK ROW
---------- ---------- ---------- ----------
272889 9 129 0
SQL> @lookup_rowid AABCn6AAIAAAACTAAA
OBJECT FILE BLOCK ROW
---------- ---------- ---------- ----------
272890 8 147 0
BBED> set dba 9,129
DBA 0x02400081 (37748865 9,129)
BBED> p ktbbh.ktbbhitl
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0xffff
ub2 kxidslt @46 0x0000
ub4 kxidsqn @48 0x00000000
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00000000
ub2 kubaseq @56 0x0000
ub1 kubarec @58 0x00
ub2 ktbitflg @60 0x8000 (KTBFCOM)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0xc0269096
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0000
ub2 kxidslt @70 0x0000
ub4 kxidsqn @72 0x00000000
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00000000
ub2 kubaseq @80 0x0000
ub1 kubarec @82 0x00
ub2 ktbitflg @84 0x0000 (NONE)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 0
ub2 _ktbitwrp @86 0x0000
ub4 ktbitbas @88 0x00000000
struct ktbbhitl[2], 24 bytes @92
struct ktbitxid, 8 bytes @92
ub2 kxidusn @92 0x0000
ub2 kxidslt @94 0x0000
ub4 kxidsqn @96 0x00000000
struct ktbituba, 8 bytes @100
ub4 kubadba @100 0x00000000
ub2 kubaseq @104 0x0000
ub1 kubarec @106 0x00
ub2 ktbitflg @108 0x0000 (NONE)
union _ktbitun, 2 bytes @110
sb2 _ktbitfsc @110 0
ub2 _ktbitwrp @110 0x0000
ub4 ktbitbas @112 0x00000000
BBED> set dba 8,147
DBA 0x02000093 (33554579 8,147)
BBED> p ktbbh.ktbbhitl
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0xffff
ub2 kxidslt @46 0x0000
ub4 kxidsqn @48 0x00000000
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00000000
ub2 kubaseq @56 0x0000
ub1 kubarec @58 0x00
ub2 ktbitflg @60 0x8000 (KTBFCOM)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0xc02690ac
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0000
ub2 kxidslt @70 0x0000
ub4 kxidsqn @72 0x00000000
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00000000
ub2 kubaseq @80 0x0000
ub1 kubarec @82 0x00
ub2 ktbitflg @84 0x0000 (NONE)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 0
ub2 _ktbitwrp @86 0x0000
ub4 ktbitbas @88 0x00000000
struct ktbbhitl[2], 24 bytes @92
struct ktbitxid, 8 bytes @92
ub2 kxidusn @92 0x0000
ub2 kxidslt @94 0x0000
ub4 kxidsqn @96 0x00000000
struct ktbituba, 8 bytes @100
ub4 kubadba @100 0x00000000
ub2 kubaseq @104 0x0000
ub1 kubarec @106 0x00
ub2 ktbitflg @108 0x0000 (NONE)
union _ktbitun, 2 bytes @110
sb2 _ktbitfsc @110 0
ub2 _ktbitwrp @110 0x0000
ub4 ktbitbas @112 0x00000000
--可以發現Initrans的數量為3.不管表空間是ASSM或者MSSM。
3.使用轉儲看看。
SQL> alter system dump datafile 9 block 129;
System altered.
Block header dump: 0x02400081
Object id on Block? Y
seg/obj: 0x429f9 csc: 0x00.c0269096 itc: 3 flg: - typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0xffff.000.00000000 0x00000000.0000.00 C--- 0 scn 0x0000.c0269096
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
0x03 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
bdba: 0x02400081
data_block_dump,data header at 0x2a9756e274
--確實預設Initrans的數量為3個。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-756983/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- INITRANS引數
- [20130325]KEEP_MASTER and METRICS in EXPDPIMDP.txtAST
- Oracle中INITRANS和MAXTRANS引數Oracle
- [20130325]11GR2.0.3的sshUserSetup.sh檔案.txt
- What is INITRANS and MAXTRANS
- initrans和maxtrans
- 【轉】Oracle學習筆記:INITRANS和MAXTRANS引數的作用Oracle筆記
- SQL Server中對比表數量,索引數量及procedure數量SQLServer索引
- TX:ITL LOCK(INITRANS,MAXINTRANS)
- 查詢表空間中的extent數量
- 思考-兩個大表的關聯.txt
- VMWare中的CPU數量與核心數量意義
- 逆序對的數量
- 檢視一個表中的幾列的資料都是一樣的數量
- PHP5.3 max_input_vars 用來限制提交的表單數量PHP
- 字串的長度,是字元數量,還是位元組數量?字串字元
- 看板數量的計算
- 陣列元素的數量陣列
- Oracle表中資料匯出成 Txt格式的方案Oracle
- 查詢最近幾天的登陸數量,沒有數量的補零
- 把txt文字匯入sqlserver表內SQLServer
- 表變數和臨時表的差別 (以前把表變數叫成變數表了,哎。。。)變數
- [20130220]快速檢視連線資料庫的使用者數量.txt資料庫
- 查詢最近幾天每日的登陸數量,沒有數量的補零
- 物件的數量 與 連線池連線數量的問題,困擾已久。物件
- 數量性狀遺傳引數的提出
- [20191118]確定linux伺服器cpu數量.txtLinux伺服器
- dblink對比本地和遠端表的記錄數量是否一致
- 2.6.6 指定程式的最大數量
- leedcode 位1的數量
- 788. 逆序對的數量
- 逆序對的數量 - 題解
- 谷歌VR應用表現欠佳 多數安裝量不到5000次谷歌VR
- [20210202]計算標量子查詢快取數量2.txt快取
- PHP 函式可變數量的引數列表PHP函式變數
- 讀 CSV/TXT 的報表怎麼做分頁查詢?
- [20121021]探究表的rowdependencies屬性.txt
- [20200824]12c sqlplus rowprefetch arraysize 顯示行數量的關係.txtSQL