!! 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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).