Before canceling a work process, you should select the menu function To improve performance and to minimize system downtime, monitor the Oracle database daily.For an overview of system performance indicators, the Computing Center Management System provides the following monitors: The Database System Check Monitor (transaction DB16) displays an overview of all the main database functions and statuses.To display the status of the work processes of the application server where you are logged on to, select Tools Administration Monitor System monitoring Process overview (transaction code SM50).Administrators should regularly monitor the system processes to determine if the number and configuration is appropriate.These actions are the same as those recorded by the system performance monitor which is activated by default with the profile parameter stat / level.
Dialog work processes, in charge of executing interactive dialog steps¨UPD.
Spool work process in charge of the SAP spooling system (formatting and printing) Shows the current state of the work process. The process is executing a system request.¨ Waiting.
Observe that the process overview screen always offers a snapshot of the processes. The process is idle and waiting for any system request.¨ Hold. Although a Hold state can be normal, having too many processes in hold state affects the system performance.¨ Killed or Complet.
Indicates the elapsed execution time used by the work process for the dialog step that it is currently processing. When it displays a large figure, it might indicate that the process is being held in a debugging session.
Under this field the system shows the actions being performed by the running program.