Scribd Logo
Upload

Welcome to Scribd!

  • 615 views

    04 - CHP - ISM Book Exc Solutions Q3

    Uploaded by

    ibelieveicanfly06
    This document provides solutions to exercises from a chapter on information storage and management. It addresses an Oracle database using a 4KB block size that primarily performs sequential reads. The appropriate cache parameter values suggested are: a 4KB cache page size to match the database block size, allocating more cache to reads than writes given the sequential read operations, using fixed pre-fetching to optimize sequential reads, and setting a large value for write aside cache.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    04 - CHP - ISM Book Exc Solutions Q3

    Uploaded by

    ibelieveicanfly06
    615 views1 page
    This document provides solutions to exercises from a chapter on information storage and management. It addresses an Oracle database using a 4KB block size that primarily performs sequential reads. The appropriate cache parameter values suggested are: a 4KB cache page size to match the database block size, allocating more cache to reads than writes given the sequential read operations, using fixed pre-fetching to optimize sequential reads, and setting a large value for write aside cache.

    Original Title

    04_Chp_ISM Book Exc Solutions Q3

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides solutions to exercises from a chapter on information storage and management. It addresses an Oracle database using a 4KB block size that primarily performs sequential reads. The appropriate cache parameter values suggested are: a 4KB cache page size to match the database block size, allocating more cache to reads than writes given the sequential read operations, using fixed pre-fetching to optimize sequential reads, and setting a large value for write aside cache.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    615 views1 page

    04 - CHP - ISM Book Exc Solutions Q3

    Uploaded by

    ibelieveicanfly06
    This document provides solutions to exercises from a chapter on information storage and management. It addresses an Oracle database using a 4KB block size that primarily performs sequential reads. The appropriate cache parameter values suggested are: a 4KB cache page size to match the database block size, allocating more cache to reads than writes given the sequential read operations, using fixed pre-fetching to optimize sequential reads, and setting a large value for write aside cache.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    EMC Education Services

    Exercise Solutions
    Information Storage and Management Book Chapter 4

    Chapter 4

    3. An Oracle database uses a block size of 4 K for its I/O operation. The application that
    uses this database primarily performs a sequential read operation. Suggest and explain
    the appropriate values for the following cache parameters: cache page size, cache
    allocation (read versus write), pre-fetch type, and write aside cache.
    Solution/Hint:
    Cache page size: 4K
    Cache allocation (read versus write): more read cache
    Pre-fetch type: fixed pre-fetch
    Write aside cache: Large value

    Page 1 of 1

    You might also like