Long running background job anaysis

1) First you need to identify the job that is long running and identify details like job class, work process that is executing the job

How to identify long running background jobs:

2) Click on the job to view the display job screen. In the screen, click on job log to understand what is being performed by the job currently. This may give details like job is currently extracting some data packages or processing data packages etc

3) Identify the executing server and process id of the job from the step 1 and goto transaction SM50 of the respective executing server to view more details about the background job running.

Figure out the status of the job like On Hold or running from the process overview. If the job is On Hold, find out the reason for On Hold by examine the "Reason" column of SM50 transaction. Reason for On Hold could be due to CPIC/RFC/DEBUG/ENQ/PRIV/UPD etc.

Double click on the reason column for detailed information on the same and troubleshoot accordingly. If reason is RFC, check out which RFC it is referring to and cross check whether destination system is up or not and any other problems with that system.

    If it is ENQ, check out any lock issues like lock overflow etc
    If it is PRIV, check out for memory bottlenecks
    If it is UPD, check out whether any update issues
    If it is CPIC, check out for any network , gateway, message server and other communication problems


4) After performing step3, if you figure out job is not on Hold and it is in running state, then examine report column to identify what report/program is being executed by the job. Once you got the report/program details, figure whether it sap program or custom program and take actions accordingly.

5) Also examine Action and table columns in SM50 transaction of respective executing server to identify what is the action( roll in/roll out /Sequential read/Physical read/insert/update/delete etc)  being carried out by the job currently and what is the table on which action is being carried out.

If it is sequential read, figure out the cost of that sequential etc and consider for indexing etc. If it is physical read, check out whether there are too many swaps and consider resizing buffers accordingly. If you observed delay is due to high roll in/roll out, identify reasons for the same and tune buffer/memory parameters accordingly.

6) Once you get the table details on which action is being carried out, figure out       

        How many records are existing in the table ?
        Is this taking long time due to volume of records ?
        Are there proper indexes on the table ?(If no proper index, consider index creation  by taking help of DBA )
        Is the table having upto date statistics ? (If statistics are out of date,

              consider updating statistics of that table)


7) Consider debugging the process in SM50 ( Program/Session -> Program ->   Debugging ) to figure out the issue

8) Using ST05 or ST12, a trace can be taken for background job to figure out where exactly time is being consumed and to identify various cpu/memory bottlenecks or any buffer issues.

9) STAT/STAD transaction can be used to figure out what is the reason for high response time and actions can be taken accordingly

10) By taking help of ABAP er, even ABAP run time analysis can be done using SE30 transaction

By following the above steps, you can pin point the issue and take actions accordingly to minimize runtime of long running background jobs.

BRTOOLS-Backup issues

Ending a Backup After an Instance Failure or SHUTDOWN ABORT:

The following situations can cause a tablespace backup to fail and be incomplete:

The backup completed, but you did not run the ALTER TABLESPACE ... END BACKUP statement.
An instance failure or SHUTDOWN ABORT interrupted the backup.

Whenever crash recovery is required, if a datafile is in backup mode when an attempt is made to open it, then the database will not open the database until either a recovery command is issued, or the datafile is taken out of backup mode.

For example, the database may display a message such as the following at startup:

ORA-01113: file 12 needs media recovery
ORA-01110: data file 12: '/oracle/dbs/tbs_41.f'

If the database indicates that the datafiles for multiple tablespaces require media recovery because you forgot to end the online backups for these tablespaces, then so long as the database is mounted, running the ALTER DATABASE END BACKUP statement takes all the datafiles out of backup mode simultaneously.

In high availability situations, and in situations when no DBA is monitoring the database, the requirement for user intervention is intolerable. Hence, you can write a crash recovery script that does the following:

1. Mounts the database
2. Runs the ALTER DATABASE END BACKUP statement
3. Runs ALTER DATABASE OPEN, allowing the system to come up automatically

An automated crash recovery script containing ALTER DATABASE END BACKUP is especially useful in the following situations:

All nodes in an Oracle Real Application Clusters (RAC) configuration fail.
One node fails in a cold fail over cluster (that is, a cluster that is not a RAC configuration in which the secondary node must mount and recover the database when the first node fails).

Alternatively, you can take the following manual measures after the system fails with tablespaces in backup mode:

Recover the database and avoid issuing END BACKUP statements altogether.
Mount the database, then run ALTER TABLESPACE ... END BACKUP for each tablespace still in backup mode.

