Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    16

    Unanswered: What are these processes?

    Good Afternoon Guys,
    Can someone tell me in a quick sentence or two what these processes are, and what they actually do and or handle?

    Oracle.exe
    tnslsnr.exe
    sqlplus.exe

    I ask because we have been told by Oracle that we need to use OraStack and change the Default Memory used on certain Background Processes from 1MB to 500KB. We would like to review the processes and decide which ones we believe we can cut down to 500KB and which ones we want to keep at 1MB. Also, that was only three of the background processes, anyone else know where I can find a list of the Background Processes and User Processes? So that I can find out what we can fine tune the memory usage?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Sga

    Seems you do not know anything about Oracle.

    In order to cut down on memory usage by Oracle, you need a DBA to modify the 'initialization' parameters that refer to memory allocation.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Apr 2009
    Posts
    16
    The Command C:\> OraStack (Executable) Value Size

    I have been given the following example commands by Oracle to be run in the Orastack Utility to fix a ORA Error that we are recieving. As stated they gave us these examples, to modify the default memory used. Does anyone know any other Executables I can look into other then the three they provided or a location to find a list? The ones they gave us are great, yet we are looking for additional ones.

    C:\> orastack oracle.exe 500000
    C:\> orastack tnslsnr.exe 500000
    C:\> orastack sqlplus.exe 500000

    I did find Svrmgrl.exe which is the Server Manager. Any others?
    Last edited by jjester; 04-02-09 at 16:36.

Posting Permissions

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