Oracle on UnixWare - greedy for memory?

    Hi gurus!

    Can anybody give me an idea how to find memory eater on my Oracle site?
Site stands for Intel box with 2 Gb RAM with UnixWare 7.1 on board.

Oracle 8.0.5.1 instance is configured this way

SQL> select * from v$sga;

NAME                     VALUE
-------------------- ---------
Fixed Size               56 352
Variable Size        281 296 896
Database Buffers     450 560 000
Redo Buffers           1 056768

In addition to 700+M SGA I count for 400 M total session PGA:

SQL> select count(*), sum(value) from v$sesstat where statistic#=20;

 COUNT(*) SUM(VALUE)
--------- ----------

      349 396 420 072

what gives total of about 1100 M.
According to my opinion Oracle instance of that scale would feel quite comfortable on box with 2Gb RAM.
But it suffers because of intensive paging.

This is rtpm screenshot

    CPU: CALLS/s: IO/s: QUEUE: TTY/s: ETHER:
     96 %cpu 9957 calls 9 reads 0 runq 0 rcvs 3044 xpkt/s

     69 %usr 1 forks 220 rdblk 0 %run 0 xmit 2681 rpkt/s

     21 %sys 0 execs 21 writs 4 prunq 0 mdms 319765 xoct/s

      6 %int 934 reads 565 wrblk 40 %prun 0 canch 327517 roct/s

      0 %wio 818 writs 0 qlen 0 swpq 0 rawch 0 xerrs

      3 %idl 278 Krwch 2 %busy 0 %swp 147 outch 0 rerrs

    MEMORY: PAGING/s: FILESYS/s: LWPS: NETWARE: TCP/IP:
  50014 kma 9 pgins 0 igets 538 lwps 0 spx/s 5737 tcp/s
  66036 frmem 0 pgots 20 lkups 5 run 0 ipx/s 0 udp/s
 304073 frswp 1327 atchs 1 dirbk 528 sleep 0 sap/s 0 icmp/s

     87 %mem 119 pflts 97 %dnlc 0 zomb 0 rip/s 5743 ip/s

     59 %swp 1498 vflts 0 inode 422 procs 0 errs 51 errs

which reports me total memory consumption more than 2 Gb (87%*2 Gb+59%*1 Gb(swap)=2.3Gb) what leads to intensive paging (119 pflts ) and noticeable sys CPU consumption - 21%. Can anybody explain this huge discrepancy - 1.1 Gb instance size and 2.3 Gb mem consumption? Most data files, except for the most volatile, lie on filesystem - may UnixWare reserve many hundred megs for file cache? Any ideas to my 'to do' list? Received on Thu May 04 2000 - 08:28:57 CDT