| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: User Processes Taking 200 Megs of RAM Upon Connecting
!! 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
 |
 |