Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: User Processes Taking 200 Megs of RAM Upon Connecting

RE: User Processes Taking 200 Megs of RAM Upon Connecting

From: <tcarlson_at_tripos.com>
Date: Thu, 13 Sep 2001 09:51:46 -0700
Message-ID: <F001.0038D61B.20010913082524@fatcity.com>

!! Please do not post Off Topic to this List !!

Thanks for all who have replied. My lack of Unix understanding is becoming very clear. Please bear with me. If top is showing the SGA's memory added to the user's allocation, why does pmap show what it does? Oracle has been less than helpful. Any ideas about this?

SQL> show sga

Total System Global Area 226820256 bytes

Fixed Size                    73888 bytes
Variable Size              76734464 bytes
Database Buffers          149831680 bytes
Redo Buffers                 180224 bytes

unscs02> top -U oracle
top: no termcap entry for a `iris-ansi-net' terminal load averages: 0.04, 0.04, 0.05 16:11:08 81 processes: 80 sleeping, 1 on cpu

Memory: 512M real, 77M free, 315M swap in use, 569M swap free

   PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND

  2163 oracle     1  58    0  254M  228M sleep   0:00  0.05% oracle
  2164 oracle     1  58    0 1368K  936K cpu0    0:00  0.05% top
  1904 oracle     1  48    0 1896K 1184K sleep   0:00  0.02% ksh
   935 oracle    11  58    0  255M  226M sleep   0:07  0.00% oracle
   306 oracle     1  58    0 9664K 4856K sleep   0:01  0.00% tnslsnr
  2120 oracle     1   2    0  254M  227M sleep   0:00  0.00% oracle
  2039 oracle     1  10    0  254M  227M sleep   0:00  0.00% oracle
  2109 oracle    11  58    0  256M  230M sleep   0:00  0.00% oracle
  1651 oracle     1  58    0  254M  228M sleep   0:00  0.00% oracle
   937 oracle     1  58    0  254M  227M sleep   0:00  0.00% oracle
   939 oracle     1  58    0  254M  227M sleep   0:00  0.00% oracle
   949 oracle     1  58    0  254M  224M sleep   0:00  0.00% oracle
   943 oracle     1  59    0  254M  228M sleep   0:00  0.00% oracle
   931 oracle    16  59    0  256M  226M sleep   0:00  0.00% oracle
   933 oracle    11  59    0  256M  226M sleep   0:00  0.00% oracle

sunscs02> pmap -x 2163
2163: oraclesunscs02 (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))

  Address   Kbytes Resident Shared Private Permissions       Mapped File
00010000   26184   12136    9544    2592 read/exec         oracle
019B0000     264     264     200      64 read/write/exec   oracle
019F2000     216     208       -     208 read/write/exec     [ heap ]
80000000  222376  222376       -  222376 read/write/exec/shared  [ ism 
shmid=0x65 ]
FEA10000      16      16       8       8 read/exec         libmp.so.2
FEA24000       8       8       -       8 read/write/exec   libmp.so.2
FEA30000     112      40      16      24 read/exec         libelf.so.1
FEA5C000       8       8       -       8 read/write/exec   libelf.so.1
FEA70000      16      16       8       8 read/exec         libkvm.so.1
FEA84000       8       8       -       8 read/write/exec   libkvm.so.1
FEA90000      88      64      48      16 read/exec         libm.so.1
FEAB4000       8       8       -       8 read/write/exec   libm.so.1
FEAC0000       8       8       -       8 read/exec         libkstat.so.1
FEAD2000       8       8       -       8 read/write/exec   libkstat.so.1
FEAE0000      24      24      16       8 read/exec         librt.so.1
FEAF6000       8       8       -       8 read/write/exec   librt.so.1
FEB00000     664     600     528      72 read/exec         libc.so.1
FEBB6000      24      24       -      24 read/write/exec   libc.so.1
FEBBC000       8       8       -       8 read/write/exec   libc.so.1
FEBD0000      16      16       8       8 read/exec         libc_psr.so.1
FEBE0000      32      32      24       8 read/exec         libaio.so.1
FEBF8000       8       8       -       8 read/write/exec   libaio.so.1
FEC00000    4656    1528     968     560 read/exec         libjox8.so
FF09A000     160     136       -     136 read/write/exec   libjox8.so
FF0C2000       8       -       -       - read/write/exec   libjox8.so
FF0D0000       8       8       -       8 read/write/exec     [ anon ]
FF0E0000       8       8       -       8 read/exec         libsched.so.1
FF0F2000       8       8       -       8 read/write/exec   libsched.so.1
FF100000     552     448     408      40 read/exec         libnsl.so.1
FF19A000      32      32       -      32 read/write/exec   libnsl.so.1
FF1A2000      32      16       -      16 read/write/exec   libnsl.so.1
FF1B0000       8       8       8       - read/write/exec/shared   [ anon ]
FF1C0000      24      24      16       8 read/exec         libgen.so.1
FF1D6000       8       8       -       8 read/write/exec   libgen.so.1
FF1E0000      40      40      32       8 read/exec         libsocket.so.1
FF1FA000       8       8       -       8 read/write/exec   libsocket.so.1
FF200000     912     160     136      24 read/exec         liblsm.so
FF2F2000      48      40       -      40 read/write/exec   liblsm.so
FF2FE000     504       -       -       - read/write/exec   liblsm.so
FF380000       8       8       -       8 read/write/exec     [ anon ]
FF390000       8       8       -       8 read/exec         libskgxp8.so
FF3A0000       8       8       -       8 read/write/exec   libskgxp8.so
FF3B0000       8       8       -       8 read/exec         libdl.so.1
FF3C0000     128     128     120       8 read/exec         ld.so.1
FF3E0000       8       8       -       8 read/write/exec   ld.so.1
FFBE8000      32      32       -      32 read/write/exec     [ stack ]
-------- ------ ------ ------ ------ total Kb 257320 238560 12088 226472

At 06:15 AM 9/13/01 -0800, you wrote:
>!! Please do not post Off Topic to this List !!
>
>Top shows the SGA size with each process, using pmap you can actually see
>the break down.
>
>
>With a 200Mb SGA (or slightly less actually) you will see 200Mb tied to each
>process, plus the process memory.
>
>Unfortunately I have not seen a tool as useful as top which has
>distinguished this.
>
>"Do not criticize someone until you walked a mile in their shoes, that way
>when you criticize them, you are a mile a way and have their shoes."
>
>Christopher R. Spence
>Oracle DBA
>Phone: (978) 322-5744
>Fax: (707) 885-2275
>
>Fuelspot
>73 Princeton Street
>North, Chelmsford 01863
>
>
>
>-----Original Message-----
>Sent: Wednesday, September 12, 2001 10:20 PM
>To: Multiple recipients of list ORACLE-L
>
>Hey gang. New job, new problems. I have just been handed a 8.1.7.0.0
>database on solaris 5.8 with a little problem.
>Everything time a client connects, regardless of type, the OS dedicates
>over 200+ Megs of RAM (as shown by Top) to the user process. Naturally,
>this is running the box out of memory. The init.ora has the following
>parameters:
>db_block_size = 8192
> db_block_buffers = 9652
> large_.pool_size = 2000000
>sort_area_size=65342
>sort_area_retained_size=65342
>
>There is nothing from any logs or trace files that helps. Plus, I am new to
>UNIX.
>Any help you could offer would be greatly appreciated.
>
>Todd Carlson
>www.tripos.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: tcarlson_at_tripos.com
>
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Christopher Spence
> INET: cspence_at_FuelSpot.com
>
>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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: tcarlson_at_tripos.com

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).
Received on Thu Sep 13 2001 - 11:51:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US