Problem Statement: Problem Statement


A BUFFERPOOL definition can NOT include aspects of both formats; either it’s expressed in legacy format or memory format



Yüklə 2,03 Mb.
səhifə14/25
tarix26.12.2016
ölçüsü2,03 Mb.
#3373
1   ...   10   11   12   13   14   15   16   17   ...   25

A BUFFERPOOL definition can NOT include aspects of both formats; either it’s expressed in legacy format or memory format.

  • A BUFFERPOOL definition can NOT include aspects of both formats; either it’s expressed in legacy format or memory format.

  • A BUFFERPOOL definition with mixed formats is rejected and the database server will not start.

  • The charts on the next several slides describe each argument to the BUFFERPOOL parameter:

    • both = works with legacy & memory format.
    • legacy & memory are mutually exclusive.








BUFFERPOOL size=2k,extendable=1,buffers=1000,next_buffers=2000,max_extends=8

  • BUFFERPOOL size=2k,extendable=1,buffers=1000,next_buffers=2000,max_extends=8

    • Create a 2k pagesize buffer pool.
    • The buffer pool is extendable up to 8 times.
      • The 1st 3 extensions will be of 2000 buffers,
      • Next 4 will be of 4000 buffers and
      • The 8th extension will be of 8000 buffers.

  • Yüklə 2,03 Mb.

    Dostları ilə paylaş:
1   ...   10   11   12   13   14   15   16   17   ...   25




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©www.azkurs.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin