Skip to Content
author's profile photo Former Member
Former Member

What are the workprocess types in Database level?

Hello,

I am recently faced one question,, what are the work process in DB level.How can we see

regards,

Balaram

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 06:48 AM

    Dear Balaram,

    Just go to Tcode SM50(Process Overview) and click on type and then press F1.There you will get all the work process present.

    SM50 work process: DIA responsible for interactive online processing. Work process for executing dialog steps in user transaction

    UPD:Used for time critical updates that needs to happen immediately. Update process for executing update requests

    ENQ : the single u2018central lock management serviceu2019 that controls the locking mechanism between the database and different application server.

    SPO : Process for executing spool requests: Responsible for servicing print request.

    BTC :Process for executing batch requests: Used for running Job in Background.

    UP: BTC - Process for executing batch requests: Used for updates that are non critical, which are delayed until resources are available to process the updates

    Message server: Responsible for communication between the different application server >an SAP instance has only 1 message server.

    Gateway: Used for transporting bigger amount of data between application servers as well as external (non-SAP) systems those communicate with SAP

    PS: You have 39 unresolved post out of the 42 you have.Please follow you posts

    Regards,

    Ashutosh

    Edited by: ashutosh singh on Aug 11, 2008 8:48 AM

    Edited by: ashutosh singh on Aug 11, 2008 9:09 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 07:53 AM

    Hi,

    There is no concept of wp in the db level every db has its own process concept, SAP has the wp concept but not the db.

    Regards,

    Vamshi.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 08:44 AM

    i am not sure of other datbase

    but in oracle for every wrok process in SAP has shadow work process in DB

    during startup work process connect to DB via these shadow work process using schma user SAP<SID>or SAPr3

    Samrat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 09:01 AM

    HI balram,

    there is no concept called wp in DB.

    this concept exsits only in sap ( as far as i know).

    as said by vamshi , for every request to the DB from the sap wp a shadow work process is created for each and every request.

    regards

    bhupesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 03:01 PM

    Benefit of doubt

    it seems he is interested in oracle background processes.

    Database writer (DBWn)

    The database writer writes modified blocks from the database buffer cache to the datafiles. Oracle Database allows a maximum of 20 database writer processes (DBW0-DBW9 and DBWa-DBWj). The DB_WRITER_PROCESSES initialization parameter specifies the number of DBWn processes. The database selects an appropriate default setting for this initialization parameter or adjusts a user-specified setting based on the number of CPUs and the number of processor groups.

    Log writer (LGWR)

    The log writer process writes redo log entries to disk. Redo log entries are generated in the redo log buffer of the system global area (SGA). LGWR writes the redo log entries sequentially into a redo log file. If the database has a multiplexed redo log, then LGWR writes the redo log entries to a group of redo log files.

    Checkpoint (CKPT)

    all modified database buffers in the system global area are written to the datafiles by DBWn. This event is called a checkpoint. The checkpoint process is responsible for signalling DBWn at checkpoints and updating all the datafiles and control files of the database to indicate the most recent checkpoint.

    System monitor (SMON)

    The system monitor performs recovery when a failed instance starts up again. In an Oracle Real Application Clusters database, the SMON process of one instance can perform instance recovery for other instances that have failed. SMON also cleans up temporary segments that are no longer in use and recovers dead transactions skipped during system failure and instance recovery because of file-read or offline errors. These transactions are eventually recovered by SMON when the tablespace or file is brought back online.

    Process monitor (PMON)

    The process monitor performs process recovery when a user process fails. PMON is responsible for cleaning up the cache and freeing resources that the process was using. PMON also checks on the dispatcher processes and server processes and restarts them if they have failed.

    Archiver (ARCn)

    One or more archiver processes copy the redo log files to archival storage when they are full or a log switch occurs.

    Recoverer (RECO)

    The recoverer process is used to resolve distributed transactions that are pending because of a network or system failure in a distributed database. At timed intervals, the local RECO attempts to connect to remote databases and automatically complete the commit or rollback of the local portion of any pending distributed transactions.

    Dispatcher (Dnnn)

    Dispatchers are optional background processes, present only when the shared server configuration is used.

    Hope it help.

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 07:56 AM

    Balaram, As far as my knowledge goes the work processes are existent only at the SAP level. Nevertheless you can see them at OS level through command DPMON. In the menu of this command you can go for option 'l' that will give you the replica of Tx SM50.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 08:52 AM

    Hi

    Follow the rules.

    Your question is answered by amit.

    And u have not closed many of your questions.

    Regards

    Bhaskar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.