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 |
If you have a long-running Job, how do you analyse?
Difference between SAPNote and Support package?
what is the difference between db01 locks and sm12 locks?
what is the default file for TMS ?
What do will do in OS level monitoring
what are client settings?
How to work with Transaction SMLG? How to configure Logon Groups in Application server?
HI , As an SAP BASIS member , Why do we need to monitor lock entries(SM12) and Update Errors(SM13) , wht is the trouble shooting for those ?
Last step of kernel upgrade in unix Root.sh?
how to check network among Central Instance, Application Server, Database Instance?
what are the jspm related logs that you see at os level at the time of java stack upgradation?
How can one start Sap Application Server through Command prompt and what is the command used to start SAP Application Server ?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)