Ending Backup Mode with the ALTER DATABASE END BACKUP Statement

You can run the ALTER DATABASE END BACKUP statement when you have multiple tablespaces still in backup mode. The primary purpose of this command is to allow a crash recovery script to restart a failed system without DBA intervention. You can also perform the following procedure manually.

To take tablespaces out of backup mode simultaneously:

1. Mount but do not open the database. For example, enter:

SQL> STARTUP MOUNT

2. If performing this procedure manually (that is, not as part of a crash recovery script), query the V$BACKUP view to list the datafiles of the tablespaces that were being backed up before the database was restarted:

SQL>  SELECT * FROM V$BACKUP WHERE STATUS = 'ACTIVE';
FILE#      STATUS             CHANGE#    TIME   
---------- ------------------ ---------- ---------
        12 ACTIVE                  20863 25-NOV-02
        13 ACTIVE                  20863 25-NOV-02
        20 ACTIVE                  20863 25-NOV-02
3 rows selected.

3. Issue the ALTER DATABASE END BACKUP statement to take all datafiles currently in backup mode out of backup mode. For example, enter:

SQL> ALTER DATABASE END BACKUP;

You can use this statement only when the database is mounted but not open. If the database is open, use ALTER TABLESPACE ... END BACKUP or ALTER DATABASE DATAFILE ... END BACKUP for each affected tablespace or datafile.



Caution:

Do not use ALTER DATABASE END BACKUP if you have restored any of the affected files from a backup.




Ending Backup Mode with the SQL*Plus RECOVER Command

The ALTER DATABASE END BACKUP statement is not the only way to respond to a failed online backup: you can also run the SQL*Plus RECOVER command. This method is useful when you are not sure whether someone has restored a backup, because if someone has indeed restored a backup, then the RECOVER command brings the backup up to date. Only run the ALTER DATABASE END BACKUP or ALTERTABLESPACE ... END BACKUP statement if you are sure that the files are current.



Note:

The RECOVER command method is slow because the database must scan redo generated from the beginning of the online backup.




To take tablespaces out of backup mode with the RECOVER command:

1. Mount the database. For example, enter:

SQL> STARTUP MOUNT

2. Recover the database as normal. For example, enter:

SQL> RECOVER DATABASE

3. Use the V$BACKUP view to confirm that there are no active datafiles:

SQL>  SELECT * FROM V$BACKUP WHERE STATUS = 'ACTIVE';
FILE#      STATUS             CHANGE#    TIME   
---------- ------------------ ---------- ---------
0 rows selected.

To generate Public/Private SSH Key

ssh-keygen  using this command we can generate two keys, one public (the one you will share to the server) and the other one is private
and you shall not share with anyone.

Once the public key is copied in the ~/.ssh/authorized_keys in the server, you can login without being prompt for password.


1) As per below screen can see a prompt asking you for the location to save the key. The default location is the .ssh folder in your Home directory. You can just press “Enter” to accept the default setting.

2)Below screen is to passphrase to unlock the private key so that no one can access your remote server even if they got hold of your private key. The passphrase is optional. To leave it blank, just press “Enter”.

3)Public and private SSH key should now be generated. Open the file manager and navigate to the .ssh directory. You should see two files: id_rsa and id_rsa.pub.

4)Upload the id_rsa.pub file to the home folder of your remote host. Connect to your remote host via SSH and use the following command to move the public key to the correct location.

cat id_rsa.pub >> ~/.ssh/authorized_keys
rm id_rsa.pub

5) Remote host, open the SSH config file:

 /etc/ssh/sshd_config

6) Scroll down the config file and make sure the following attributes are set correctly.

RSAAuthentication yes
PubkeyAuthentication yes
PasswordAuthentication no

7) Finally, restart the SSH server in the remote host

sudo /etc/init.d/ssh reload

8)Now we can connect to remote host with the following command:

ssh -i /path-to-private-key username@remote-host-ip-address

# private key
openssl genrsa -out privkey.pem 2048

# public key
openssl rsa -in privkey.pem -pubout -out pubkey.pem


#To remove the pass phrase on an RSA private key:
 openssl rsa -in key.pem -out keyout.pem

#To encrypt a private key using triple DES:
 openssl rsa -in key.pem -des3 -out keyout.pem

#To convert a private key from PEM to DER format:
 openssl rsa -in key.pem -outform DER -out keyout.der

#To print out the components of a private key to standard output:
 openssl rsa -in key.pem -text -noout

