Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Memory process used by oracle
Hi!
I have a problem with Oracle 8.1.5 (Solaris)... he used a lot of memory that has not been used.
Is possible tunning this??
Thx
This is the capture:
$ ps -ef |grep ora_
oracle86 16288 1 4 11:11:34 ? 27:27 ora_s000_boxv2 oracle86 16290 1 0 11:11:34 ? 0:52 ora_s001_boxv2 oracle86 16298 1 0 11:11:34 ? 0:00 ora_s005_boxv2 oracle86 16302 1 0 11:11:34 ? 0:00 ora_s007_boxv2 oracle86 16300 1 0 11:11:34 ? 0:00 ora_s006_boxv2 oracle86 16278 1 0 11:11:33 ? 0:06 ora_dbw0_boxv2 oracle86 16280 1 0 11:11:33 ? 0:08 ora_lgwr_boxv2 oracle86 16314 1 0 11:11:34 ? 0:01 ora_arc0_boxv2 oracle86 16306 1 0 11:11:34 ? 0:00 ora_s009_boxv2 oracle86 16286 1 0 11:11:34 ? 0:00 ora_reco_boxv2 oracle86 16276 1 0 11:11:33 ? 0:00 ora_pmon_boxv2 oracle86 16304 1 0 11:11:34 ? 0:00 ora_s008_boxv2 oracle86 16292 1 0 11:11:34 ? 0:01 ora_s002_boxv2 oracle86 16282 1 0 11:11:34 ? 0:07 ora_ckpt_boxv2 oracle86 16310 1 1 11:11:34 ? 18:08 ora_d001_boxv2 oracle86 16308 1 2 11:11:34 ? 17:52 ora_d000_boxv2 oracle86 16296 1 0 11:11:34 ? 0:00 ora_s004_boxv2 oracle86 16312 1 1 11:11:34 ? 17:09 ora_d002_boxv2 oracle86 16294 1 0 11:11:34 ? 0:00 ora_s003_boxv2 oracle86 16284 1 0 11:11:34 ? 0:01 ora_smon_boxv2
Address Kbytes Resident Shared Private Permissions Mapped File 00010000 23264 15408 11200 4208 read/exec oracle 016D6000 208 208 144 64 read/write/exec oracle 0170A000 1144 1136 - 1136 read/write/exec [ heap ] 80000000 115264 115264 - 115264 read/write/exec/shared [shmid=0x44d] EEFB0000 16 16 16 - read/exec libmp.so.2 EEFC2000 8 8 - 8 read/write/exec libmp.so.2 EEFD0000 88 80 80 - read/exec libm.so.1 EEFF4000 8 8 - 8 read/write/exec libm.so.1 EF000000 4872 3056 1240 1816 read/exec libjox8.so EF4D0000 176 176 - 176 read/write/exec libjox8.so EF4FC000 16 - - - read/write/exec [ anon ] EF510000 8 8 - 8 read/write/exec [ anon ] EF520000 8 8 8 - read/exec libkstat.so.1 EF530000 8 8 - 8 read/write/exec libkstat.so.1 EF540000 24 24 24 - read/exec libposix4.so.1 EF554000 8 8 - 8 read/write/exec libposix4.so.1 EF560000 24 24 24 - read/exec libaio.so.1 EF574000 16 16 - 16 read/write/exec libaio.so.1 EF580000 600 600 600 - read/exec libc.so.1 EF624000 32 32 - 32 read/write/exec libc.so.1 EF62C000 8 8 - 8 read/write/exec [ anon ] EF640000 16 16 16 - read/exec libc_psr.so.1 EF650000 8 8 8 - read/exec libsched.so.1 EF660000 8 8 - 8 read/write/exec libsched.so.1 EF670000 8 8 8 - read/write/exec/shared [ anon ] EF680000 456 456 400 56 read/exec libnsl.so.1 EF700000 40 40 - 40 read/write/exec libnsl.so.1 EF70A000 16 8 - 8 read/write/exec [ anon ] EF720000 32 32 32 - read/exec libsocket.so.1 EF736000 8 8 - 8 read/write/exec libsocket.so.1 EF738000 8 - - - read/write/exec [ anon ] EF740000 8 8 - 8 read/write/exec [ anon ] EF750000 32 16 8 8 read/exec libdsbtsh8.so EF766000 8 8 - 8 read/write/exec libdsbtsh8.so EF768000 8 - - - read/write/exec [ anon ] EF770000 8 8 8 - read/exec libwtc8.so EF780000 8 8 - 8 read/write/exec libwtc8.so EF790000 8 8 8 - read/exec libskgxp8.so EF7A0000 8 8 - 8 read/write/exec libskgxp8.so EF7B0000 8 8 8 - read/exec libdl.so.1 EF7C0000 128 128 128 - read/exec ld.so.1 EF7EE000 16 16 - 16 read/write/exec ld.so.1 EFFEE000 72 72 - 72 read/write/exec [ stack ]-------- ------ ------ ------ ------ total Kb 146712 136968 13960 123008
load averages: 0.25, 0.25, 0.25 07:31:1469 processes: 68 sleeping, 1 on cpu
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
19663 root 16 58 0 155M 140M sleep 6:02 0.10% java 16288 oracle86 1 48 0 147M 129M sleep 27:36 4.17% oracle 16278 oracle86 1 58 0 146M 123M sleep 0:06 0.00% oracle 16312 oracle86 1 58 0 146M 122M sleep 17:11 1.03% oracle 16310 oracle86 1 43 0 146M 122M sleep 18:12 5.77% oracle 16308 oracle86 1 58 0 146M 122M sleep 17:53 1.39% oracle 16276 oracle86 1 59 0 146M 123M sleep 0:00 0.00% oracle 16314 oracle86 1 59 0 146M 122M sleep 0:00 0.00% oracle 16282 oracle86 1 59 0 146M 122M sleep 0:07 0.01% oracle 16280 oracle86 1 59 0 146M 122M sleep 0:07 0.00% oracle 16290 oracle86 1 58 0 146M 126M sleep 0:52 0.06% oracle 16284 oracle86 1 58 0 146M 125M sleep 0:01 0.00% oracle 16286 oracle86 1 59 0 146M 125M sleep 0:00 0.00% oracle 8574 daemon 1 48 0 146M 124M sleep 0:00 0.09% oracle 16292 oracle86 1 58 0 146M 125M sleep 0:00 0.00% oracle 16294 oracle86 1 59 0 146M 123M sleep 0:00 0.00% oracle 16296 oracle86 1 59 0 146M 123M sleep 0:00 0.00% oracle 16302 oracle86 1 59 0 146M 123M sleep 0:00 0.00% oracle 16304 oracle86 1 59 0 146M 123M sleep 0:00 0.00% oracle 16306 oracle86 1 59 0 146M 123M sleep 0:00 0.00% oracle 16300 oracle86 1 59 0 146M 123M sleep 0:00 0.00% oracle 16298 oracle86 1 59 0 146M 122M sleep 0:00 0.00% oracleReceived on Wed Jun 26 2002 - 03:23:39 CDT