Changing data seg size kernal parameter

[Shehan]

Hi All

What's the maximum increasing size of "data seg size" kernal parameter in hp-ux 11i v1


Thanks
Nirukshitha

[Jeeshan · Accepted solution]

Do you mean maxdsiz parameter?

it's depend upon the application's requirement.

for Oracle 9i database it's recommended value is 1GB.

[Shehan]

Hi Ahsan

Yes. Our customer is having Oracle 10g. They want us to change remaining to unlimited. Is it possible ?

Regards
Nirukshitha

[Jeeshan]

setting unlimited is not the good way because of further performance measure.

you can increase parameter values according to your need.

also note that, this may impact to other parameters.

[Shehan]

Hi Ahsan

What do you recommend for Oracle 10g?

Regards
Nirukshitha

[Jeeshan]

From Oracle documentation recommended value is 1 GB.

but it completely depends upon application's load and it's behavior as i said earlier.

[Venkatesh BL]

check out the manpage for 'maxdsiz' to understand the max & min values.

[Dennis Handly]

You can only increase maxdsiz to 4 Gb. Most applications can't take advantage of over 1 Gb.
You can increase maxdsiz_64bit to much larger for 64 bit apps.

[Shehan]

Hi Dennis

1) What is different between maxdsiz_64bit and maxdsiz?

2) Do we need to change both Valve ?

3) What's the recommended level of maxdsiz_64bit ?

Regards
Nirukshitha

[Jeeshan]

>>1) What is different between maxdsiz_64bit and maxdsiz?

maxdsiz is for 32 bit systems &
maxdsiz_64bit is for 64 bit systems

>>2) Do we need to change both Valve ?

yes, accordingly.

>>3) What's the recommended level of maxdsiz_64bit ?

you can set this value as twice from maxdsiz.