#To just output the public part of a private key:
 openssl rsa -in key.pem -pubout -out pubkey.pem

#Output the public part of a private key in RSAPublicKey format:
 openssl rsa -in key.pem -RSAPublicKey_out -out pubkey.pem

DSM:XHR Status was 400 not able to deliver PRO54-DSM data

Below snote can help you to figure out this issue.
2297977 - XHR Status was <NUMBER> error 

Boot synchronization issue

1.    /usr/sap/<SID>/DV*/work/Log.bootstrap.0.log file shown the old port number after bootstrap sync.
caused by: com.sap.sql.log.OpenSQLException: Exception of type com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException caught: [jcc][t4][2
043][11550][4.22.29] Exception java.net.ConnectException: Error opening socket to server cavdbxd2/10.221.27.15 on port 61,682 with message: err
no: 111 (Connection refused), error: Connection refused (local port 36060 to address 0.0.0.0, remote port 61682 to address 10.221.27.15 (cavdbx
d2.caveriongroup.com)). ERRORCODE=-4499, SQLSTATE=08001.)/db6/jdbc/jdbcdriver.lst
2.      Unable to login Configtool due to port issues

Solutions:

1.      Login to configtool using default parameter, change the system settings – VM parameter - > Port number from existing to new 5918 – Save it
2.      rsync -avrPtl  source to target or target to source
3.      bootstrap sync again with FORCE and after successful sync, change to DETECT
4.      start the DB2, ASCS, SCS and CI
5.      check the log file /usr/sap/<SID>/DV/work/dev_server0.log (good symptoms)
6.      check the jcmon pf=instance_profile

Very useful certification Questions -15

71)Which of the following is correct in regard to R/3 clients?9

a. The R/3 client has it’s own customer data and programs which are not
accessible to other clients within the same R/3 system.
b. An R/3 client has all R/3 repository objects and client independent
customizing with all other clients in the R/3 system
c. An R/3 client shares customizing and Applcn data with other clients in the
same R/3 system
d. An R/3 client enables you to separate applcn data from customizing data


72)Which of the following strategies enables R/3 customers to avoid making
modifications to SAP Std objects?

a. Using Enhancement techs such as Program exits & menu exits
b. Modifying SAP delivered programs
c. Changing SAP std functionality using the IMG
d. Performing customizing to provide the required functionality

73)Which of the following statements are correct in regards to modifications

 a modification is a change to an SAP Std object
b. A modification must be registered using the SAP OSS (SSCR)
c. SAP recommends modification only if customer’s business meets cannot be
me by customizing enhancement techs or customer dev
d. All the above


74)Which of the following strategies enables an Enterprise to meet its business needs by
changing or enhancing R/3 functionality

a. Maintaining application data using the Various R3 Business transactions in
the SAP Std
b. Using the ABAP workbench to create the read R/3 repository objects
c. Using customizing to modify R/3 programs after obtaining an access key from
OSS
d. Using customer Exits to enhance the functionality of existing SAP Objects


75) Important statistics displayed in the Database Monitor (ST04) include:
a.              Logical reads
b.              Physical reads
c.              Data buffer size and quality
d.              Shared pool size and quality
e.              Invalidations in the R/3 table buffers

Very useful certification Questions -14

66)Which of the following statements is correct in regard to multiple R/3 clients?

a. All clients in the same R/3 system share the same R/3 repository and client
independent customizing settings
b. No more than one client in the same R/3 system should allow changes to
client independent customizing changes.
c. If a client allows for changes to client dependent customizing, the client
should also allow for changes to Client independent customizing objects
d. All of the above.


67)Which of the following activities should not be performed within a system landscape

a. Customizing & dev changes are promoted to a QAS client before being
delivered to PRD
b. The R/3 system is upgraded to a new R/3 release
c. Dev changes are mad directly in the PRD client
d. Changes are assigned to a specific role

68) Which of the following is correct in regard to R/3 repository

a. Customers can develop new repository objects using tools in the ABAP
workbench.
b. Customer developed repository objects reside in the R/3 repository alongside
std repository objects
c. Customers can create & assign new repository objects to a development class
d. All of the above


69)Which of the following statements is correct in regard to SAP Client Concept

a. All customizing settings are client independent
b. A client has unique set of applcn data
c. A client has it’s own repository objects
d. All customizing settings are client dependant


70)Which of the following components indicate that R3 is a client / server system?

