SAPTechArena

SAP lock is set by the executing workprocess when a user/job wants a change access to data. Whenever a lock to be set the respective workprocess checks in the locktable whether a respective lock conflicts the existing entries in the locktable. If so, a lock is refused. If there is no conflict, then a lock is set. There are different types of locks : Write locks (E) : This...

A work processes is used to execute a particular type of job in an sap system. There are different types of workprocesses as mentioned below : DIA   (Dialog workprocess) :        Used for execution of dialog steps triggered by active users. For every dispatcher atleast 2 dialog workprocesses to be configured UPD  (Update workprocess) :   ...

1) Goto Transaction SE38 and run report RSSPACECHECK as shown below In the next step, please provide the client for which the size to be determined and please make sure below settings are kept and run the report. The output of this report lists the size of the...

You should run the following in SAP command field. Note: Resetting of the buffers could change the performance of the entire system /$DYNP - To reset the screen buffer of the application server /$SYNC - This command resets the buffers of the application server /$CUA   - This resets the CUA buffer of the application server /$TAB   - This resets...

Go to --> se37 Function module Run this module to Lock and Unlock Client 1. SCCR_LOCK_CLIENT (for the client) 2. SCCR_UNLOCK_CLIENT (to unlock the client)                                          This function is used to lock/unlock...

Table Description T000 List of clients T001 Company Codes TSTC Definition of tcodes TOBJ Definition of Authorization objects TACTZ Valid activities TSTCP Parameters for Transactions TPGP Authorization Groups for Programs TBRG Authorization Groups for Tables TDDAT Table to Authorization group mapping TNRO Definition of number range objects TSTCA Values...

Steps when the database state is down:1. Login to sqlplus  -sqlplus /nolog  -connect / as sysdba2. The db must be mounted EXCLUSIVE and not open for operation  -startup mount;3. Check the log mode status of the database  -select log_mode from v$database;4. Setting it to noarchivelog mode  -alter database noarchivelog;5. Setting db open for user operation ...

How to check character set in OracleOne of the requirements for samePage is that the character set should be UTF-8.You can either check with your DBA or run the following SQL to determine whether your database character set is UTF-8.  SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ; It should return the value AL32UTF8. Another option is to run the following...