how can we create a particular tables buffer which are
mostly used/ And where we can see them ?
The table buffer is located between the application and the
database. Its goal is to cache portions of a database table
in the application server to reduce database load and
network communication.
ST10 will help you to identify buffering problems.
or use SE13 to display the buffer settings for several tables.
We can activate buffering for a table in the ABAP Dictionary
using Technical settings in transaction SE11 or SE13, you
can choose between different settings like Fully buffered,
Generic area buffered, and single record buffered.
Table buffer advantages:
Makes data access many time faster
Reduces the load on the database
Reduces the load on the network and on CPU
The work process is freed more quickly for other work
Table buffer disadvantages:
If an SAP system consists of more than one SAP instance,
then buffering might be dangerous.
Invalidation of buffered data - If data stored in a buffer
is outdated compared to data on the database, then this data
is no longer available for access and will be overwritten.
By setting the system parameter rdisp/bufrefmode to the
value sendon, exeauto you can ensure the following mechanism
and is strongly recommended by SAP:
The sendon switch for the parameter rdisp/bufrefmode will
force the SAP system to log each change to buffered data in
the table DDLOG on the database. By setting the exeauto
switch for the same parameter, you can force all SAP
instance to periodically check the validity of their locally
buffered data against table DDLOG
Hope answered all u r queries with regard to table buffer
Is This Answer Correct ? | 4 Yes | 0 No |
What are the activities you done in PI?
diff between remote client copy and client transport?
What is luw (logical unit of work)?
Transport error codes and their description?
How do find the SNOTE?
how can i decleare select-options in module pool table control?
How to make a copied client from the Client 000 cannot be customized?
What to do if If Buffer Hit ratio is less than 95%
What are the types of transport queries?
What is the SAP Buffer hit ration?
Explain transport domain?
What is difference between oracle 9i and oracle 10g?