a. Multiple DB’s
b. Database server
c. 3 separate hardware servers (DB, applcn & presentation server)
d. Db service, app service & presentation service

Very useful certification Questions -13

61)List the Transport Requests that are generated during Client Export and the description of each request giving the type of data exported?

Sr. No.
Request Name
Description


62)Transaction Code used for Transport Management System / Transport Organizer is: (Multiple Choice)

a.     STMS / SE09
b.    SMTS / SE10
c.     STMS / SE10
d.    STSM / SE01


63)  Which of the following are the Transport directories? (Multiple Choice)

a.     bin
b.    actlogs
c.    profile
d.   tmp
e.    log


64) Select the correct statements pertaining to TMS configuration (Multiple Choice)

a.  Several transport groups can be in a transport domain
b.    Transports can take place in the different transport groups
c.     Transport layer is not required while defining transport routes
d.    Only one transport layer can be defined in the system at any given time


65)Types of Client Specific Data? (Multiple Choice)

a.    Dictionary Data
b.    User Data
c.    Master Data
d.    Transaction Data

Very useful certification Questions -12

56)  Which log viewer can be used to display local log  file?

a)     Integrated Log Viewer
b)     Central Log Viewer
c)     Log Viewer
d)     Command Log Viewer


57) What are the development Infrastructure used SAP WEB AS JAVA?

a)      JDI
b)     IDE
c)      SAP Netweaver Studio
d)     None of the Above

58) All development objects are stored in a central repository called as

a)      DTR
b)     CBS
c)      CMS
d)     Software Logistics Process


59) Software Logistics provide?

a.     Procedure for Central User Administration
b.    Procedure for Development / Customizing
c.     Procedure for Post Installation Steps
d.    Process to help you monitor your system externally


60) The administrator wants to deactivate the import of all the requests in an import queue for a SAP System, he should set which parameter? 

a.     IMPORT_ALL_NO
b.    IMPORT_ALL_STOP
c.     NO_ALL_IMPORT
d.    NO_IMPORT_ALL

Very useful certification Questions -11

51)  State whether the following statements are True/False in case of Note Assistant?

a.   No SPDD modification adjustment required during upgrade / when importing Support Packages  
b.    SSCR request is required
c.     Changes are noted in Modification Assistant (SE95)
d.    Changes are done through SNOTES transaction



52)  The following are the components of a DB?

a.    Database Buffer
b.    Data Files
c.    SAP Kernel
d.    Special DB Processes


53) ICM (Internet Communication Manager) is a Process (True/False) ?



54) What are the two managers in UME?

Ans:- Persistent Manager
      Replication Manager



55) Different  Types of Data Partitioning in UME.?

a) Attribute base
b) User Base
c) Client Base
d) Type Base

Very useful certification Questions -10

46. ALE customizing is done using:
a.          the BABI generator
b.          transaction SALE
c.          RSNAST00
d.          an external warehouse management (WM) system
e.          SAP’s Business Framework


47. TRFC’s: 

a.  are a part of SAP’s functionality. 
b.  are used by ALE for communication between sender and receiver.
c.  require FTP.
d.  are called transactional since a number of function modules are allowed to be bundled into a single LUW.
e.  are only used by ALE for customizing integrity checks

48.  IDOC’s can be created:
a.               only via transaction SPRO.
b.               by change pointers.
c.                by message entry for deferred processing.
d.               directly.
e.               only via transaction BALE.


49.  Which of the following are IDOC processing options? :
a.              Dispatch Control.
b.              FTP.
c.              Processing mode.
d.              Unit transfer type.
e.              LUW.



50. Which of the following is not contained in R/3 DB?

a. The R/3 Repository
b. The R/3 kernel
c. Customer Data
d. Transaction data
e. Customizing Data
f. The ABAP dictionary

Very useful certification Questions -9

41.Which of the following statements is correct in regard to setup of 3-system landscape

a. There is only R/3 DB for the system landscape
b. One client should allow for the automatic recording of client dependent
customizing and client independent changes.
c. All R/3 systems have the same System ID (SID)
d. All clients must have unique client numbers


42. Which of the following benefits does the 3-system landscape recommended by SAP
have?

a. Customizing and dev, testing, and prod activities take place in separate DB
environments and do not affect one another
b. Changes are tested in the QAS system and imported in the PRD system only
after verification
c. Client independent changes can be made in the DEV system w/o immediately
affecting the PRD client
d. All of the above

43.Which of the following statements are correct in regard to IMG?

