Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    20

    Unanswered: estimating cache size

    I want to know how to estimate the size of tha cache memory, that is the value of the parameter:

    DB_CACHE_SIZE

    is there any criteria to estimate it??

    I'm working with partiotioned tables of ten millions rows. This tables are indexed and a normal query on this tables return about 10000 rows.

    The maximun number of users working simultaneous and making sql's to this tables are 60.

    Any advice about cache size will be greatly apreciatted.

    Thanks in advance

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    If you want to estimate, and you are on 9i and above, try turning the DB_CACHE_ADVICE parameter to ON for a while. Then examine the data in the V$DB_CACHE_ADVICE view to determine whether you need to increase this parameter or not. Also, you would need to have an eye on the OS as well, since you don't want to increase this parameter too high so your OS page.

    It also depends on the type of application. Since you mentioned partitioned tables, I believe this is a DW, on which you would probably won't a large buffer cache size, but instead fast disks to fetch the data asap.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •