Shared Pool Internals

coolingverse

Shared Pool Internals:


SECTION ONE: INTRODUCTION........................................................................................................................................ 4
SECTION TWO: OVERVIEW ................................................................................................................................................ 5
  H ISTORY ...................................................................................................................................................................................... 5
  M EMORY  M ANAGEMENT............................................................................................................................................................. 6
SECTION THREE: THE COMPONENTS OF THE ORACLE MEMORY ARCHITECTURE ..................................... 8
  PGA ............................................................................................................................................................................................ 8
  SGA ............................................................................................................................................................................................ 8
  CLASSES ................................................................................................................................................................................... 9
SECTION FOUR: LIBRARY CACHE MANAGER ........................................................................................................... 12
  CONCEPTS.................................................................................................................................................................................. 12
  H ASH T ABLE AND H ASH B UCKET.............................................................................................................................................. 12
  LIBRARY  CACHE  H ANDLE.......................................................................................................................................................... 13
  LIBRARY  CACHE  O BJECT ........................................................................................................................................................... 14
  LOCKING AND P INNING .............................................................................................................................................................. 16
  LIBRARY  CACHE  LATCHES ........................................................................................................................................................ 18
SECTION FIVE: TUNING AND MONITORING THE SHARED POOL........................................................................ 19
  INTRODUCTION .................................................................................................................................................................... 19
  QUICK TUNING TIPS ............................................................................................................................................................ 19
  MEMORY FRAGMENTATION ............................................................................................................................................. 21
  LIBRARY CACHE LATCH CONTENTION.......................................................................................................................... 26
  SIZING OF SHARED POOL ................................................................................................................................................... 28
  COMMON FALLACIES.......................................................................................................................................................... 31
  SUMMARY.............................................................................................................................................................................. 32
  MONITORING AND V$VIEWS............................................................................................................................................. 32
  SCRIPTS AND INIT.ORA PARAMETERS............................................................................................................................ 35
  RESERVED  SHARED P OOL.......................................................................................................................................................... 51
  TUNING HINTS BASED ON V$SHARED_POOL_RESERVED ......................................................................................... 53
  P ROCEDURE FREE_ UNUSED_ MEMORY....................................................................................................................................... 54
SECTION SIX: SHARED POOL BUGS ............................................................................................................................... 57
shared pool internals.pdf (179.9 KB, 下载次数: 6, 售价: 10 金钱)

2013-3-7 23:20 上传

点击文件名下载附件
售价: 10 金钱  [记录]