[Users] UBC parameters for Oracle Server

Kirill Korotaev dev at sw.ru
Fri Mar 23 09:36:13 EDT 2007


There is nothing bad in such high privvmpages settings.
1. Oracle manages it's caches itself and creates lots of mappings,
  which is the first reason of high privvmpages usages.
2. also please check the output of the following:
# cat /proc/sys/kernel/exec-shield-randomize
# cat /proc/sys/kernel/randomize_va_space
RHEL kernels introduce randomization of virtual memory areas,
but due to some reason it uses much more addition virtual memory for this.
So you can disable it echoing '0' to one of these files.

Thanks,
Kirill


lst_hoe01 at kwsoft.de wrote:
> 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
> 
> _______________________________________________
> Users mailing list
> Users at openvz.org
> https://openvz.org/mailman/listinfo/users
> 



More information about the Users mailing list