Ask the Expert

Kernel parameters setting

How do I find the kernel parameters setting for my Oracle database?

    Requires Free Membership to View

The list of kernel parameters that should be modified for Oracle on HP-UX are defined in the installation guide. Here is the recommended values from the install guide:

shmmax=1073741824 or 0X40000000
shmmni=100
shmseg=10
semmns=1000
semmni=100
maxdsiz (and maxdsize_64) = 384M or higher

The kernel parameter shmmax controls that maximum size of a single shared memory segment. So, if you need your SGA larger then 1 gig, increase shmmax accordingly. The parameter semmns controls the number of shared memory segments. Increase this value based on the sum of the processes init.ora parameter for all the running databases on your unix machine. You should also allow for about 10 process per database instance for the Oracle background processes.

This was first published in August 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: