Skip to Content

Set time for table buffers

Hi Experts,

Is it possible to set time for the table buffers,so that data will be there for long time even though its not frequently accessed.

I would like to know the steps to change the settings in detail.

Thanks & Regards,

Niranjan

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on May 03, 2011 at 06:53 AM

    Hi,

    Hi Experts,

    >

    > Is it possible to set time for the table buffers,so that data will be there for long time even though its not frequently accessed.

    > I would like to know the steps to change the settings in detail.

    >

    > Thanks & Regards,

    >

    > Niranjan

    No this is not possible. The data in the table buffer is displaced based on internal counters using LRU (least recently used) and

    LFU (least frequently used) algorithms. If enough free memory is available i suggest to increase the table buffers to avoid

    diplacement (if possible).

    Kind regards,

    Hermann

    Add comment
    10|10000 characters needed characters exceeded