a. The IMG consists of series of customizing activities for defining a Companies
Business process
b. The IMG is a online resource providing the necessary info and steps to help
you implementing the R/3 applcn Modules
c. IMG is client independent
d. All of the above

44.Which of the following statements is correct in regard to SAP Client Concept

a. All customizing settings are client independent
b. A client has unique set of application data
c. A client has it’s own repository objects
d. All customizing settings are client dependant


45. Which of the following are true?

a.         For performance reasons the TRFC queue should never be reorganized.
b.         The TRFC queue consists of tables on both the sender and receiver of the communication.
c.         The TRFC queue cannot be monitored in R/3 since it is an external process.
d.         TRFC refers to transactional RFC’s.
e.         IDOC transfers between R/3 systems using TRFC’s do not require a logon and password.

Very useful certification Questions -8

36) Which business logic component runs on the server?

a)      Applets
b)     Enterprise Java Beans
c)      Servlets
d)     JSP


37) Which tool can define password rule?

a)     ABAP User management
b)     CUA
c)     UME Console
d)     Visual Administrator

38) SQL statement given –screen dump of ST04à detail analysisà SQL request
& ST04 main screen dump-  Single choice only

To find SQL statement is expensive or not
a)buffer gets > 5% Total Reads  so Statement is expensive
b)buffer gets > 5% Physical Reads  so Statement is expensive
c)Statement is not expensive
d)Very high buffer gets so statement is expensive
e)High no of execution so statement is expensive

39)Which of the following files are required for transport in to QAS system

a)transport.pfg
b)DOMAIN_DEV.cfg
c)TP_DOMAIN_<SID>.pfl
d)tpimport.pfg


40) Which is the sapbda & brarchive parameter file ?

Very useful certification Questions -7

31) Connection b/n a Dispatcher and Server is called as

a)      Message Server Communication
b)     Lazy Communication
c)      Session Communication
d)     Cluster Communication

32) What are the user stores provided by SAP WEB AS JAVA

a)      UME
b)     UDDI
c)      Database
d)     None of the Above

33) Which manager is first started in SAP WEB AS JAVA?

a)      Cluster Manager
b)     Log Manager
c)      Application Manager
d)     Thread Manager

34)  Which trace works on Byte Code?

a) SAT
b) CUA
c) JARM
d) Application Trace


35)  Severities of Log Controller can be changed by

a) Log Viewer
b) Config tool
c) Visual Administrator
d) Log Configurator Service

Very useful certification Questions -6

26.     Parameter rdisp/mshost found in which profile?

          a) default
          b) start profile
          c) Central instance –instance profile
          c) Application Instance – instance profile

27.   Parameter rdisp/vbname found in which profile

      a)default
      b)start profile
      c)Central instance – instance profile
     c)Application Instance – instance profile

28. Program ZZSLOW is there and it access ZZTABLE .And want to improve the performance

a) create an index on ZZTABLE and this is preferred over option of tuning SQL statement
b) Creating an index would definitely improve the performance
c)Tuning the SQL statement would solve the performance and is preferred over Index Creation
d)Optimizer may choose  wrong index after creation  of the index


29.Locking Process of SAP Transactions is carried out by?

a.    Enqueue
b.    Dialog
c.    Spool
d.    Background

30.Spool Data is stored in which table ?

a.    TSP01
b.    TSP03
c.    TST03
d.    TSP02

Very useful certification Questions -5

21.Which parameter keeps the incoming HTTP request in store for SAP WEB AS Java?

22.While installing Support Packs through Sapinst for SAP WEB AS JAVA J2EE engine should be stopped?

True
False

23.Which of the following is NOT a profile that can be used for client copies? 

a.     SAP_USER – User master records
b.    SAP_ACUST – Application & Customizing data
c.     SAP_EXBC – Client dependent/independent Customizing & Users
d.    SAP_MAST – Master data only

24. Which tool is used for carrying out R/3 Upgrade?
a.     PREPARE
b.    SPAU
c.     R3UP
d.    SPDD

25.  The logs generated by ‘tp’ tool are:?

a.     tp system log

b.    Transport Step Monitor

c.     ULOG

d.    <Source SID><Import Step><6 digit>.<Target SID>

Very useful certification Questions -4

16. In 3 system landscape from where the request can be imported in QAS system.

a.     Only from DEV
b.    Only from QAS
c.     Only from PRD
d.    From all three systems


