FAQ
I type 'top' in solaris and see many processes running:

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND

20408 oratst 1 52 0 190M 171M sleep 0:02 2.35% oracle
20410 oratst 1 54 0 190M 171M sleep 0:02 1.14% oracle
20480 root 1 0 0 2320K 1288K cpu/1 0:00 0.60% top
20479 oratst 1 0 0 30M 9232K sleep 0:00 0.31% oracle
20477 oratst 1 0 0 30M 9232K sleep 0:00 0.23% oracle
20471 oratst 1 0 0 30M 9232K sleep 0:00 0.18% oracle
20473 oratst 1 0 0 30M 9232K sleep 0:00 0.17% oracle

Should I be worried about what 190M is as a size, given that there are
several hundred of these processes - it sounds like a lot of memory being
used - how can I change this?

Search Discussions

  • Rachel Carmichael at Nov 17, 2000 at 1:56 pm
    You don't need to worry... the 190M includes the shared memory of the SGA
    for all processes that are connected to the database. Your TRUE process
    memory is much smaller
    From: Raj Gopalan
    Reply-To: ORACLE-L_at_fatcity.com
    To: Multiple recipients of list ORACLE-L
    Subject: Top on Sun Solaris
    Date: Fri, 17 Nov 2000 03:30:25 -0800

    I type 'top' in solaris and see many processes running:


    PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
    20408 oratst 1 52 0 190M 171M sleep 0:02 2.35% oracle
    20410 oratst 1 54 0 190M 171M sleep 0:02 1.14% oracle
    20480 root 1 0 0 2320K 1288K cpu/1 0:00 0.60% top
    20479 oratst 1 0 0 30M 9232K sleep 0:00 0.31% oracle
    20477 oratst 1 0 0 30M 9232K sleep 0:00 0.23% oracle
    20471 oratst 1 0 0 30M 9232K sleep 0:00 0.18% oracle
    20473 oratst 1 0 0 30M 9232K sleep 0:00 0.17% oracle

    Should I be worried about what 190M is as a size, given that there are
    several hundred of these processes - it sounds like a lot of memory being
    used - how can I change this?

    Thanks

    Raj
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Raj Gopalan
    INET: raj.gopalan_at_netdecisions.co.uk

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

    Share information about yourself, create your own public profile at
  • John Kanagaraj at Nov 18, 2000 at 6:12 am

    Rachel Carmichael wrote:

    You don't need to worry... the 190M includes the shared memory of the SGA
    for all processes that are connected to the database. Your TRUE process
    memory is much smaller
    From: Raj Gopalan
    Reply-To: ORACLE-L_at_fatcity.com
    Hi Raj,

    Also keep in mind that of the non SGA part of the memory, a large
    portion of the code is also part of the shared libraries (i.e. the
    re-entrant code of both the program code as well as the system's shared
    library code). Ultimately, what you will have to be worried about is the
    unshared portion of the Resident Code/Data sizes...

    John Kanagaraj
    http://www.geocities.com/john_sharmila

    Disclaimer : The opinions expressed above are my own and do
    not reflect those of MFI or its associates

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 17, '00 at 11:28a
activeNov 18, '00 at 6:12a
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase