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

    Unanswered: estimating cache size

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


    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
    Dominican Republic
    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