Database statistics Concept

Database statistics Concept: • The Oracle cost-based optimizer (CBO) uses the statistics to optimize access paths when retrieving data for queries. If the statistics are out-of-date, the CBO might generate inappropriate access paths (such as using the wrong index), resulting in poor performance By running update statistics regularly, you make sure that the database statistics […]

Read More

Change and Transport System Concept

Change and Transport System: Change and Transport System (CTS) is a tool that helps you to organize development projects in ABAP Workbench and customizing, and then transport the changes between the SAP systems in your system landscape. As well as ABAP objects, you can also transport Java objects and SAP-specific non-ABAP applications in your system […]

Read More

List of Port used in SAP System

List of port that used for SAP ABAP and JAVA Netweaver system, most of them picked during installation automatically. So below table describe briefly about this. ABAP: Product name Port Name Service in etc/services Default Range Rule External Fixed Comments (Explanation of Table Headings) Application Server ABAP SAP Dispatcher sapdp<NN> 3200 3200-3299 32<NN> Yes Yes Used […]

Read More

SGEN in detail

Information about the SAP Load Generator (SGEN) Overview With transaction SGEN, you can generate ABAP loads in your SAP system. This includes the load generation for specific software components/packages, the generation for changed components after a system upgrade, and the regeneration of previously generated loads. You can also resume or repeat previous SGEN runs, include […]

Read More

SUM process in detail

Below the detail briefing of each step in SUM process for ABAP system. 1 Extraction Phase name Brief details CHECK4NOTES_TOOL phase: SUM asks to implement some necessary SAP Notes CHECKPROF_INI phase: SUM checks the system profiles for problems CHECKSYSSTATUS phase: SUM reads the profiles and checks the state of the running instances CONFCHK_IMP phase: In […]

Read More

Brief description of kernel executable files

Here are the brief description of kernel executable files. Kenel Files  Description R3check The tool will check Cluster-Tables for errors R3ldctl The tool for exporting all table structures to the file system during an OS/DB-Migration. R3load The table import & export tool of SAP during Installation, Upgrade and Migration. R3szchk The tool for determine the […]

Read More

Few Basic terminology that used in SAP

Below is few basic terminology that used in SAP. Client: Clients are additional installable programs or tools. They reside either on local front-end PCs accessed by users or on back-end systems where they act as client programs within an SAP NetWeaver system landscape. Functional Unit: A configured and activated unit of SAP NetWeaver that provides […]

Read More

Environment variable related to SAP with Oracle Database

An environment variable is a variable whose value is set outside the program, typically through functionality built into the operating system or microservice. An environment variable is made up of a name/value pair, and any number may be created and available for reference at a point in time. The environment variable helps in pointing out […]

Read More

SAP Memory Concepts

 SAP Memory Concepts Roll Memory –>The roll area holds the user environment information needed by work processes when executing dialog steps. Extended Memory –> Specifies how much of the SAP extended memory was requested by this user. Heap memory–> Private memory (heap memory) requested by the user. Swap Memory –> SAP swap area is only used for a limited number of ABAP commands.   […]

Read More

Unix/Linux command that are helpful for SAP Basis

Below is the list of few Unix/Linux command that are helpful for SAP Basis Purpose. Command Details dpmon or dpmon pf= <Instance profile path> ABAP Dispatcher queue monitor jsmon pf=<instance profile path> Java Server monitoring ps -ef Running work process ps –eaf|grep dw sap Process overview ps –eaf|grep ora To check oracle service is running kill -9 <PID> Kill work process […]

Read More

How to check which user utilized maximum SM12 Lock in SAP

Sometimes it happens when few user process/program/transactions utilized maximum all SM12 lock entry, which may lead temporary bottle neck in system. Also, its lead to ABAP dump of LOCK_TABLE_OVERFLOW in many situations. Note: ** The size of the lock table limits the maximum number of lock entries, the maximum number of elementary lock names, and […]

Read More

Quick guide to checks any SAP Performance issue in SAP ABAP system

Critical tasks: Check that the R/3System is up –> Log onto the R/3 System Check that daily backup executed without errors –> DB12 Check database backup from DB02 or another backup tool. Log backup –> Log backup is completing successfully and adequate log area is there. Network Issue –> verify there is any network issue […]

Read More