Problem Statement: Problem Statement



Yüklə 2,03 Mb.
səhifə3/25
tarix26.12.2016
ölçüsü2,03 Mb.
#3373
1   2   3   4   5   6   7   8   9   ...   25

  • Expansion

    • We support the changing of the physical log location already.
    • We want to make sure there is only sole occupancy in the space for the physical log; nothing else hindering its successful expansion and requested size:
      • A new single Physical Log Storage Space (PLOGspace) per instance,
      • Has a single physical chunk containing only the server physical log with the physical page size of the host O/S.
  • Physical log expansion is triggered by any of the following

    • A checkpoint blocked user transactions because the physical log is too small.
    • 5 checkpoints triggered by physical log activity:
      • Since the last time the physical log was extended.
      • And within the last 20 checkpoints.


    General Syntax:

    • General Syntax:

      • onspaces -c –P -p
        -o -s [-m ]

    • Yüklə 2,03 Mb.

      Dostları ilə paylaş:
    1   2   3   4   5   6   7   8   9   ...   25




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

    gir | qeydiyyatdan keç
        Ana səhifə


    yükləyin