上个星期听同事说,设置了RECYCLE池的情况下,ORACLE会将一致性块在RECYCLE池中产生
因为一致性块重用的几率比较低,所以选择在RECYCLE中构造一致性块,可以降低DEFAULT的压力
今天测试了下,果然是
SQL> SELECT P.BP_NAME,
2 B.INST_ID,
3 TS#,
4 FILE#,
5 DBABLK,
6 CLASS,
7 DECODE(STATE,
8 0,
9 'free',
10 1,
11 'xcur',
12 2,
13 'scur',
14 3,
15 'cr',
16 4,
17 'read',
18 5,
19 'mrec',
20 6,
21 'irec',
22 7,
23 'write',
24 8,
25 'pi',
26 9,
27 'memory',
28 10,
29 'mwrite',
30 11,
31 'donated') STATUS,
32 DECODE(BITAND(B.FLAG, 1), 0, 'N', 'Y') DIRTY,
33 DECODE(BITAND(B.FLAG, 16), 0, 'N', 'Y') TEMP,
34 DECODE(BITAND(B.FLAG, 1536), 0, 'N', 'Y') PING,
35 DECODE(BITAND(B.FLAG, 16384), 0, 'N', 'Y') STALE,
36 DECODE(BITAND(B.FLAG, 65536), 0, 'N', 'Y') DIRECT,
37 OBJ
38 FROM X$BH B,
39 (SELECT D.BP_NAME, S.*
40 FROM X$KCBWDS S, X$KCBWBPD D
41 WHERE S.SET_ID >= D.BP_LO_SID
42 AND S.SET_ID <= D.BP_HI_SID
43 AND D.BP_SIZE != 0) P
44 WHERE P.ADDR = B.SET_DS
45 AND B.INST_ID = P.INST_ID
46 AND BJ = 52068
47 AND FILE# = 4
48 AND DBABLK = 60
49 ORDER BY FILE#, DBABLK;
BP_NAME INST_ID TS# FILE# DBABLK CLASS STATUS D T P S D OBJ
---------- ---------- ---------- ---------- ---------- ---------- ------- - - - - - ----------
RECYCLE 1 4 4 60 1 cr N N N N N 52068
RECYCLE 1 4 4 60 1 cr N N N N N 52068
DEFAULT 1 4 4 60 1 xcur N N N N N 52068
DEFAULT 1 4 4 60 1 cr N N N N N 52068
由于DML产生的一致性块,会选择在DEFAULT池中构造
查询产生的一致性块,都在RECYCLE中构造
看来RECYCLE池还是很有用的,好久在研究下下
因为一致性块重用的几率比较低,所以选择在RECYCLE中构造一致性块,可以降低DEFAULT的压力
今天测试了下,果然是
SQL> SELECT P.BP_NAME,
2 B.INST_ID,
3 TS#,
4 FILE#,
5 DBABLK,
6 CLASS,
7 DECODE(STATE,
8 0,
9 'free',
10 1,
11 'xcur',
12 2,
13 'scur',
14 3,
15 'cr',
16 4,
17 'read',
18 5,
19 'mrec',
20 6,
21 'irec',
22 7,
23 'write',
24 8,
25 'pi',
26 9,
27 'memory',
28 10,
29 'mwrite',
30 11,
31 'donated') STATUS,
32 DECODE(BITAND(B.FLAG, 1), 0, 'N', 'Y') DIRTY,
33 DECODE(BITAND(B.FLAG, 16), 0, 'N', 'Y') TEMP,
34 DECODE(BITAND(B.FLAG, 1536), 0, 'N', 'Y') PING,
35 DECODE(BITAND(B.FLAG, 16384), 0, 'N', 'Y') STALE,
36 DECODE(BITAND(B.FLAG, 65536), 0, 'N', 'Y') DIRECT,
37 OBJ
38 FROM X$BH B,
39 (SELECT D.BP_NAME, S.*
40 FROM X$KCBWDS S, X$KCBWBPD D
41 WHERE S.SET_ID >= D.BP_LO_SID
42 AND S.SET_ID <= D.BP_HI_SID
43 AND D.BP_SIZE != 0) P
44 WHERE P.ADDR = B.SET_DS
45 AND B.INST_ID = P.INST_ID
46 AND BJ = 52068
47 AND FILE# = 4
48 AND DBABLK = 60
49 ORDER BY FILE#, DBABLK;
BP_NAME INST_ID TS# FILE# DBABLK CLASS STATUS D T P S D OBJ
---------- ---------- ---------- ---------- ---------- ---------- ------- - - - - - ----------
RECYCLE 1 4 4 60 1 cr N N N N N 52068
RECYCLE 1 4 4 60 1 cr N N N N N 52068
DEFAULT 1 4 4 60 1 xcur N N N N N 52068
DEFAULT 1 4 4 60 1 cr N N N N N 52068
由于DML产生的一致性块,会选择在DEFAULT池中构造
查询产生的一致性块,都在RECYCLE中构造
看来RECYCLE池还是很有用的,好久在研究下下
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8242091/viewspace-723078/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8242091/viewspace-723078/