计算SGA各池的内存地址的边界

1、LOG BUFFER池内存地址边界
0x00000060222000 > LOG BUFFER池内存 <0x0000006682B000（0x00000060222000+6609000）

如下计算：
[email protected]> oradebug setmypid
Statement processed.
[email protected]> oradebug ipc
Information written to trace file.
[email protected]> col value for a80
[email protected]> select value from v$diag_info where name=’Default Trace File’;

（福利推荐：阿里云、腾讯云、华为云服务器最新限时优惠活动，云服务器1核2G仅88元/年、2核4G仅698元/3年，点击这里立即抢购>>>）

VALUE

/export/home/oracle/diag/rdbms/dtrace/dtrace/trace/dtrace_ora_4103.trc
Area #2 `Redo Buffers’ containing Subareas 1-1
Total size 0000000006609000 Minimum Subarea size 00000000
Area Subarea Shmid Stable Addr Actual Addr

  2        1   196612 0x00000060222000 0x00000060222000                           Subarea size     Segment size                       0000000006609000 0000000006c00000  

2、BUFFER CACHE池内存地址的边界
0x0000000078A22000 > BUFFER CACHE池内存地址 < 0x000000007FBD6000

如下计算：
[email protected]> select min(ba),max(ba) from x$bh;
MIN(BA) MAX(BA)

0000000078A22000 000000007FBD6000

3、SHARED POOL池内存地址边界
0x93800000> SHARED POOL池内存地址 <0x9bc00000 (0x9b800000+400000)

如下计算：
[email protected]> alter session set events ‘immediate trace name heapdump level 2’;
Session altered.

[email protected]> col value for a80
[email protected]> select value from v$diag_info where name=’Default Trace File’;

VALUE

/export/home/oracle/diag/rdbms/dtrace/dtrace/trace/dtrace_ora_4046.trc

more /export/home/oracle/diag/rdbms/dtrace/dtrace/trace/dtrace_ora_4046.trc

HEAP DUMP heap name=”sga heap(1,0)” desc=0x600551a0
extent sz=0xfe0 alt=248 het=32767 rec=9 flg=-126 opc=0
parent=(nil) owner=(nil) nex=(nil) xsz=0x400000 heap=(nil)
fl2=0x20, nex=(nil), dsxvers=1, dsxflg=0x0
dsx first ext=0x9a800000
latch set 1 of 7
durations disabled for this heap
reserved granules for root 57 (granule size 4194304)
EXTENT 0 addr=0x93800000
………………………..
EXTENT 5 addr=0x9b800000
Chunk 09b800058 sz= 80 perm “perm ” alo=80
Chunk 09b8000a8 sz= 48 R-freeable “reserved stoppe”
Chunk 09b8000d8 sz= 212728 R-free ” “
Chunk 09b833fd0 sz= 48 R-freeable “reserved stoppe”
Chunk 09b834000 sz= 2763512 perm “perm ” alo=2763512
Chunk 09bad6af8 sz= 1209408 perm “perm ” alo=1209408
Chunk 09bbfdf38 sz= 64 freeable “KGI Session Sta”
Chunk 09bbfdf78 sz= 40 freeable “listener addres”
Chunk 09bbfdfa0 sz= 128 freeable “dbgefgHtAddSK-1”
Chunk 09bbfe020 sz= 136 freeable “dbgefgHtAddSK-1”
Chunk 09bbfe0a8 sz= 40 freeable “plwppwp:PLW_STR”
Chunk 09bbfe0d0 sz= 160 freeable “joxs heap “
Chunk 09bbfe170 sz= 32 freeable “PRESENTATION EN”
Chunk 09bbfe190 sz= 2072 freeable “PRESENTATION TA”
Chunk 09bbfe9a8 sz= 1168 freeable “character set m”
Chunk 09bbfee38 sz= 4552 freeable “character set m”
Total heap size = 25165296

看转储的DUMP日志一个区的大小是: xsz=0x400000

你还在原价购买阿里云、腾讯云、华为云、天翼云产品？那就亏大啦！现在申请成为四大品牌云厂商VIP用户，可以3折优惠价购买云服务器等云产品，并且可享四大云服务商产品终身VIP优惠价，还等什么？赶紧点击下面对应链接免费申请VIP客户吧：

1、点击这里立即申请成为腾讯云VIP客户

2、点击这里立即注册成为天翼云VIP客户

3、点击这里立即申请成为华为云VIP客户

4、点击这里立享阿里云产品终身VIP优惠价

喜欢 (0)赏

[[email protected]]

分享 (0)