SAP SUM Phases: A Step-by-Step Guide

SAP

SAP SUM Introduction Upgrading an SAP system is a complex undertaking that requires careful planning and execution. SAP’s Software Update Manager (SUM) tool simplifies this process, providing a structured approach to system upgrades, EHP updates, S/4HANA conversions, and more. In this blog post, we’ll delve into the key phases and…

Read More

SAP HANA SQL Commands for Auditing/SOX

SAP

By using SAP HANA SQL Commands, we can perform following job Finding index and primary keys of tables SELECT IFNULL(CONSTRAINT,’NUNIQUE’), INDEX_NAME,COLUMN_NAME FROM INDEX_COLUMNS WHERE SCHEMA_NAME = ‘%s’ AND TABLE_NAME = ‘%s’ ORDER BY INDEX_OID,POSITION Show details of users that have been logged-in select * from “SYS”.”USERS” where “LAST_SUCCESSFUL_CONNECT” is not…

Read More

Oracle BRTOOLS SSFS Configuration

SAP

If you are still managing an SAP system with an Oracle database. If so, understanding how to configure BRTOOLS SSFS (Secure Storage in File System) is crucial. SSFS provides a secure way to store sensitive data such as database passwords. Let’s dive into the key steps: Avoid using OPS$ mechanism, locking/deleting OPS$…

Read More

Oracle Database 19c | Enable Automatic Indexing

SAP

What is Automatic Indexing? Automatic Indexing is a feature introduced in Oracle 19c that automates index management. It analyzes workloads, recommends creating or dropping indexes, and can even implement those recommendations. This can improve query performance without requiring a DBA to manually manage indexes. Pros of Enabling Automatic Indexing: Improved…

Read More