1748255 Members
4101 Online
108760 Solutions
New Discussion юеВ

Re: tuning

 
Heidi Gabel
New Member

tuning

Is anyone aware of a documentation source that is just definitions of the various kernel parameters that might also provide information about how they relate to each other?

Thanks.
7 REPLIES 7
Michael Schulte zur Sur
Honored Contributor

Re: tuning

Hi,

have a look here:
http://h30097.www3.hp.com/docs/base_doc/DOCUMENTATION/V51B_HTML/MAN/MAN5/INDEX.HTM

look for sys_attrs*

greetings,

Michael
Heidi Gabel
New Member

Re: tuning

Yes, thanks, I've seen that. I'm looking for something more specific to kernel parameters. There are some that I can't find any information on, much less on how they might relate to other parameters. I'd really like to find some recommended settings for running Oracle on such and such a server.

Heidi
Michael Schulte zur Sur
Honored Contributor

Re: tuning

Hi,

do you have access to metalink? There are docs for requirements for running Oracle on Tru64 Unix. Do you have anything specific, you want to know?

have fun,

Michael
Heidi Gabel
New Member

Re: tuning

The Oracle literature only addresses certain parameters. We are looking at a number of others to see if we can improve performance. In particular, on one that Oracle does address, new_wire_method - Oracle recommends 0 but the default is 1 and Compaq is saying the Oracle has changed its thinking. More specifically, how does either setting relate to the ssm_threshold setting?

Thanks.
Michael Schulte zur Sur
Honored Contributor

Re: tuning

Hi,

concerning new-wire-method look here:
http://www.support.compaq.com/svctools/shc/menu/sample-reports/tru64-shcreport2.html

concerning ssm-theshold:
The use of shared page tables induces alignment restrictions.
If ssm-threashold is set to 8MB (i.e., 8388608 bytes which is
also default value), and if SGA (or shared memory requested
by Oracle) is equal to or greater than 8MB, then the attach
addresses are required to be aligned at 8MB.

As Oracle uses unaligned addresses to attach segment, because
of varying sizes of Fixed SGA, Variable SGA, Log buffers and
Buffer Cache and also because Oracle tries to allocate SGA in
single segment, the attach operation (shmat()) fails with
Invalid Argument (EINVAL).

greetings,

Michael
Heidi Gabel
New Member

Re: tuning

Thanks, Michael. That was helpful.
Michael Schulte zur Sur
Honored Contributor

Re: tuning

Hi,

points would be appreciated.

thanks,

Michael