!! Please do not post Off Topic to this List !!
pmap isn't lying. This entry of your output is related
to the shared memory segment:
80000000 222376 222376 - 222376
read/write/exec/shared [ ism
shmid=0x65 ]
Match the id with the output of the ipcs -ma
Oracle is not all the helpful with could want, however
it has some statistics as session uga memory/session
pga memory and the highwatermarks: session uga memory
max/ session pga memory max from v$sysstat that could
bring a little help.
Regards.
- tcarlson_at_tripos.com wrote:
> !! 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).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.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 - 14:44:13 CDT