[Users] UBC parameters for Oracle Server

lst_hoe01 at kwsoft.de lst_hoe01 at kwsoft.de
Fri Mar 23 08:59:38 EDT 2007


We have a central Linux server for some development related services in 
our department. One of it is a Oracle 10gR2 Database server with two 
instances. I have managed to get it working but the needed parameters 
look a little bit odd to me. Especially the privvmpages must be really 
high and seams to climb up over time??

Version: 2.5
       uid  resource           held    maxheld    barrier      limit    failcnt
   107001:  kmemsize       16705667   24744140   25000000   32000000          0
            lockedpages           0          8         32         32          0
            privvmpages     3961971    4256673   19000000   20000000          0
            shmpages         131714     132690     256000     256000          0
            dummy                 0          0          0          0          0
            numproc             123        462       1024       1024          0
            physpages        195320     220490          0 2147483647          0
            vmguarpages           0          0     256000 2147483647          0
            oomguarpages     209597     223636     256000 2147483647          0
            numtcpsock           98        121       1024       1024          0
            numflock             49         53        100        110          0
            numpty                1          2         16         16          0
            numsiginfo            0        256        256        256          0
            tcpsndbuf        157784     406584     512000    2048000          0
            tcprcvbuf          2392     622184     512000    2048000          0
            othersockbuf     178964     512824     512000    2048000          0
            dgramrcvbuf           0       8364     132096     512000          0
            numothersock        115        122       1024       1024          0
            dcachesize            0          0    1024000    2048000          0
            numfile            4091       8192      16384      16384          0
            dummy                 0          0          0          0          0
            dummy                 0          0          0          0          0
            dummy                 0          0          0          0          0
            numiptent            10         10        128        128          0

Is there any downside in setting privvmpages that large for a 
4GB/Dual-Proc Maschine or should i simply let it that way?

Thanxs

Andreas



More information about the Users mailing list