Shadow Process Memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Shadow Process Memory

  1. #1
    Join Date
    Aug 2001
    Posts
    134

    Lightbulb Shadow Process Memory

    What is a shadow process memory, any view i can check this memory ?

  2. #2
    Join Date
    Nov 2002
    Location
    Columbia, sc
    Posts
    9
    Well, I cant answer your entire question off hand, but I can tell you that an Oracle Shadow Process is a user process in *nix. Oracle forks an existing user process when a new user connects to the database or a background process starts up. So I would say that to check the memory used by these shadow processes you should check the amount of memory used by user processes in your database.

    Try this for a script to check the memory usage...

    http://www.orafaq.net/archive/oracle.../07/132427.htm

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    shadow processes are server processes not user processes

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Oracle shadow or server processes: Shadow processes work directly with the database instance to carry out the requests from the user processes. Shadow processes may be dedicated to a single user process or part of a multi-threaded server (MTS) configuration. The shadow processes are named oracleSID, where SID is the value of ORACLE_SID. For example, any shadow process connected to the database instance "DEV" would be named "oracleDEV."

    See more on MetaLink Note 153655.1 (script to check memory usage included).

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by stecal

    See more on MetaLink Note 153655.1 (script to check memory usage included).
    Stecal :

    Am new to this forum site....u all giv the meta link note no...

    wass this & where do i get it.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    abhay,
    Metalink is Oracle Support Website, the access of which you can have only if you have Oracle software license. If you have purchased Oracle Software, you can set up your user account in metalink website to get all information about the Bugs, Fixes, Forums and Notes(like the ones you see above).

    Thanks
    -- Dilip

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width