kdimod adding block to free list

dla001

环境：
OEL5.7  x64
11.2.0.3.5  ASM  x64

使用
alter system set events '10224 trace name context forever,level 1';
事件观察索引分裂与索引块的使用。

在插入大量数据后，然后删除全部数据。
trace文件中显示：

插入数据后的dump

1. *** 2013-05-22 16:45:59.022
   
2. ----- begin tree dump
   
3. branch: 0x10090f3 16814323 (0: nrow: 8, level: 1)
   
4.    leaf: 0x10090f7 16814327 (-1: nrow: 69 rrow: 69)
   
5.    leaf: 0x10090f4 16814324 (0: nrow: 68 rrow: 68)
   
6.    leaf: 0x10090f5 16814325 (1: nrow: 68 rrow: 68)
   
7.    leaf: 0x10090f6 16814326 (2: nrow: 68 rrow: 68)
   
8.    leaf: 0x10081ff 16810495 (3: nrow: 68 rrow: 68)
   
9.    leaf: 0x10081f8 16810488 (4: nrow: 68 rrow: 68)
   
10.    leaf: 0x10081f9 16810489 (5: nrow: 68 rrow: 68)
    
11.    leaf: 0x10081fb 16810491 (6: nrow: 23 rrow: 23)
    
12. ----- end tree dump
    

复制代码

删除全部数据时，trace文件中显示

1. *** 2013-05-22 16:46:10.693
   
2. kdimod adding block to free list,dba 0x010090f5,time 16:46:10.693
   
3. kdimod adding block to free list,dba 0x010090f6,time 16:46:10.695
   
4. kdimod adding block to free list,dba 0x010090f7,time 16:46:10.698
   
5. kdimod adding block to free list,dba 0x010090f4,time 16:46:10.699
   
6. kdimod adding block to free list,dba 0x010081f9,time 16:46:10.702
   
7. kdimod adding block to free list,dba 0x010081fb,time 16:46:10.702
   
8. kdimod adding block to free list,dba 0x010081ff,time 16:46:10.704
   
9. kdimod adding block to free list,dba 0x010081f8,time 16:46:10.704

复制代码

删除后dump

1. *** 2013-05-22 16:46:18.911
   
2. ----- begin tree dump
   
3. branch: 0x10090f3 16814323 (0: nrow: 8, level: 1)
   
4.    leaf: 0x10090f7 16814327 (-1: nrow: 69 rrow: 0)
   
5.    leaf: 0x10090f4 16814324 (0: nrow: 68 rrow: 0)
   
6.    leaf: 0x10090f5 16814325 (1: nrow: 68 rrow: 0)
   
7.    leaf: 0x10090f6 16814326 (2: nrow: 68 rrow: 0)
   
8.    leaf: 0x10081ff 16810495 (3: nrow: 68 rrow: 0)
   
9.    leaf: 0x10081f8 16810488 (4: nrow: 68 rrow: 0)
   
10.    leaf: 0x10081f9 16810489 (5: nrow: 68 rrow: 0)
    
11.    leaf: 0x10081fb 16810491 (6: nrow: 23 rrow: 0)
    
12. ----- end tree dump

复制代码

在这里有个问题
kdimod adding block to free list
这表明，把block放到freelist上，那么这个freelist在哪里存放？ branch？ leaf ？
如何能看到这个freelist的信息？

Maclean Liu(刘相兵

kdimod  负责 删除 更新和 索 行中的keydata

Maclean Liu(刘相兵

0x10090f7=> 100  00 00001 00100 00111 10111

100=> 4号文件 你做实验的表空间 的ddl给出

dla001

Maclean Liu(刘相兵 发表于 2013-5-22 22:52
0x10090f7=> 100  00 00001 00100 00111 10111

100=> 4号文件 你做实验的表空间 的ddl给出 ...

1. SQL> select file_id,tablespace_name from dba_data_files where file_id=4;      
   
2. 
   
3.    FILE_ID TABLESPACE_NAME
   
4. ---------- ------------------------------
   
5.          4 USERS
   
6. 
   
7. SQL> SELECT DBMS_METADATA.GET_DDL('TABLESPACE','USERS') FROM DUAL;            
   
8. 
   
9. DBMS_METADATA.GET_DDL('TABLESPACE','USERS')
   
10. --------------------------------------------------------------------------------
    
11. 
    
12.   CREATE TABLESPACE "USERS" DATAFILE
    
13.   SIZE 5242880
    
14.   AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M
    
15.   LOGGING ONLINE PERMANENT BLOCKSIZE 8192
    
16.   EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
    
17. NOCOMPRESS  SEGMENT SPACE MANAGEMENT AUTO
    
18.    ALTER DATABASE DATAFILE
    
19.   '+DATA/zw002/datafile/users.327.791918633' RESIZE 323747840
    
20. 
    
21. SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','ZWHUA03','ALGALON') FROM DUAL;
    
22. 
    
23. DBMS_METADATA.GET_DDL('TABLE','ZWHUA03','ALGALON')
    
24. --------------------------------------------------------------------------------
    
25. 
    
26.   CREATE TABLE "ALGALON"."ZWHUA03"
    
27.    (    "A" NUMBER,
    
28.         "B" VARCHAR2(120),
    
29.         "C" DATE
    
30.    ) SEGMENT CREATION IMMEDIATE
    
31.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
    
32. NOCOMPRESS LOGGING
    
33.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    
34.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
    
35.   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    
36.   TABLESPACE "USERS"
    
37. 
    
38. 
    
39. SELECT DBMS_METADATA.GET_DDL('INDEX','IDX_SPLIT_IDX','ALGALON') FROM DUAL;            
    
40. 
    
41. CREATE INDEX "ALGALON"."IDX_SPLIT_IDX" ON "ALGALON"."ZWHUA03" ("A", "B")
    
42.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
    
43.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    
44.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
    
45.   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    
46.   TABLESPACE "USERS"
    

复制代码