Set time for table buffers

[niranjan_vivekanandan]

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

[former_member192616]

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

[niranjan_vivekanandan]

Hi Hermann,

Thanks for the reply,

Can you tell me how to increase the buffer size.

Regards,

Niranjan

Edited by: nvive19 on May 3, 2011 2:12 PM

[yuri_ziryukin]

Hello Niranjan,

use the following profile parameters:

For genericly buffered tables:

zcsa/table_buffer_area (in bytes)

zcsa/db_max_buftab (in entries)

For single record buffer:

rtbb/buffer_length (in KB)

rtbb/max_tables (in entries)

Regards,

Yuri

[former_member192616]

Hi,

check out SAP note 480710 for further details.

Kind regards,

Hermann