Control and Parameter file concept of Oracle Database

Few basic concept of Control and Parameter file concept of Oracle Database. Control file: A control file, which is a small binary file that records the physical structure of the database. The control file includes: The database name Names and locations of associated datafiles and redo log files The timestamp of the database creation The […]

Read More

SAP HANA System Replication overview

SAP HANA system replication provides the possibility to copy and continuously synchronize a SAP HANA database to a secondary location in the same or another data center. Usually system replication is used to support high availability and disaster recovery. System Replication is a standard SAP HANA feature. In this method, all data is replicated to […]

Read More

How to check HANA memory utilization through HANA studio and HANA Cockpit

We can check meory utilization on HANA DB through HANA studio and HANA cockpit. SAP HANA Studio: You can see some of the most important memory indicators on the Overview tab of the SAP HANA studio administrative perspective: SAP HANA cockpit: The SAP HANA cockpit is available at SAP Fiori Launchpad site that provides you […]

Read More

High response times for Session_Manager in ST03 and STAD

High response times for Session_Manager report/program  in ST03 and STAD Explanation: “There is another reason for high response times with the session manager. This is due to a general limitation in the statistics: the transaction is determined at the end of a dialog step. Usually the last dialog step of a transaction saves data and […]

Read More

Most Important Performance Analysis Transactions

The following is a list of the most important performance analysis transactions and brief explanation of their purpose. ST02: SAP Memory Configuration monitor checks the SAP Buffers and SAP Memory areas for problems such as swapping. It is a snapshot about the utilization of SAP shared buffers. High water marks of utilization for example extended, […]

Read More

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