OpenVZ Forum: Users » UBC parameters for Oracle Server

Home » Mailing lists » Users » UBC parameters for Oracle Server

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

UBC parameters for Oracle Server [message #11431]

Fri, 23 March 2007 12:59

lst_hoe01
Messages: 15
Registered: February 2007

Junior Member

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

Report message to a moderator

Re: UBC parameters for Oracle Server [message #11432 is a reply to message #11431]

Fri, 23 March 2007 13:24

dev
Messages: 1693
Registered: September 2005
Location: Moscow

Senior Member

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@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
>

Report message to a moderator

Previous Topic:	Virtual Memory Problems
Next Topic:	gdb pthreads question (bug #487)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Jul 27 03:11:39 GMT 2024

Total time taken to generate the page: 0.03153 seconds