17. While importing Support Packages you need to do the following.  State True/False:

a.    Update SPAM/SAINT update with latest version 
b.    Client 000 is not to be used for importing 
c.    Import must always be performed during peak operations  
d.    Aborted packages must be kept untouched 

18.  CCMS Monitoring Infrastructure consists of

a.    Data Migration
b.    Data Collection
c.    Data Storage
d.    Data Archiving

19.How many server socket listner and new connection can be processed by Default in SAP WEB AS JAVA

a) 5 S.S.L.   and 10    new connections/sec
b) 10 S.S.L. and 350  new connections/sec
c) 5 S.S.L.   and 650  new connections/sec
d) 5 S.S.L.   and 1000 new connections/sec

20. JRE Consists of

a)     Class Loader & Byte Code Verifier
b)     Byte Code Verifier & JVM
c)     JVM,Class Loader & Byte Code Verifier
d)     J2SDK

Very useful certification Questions -3

11.From SAP System which process is used to start External Command / Program

a.    sapxpg
b.    sapevt
c.    disp+work.exe
d.    gwrd


12. Access Method is: (Single Choice)

a.    Connection between Dialog & Spool Work Process
b.    Connection between OS Spool and the Actual Printer
c.    Connection between Spool Work Process and OS Spool
d.    Connection between Spool Request & Output Request


13.SAP System has a Operation Mode configured.  There are performance issues in the System and finally the BASIS administrator 
   adds RAM (Physical Memory) to the Server.  He configures few parameters and increases the no. of work processes.    
   The BASIS administrator needs to redefine Operation Mode to take effect of the new processes –(True/False)

14.Printer Name in SAP is not case sensitive (True / False)


15.The standard System Landscape recommended by SAP is

a.    DEV, QAS & PRD systems on one Server
b.    DEV & QAS on one server and PRD on another server
c.    DEV, QAS & PRD on separate server
d.    DEV on one server and QAS & PRD on one server

Very useful certification Questions -2

6. What will happen if a background job is running and the Operation Mode Switch is activated in between?

a. The job will be cancelled
b. The job will be put in Suspended state
c. The Job will continue to run and once it finishes then the Operation Mode Switch will occur
d. The Operation Mode will happen the next day

7.What is the order in which the Profile files are read during the system start? 

a. DEFAULT, INSTANCE & START
b. INSTANCE, DEFAULT & START
c. START, INSTANCE, DEFAULT
d. START, DEFAULT, INSTANCE

8.What is the Profile Parameter name used to set the Trace Level in SAP system? 

a. rdisp/trace_level
b. rdisp/tracelevel
c. rdisp/LEVEL
d. rdisp/TRACE

9.State whether the followings statements are True or False:

a. W Gate should always be on Web Server
b. A Gate should always be coupled with W Gate
c. SAP System should be installed on NT Operating System
d. Dual Host Installation in ITS means A Gate and W Gate are on the same host



10.‘Event-Based Job Scheduler’ runs on every instance (True / False)

Very useful certification Questions -1

These questions are gathered from who already appeared exam and some of the questions from google.

Here i am posting which will help who wants prepare certification exams. All the best.
1)   What is the name of the DEFAULT Profile in SAP System? (Single Choice)

a.     DEFAULT.imp
b.    DEFAULT.prof
c.     DEFAULT.pfl
d.    DEFAULT.ini


2) Is data written to the Oracle transaction logs (redo logs) before or after the information is written in
the database files?

A. Before
B. After
C. Simultaneously
D. The priority and sequence of database writes and transaction log writes is controlled by
the parameter "dblg_after" in the ORACLE initialization file.
E. Randomly, sometimes before, sometimes after.


3)     What is SAP Instance? (Single Choice)

a.     Group of Database that make a system runnable
b.    Group of SAP instances that make a system runnable
c.     Group of Services that make a system runnable
d.    Group of O/S level Files that make a system runnable


4) Transaction Code used for Profile Maintenance / Job overview is: (Single Choice)
a.     PFCG / SM37
b.    RZ11 / SM36
c.     RZ10 / SM37
d.    RZ03 / SM37

5) What is the primary function of the $ORACLE HOME/saparch directory?

A. The saparch directory is a work area for the R/3 database utilities.

B. The saparch directory is a work area for the R/3 Instance tasks.

C. The saparch directory is used as the holding area for online database backups instead of

writing them to tape.

D. The saparch directory holds the archived database log files.

E. The saparch directory contains the current database transaction log files.