Re: Size of oracle background processes

On Wed, 29 Sep 1999 17:35:18 GMT, Anil Kamath <akk_16_at_yahoo.com> wrote:

>
>
>Its not the size of the SGA itself..I know the SGA is shared by
>all the Oracle background processes. The problem is that
>when I do a "top" on the solaris box each of the background SQL
>processes have a resident size of approximately the same size of the
>SGA..This will create too much swapping on the
>box Why should the size of these background processes be so
>huge. What is the connection between the resident size of the background
>processes and the SGA, Shouldn't they be independent of each other.

top will show 700 Megs for every process running load averages: 3.72, 3.61, 3.54
11:54:03
83 processes: 80 sleeping, 3 on cpu
CPU states: 32.8% idle, 42.5% user, 17.7% kernel, 7.0% iowait, 0.0% swap
Memory: 6144M real, 95M free, 3648K swap in use, 1497M swap free

  PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND

  832 oracle    11 -14    0 3002M 2998M cpu/1 430:44  7.75% oracle
  876 oracle     1 -15    0 1282M 1277M sleep 301:38  6.59% oracle
  834 oracle     1  -4    0 2998M 2994M sleep 247:30  5.67% oracle
  878 oracle     1  -3    0 1282M 1277M sleep 121:50  3.92% oracle
  846 oracle     1  -3    0 2998M 2992M cpu/9 146:30  3.74% oracle
  836 oracle    11   7    0 3003M 2999M sleep 140:02  3.38% oracle
  844 oracle     1   7    0 2998M 2992M sleep 147:51  3.05% oracle
  848 oracle     1  -3    0 2998M 2992M sleep 156:40  2.84% oracle
  842 oracle     1  17    0 2998M 2992M sleep 149:05  2.35% oracle
  886 oracle     1  18    0 1282M 1275M sleep  87:54  2.17% oracle
  880 oracle     1   8    0 1282M 1277M sleep  44:47  2.08% oracle
  888 oracle     1   8    0 1282M 1275M sleep  39:05  2.00% oracle
  884 oracle     1   8    0 1282M 1275M sleep  87:30  1.83% oracle
  890 oracle     1  31    0 1282M 1275M sleep  82:59  1.75% oracle

This sums up to over 30Gig, and our real memory is only 6Gig 1SVRMGR> select spid, program from v$process; SPID PROGRAM

--------- ------------------------------------------------
          PSEUDO                                          
864       oracle_at_smaug (PMON)                             
866       oracle_at_smaug (DBWR)                             
868       oracle_at_smaug (LGWR)                             
870       oracle_at_smaug (CKPT)                             
872       oracle_at_smaug (SMON)                             
874       oracle_at_smaug (RECO)                             
876       oracle_at_smaug (S000)                             
878       oracle_at_smaug (S001)                             
880       oracle_at_smaug (S002)                             
882       oracle_at_smaug (D000)                             
884       oracle_at_smaug (D001)                             
886       oracle_at_smaug (D002)                             
888       oracle_at_smaug (D003)                             
890       oracle_at_smaug (D004)                             
6053      oracle_at_smaug (TNS V1-V2)    

You can see that you can map those processes to the ones on the TOP. Their memory req's might be findable in Oracle INstallation, but they are all a couple of megs. If you have dedicated processes connecting (ps-ef will show LOCAL=NO) then each of those is a bout the size of SORT_AREA_SIZE ( a bit bigger).

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email