maxdsiz

[Carlos Munoz Lopez]

Hi guys. I need to modify the value for maxdsiz on two servers, but I was wondering if it's necessary to reboot the system once the change is made. I'm not completely sure about this and the problem is the a production database is running on these servers. I was checking some information but I couldn't find anything related to this. I would like some help. Thanks.

[Bryan D. Quinn · Accepted solution]

Hello,

Yes this will require a reboot to build a new kernel with the new maxdsiz.

Hope this helps!
-Bryan

[Pete Randall]

Carlos,

Unfortunately, maxdsiz is not dynamically tuneable. You'll need to change the paramater, rebuild the kernel and reboot in order to have it take effect.


Pete

[Robert-Jan Goossens]

Carlos,

If you use sam to change the parameter, you will get the warning to reboot your server inmediatly.

The change in the kernel will only effect after a reboot.

Regards,
Robert-Jan

[Bryan D. Quinn]

Clarificatioin...

Sorry about that, my wording was incorrect. You will have to boot the system off of the newly built kernel. So yes, it does require a reboot.

-Bryan

[Carlos Munoz Lopez]

Thanks a lot guys. I appreciate your quick response. Bye.

[A. Clay Stephenson]

For any value in question use kmtune (for 11.x and up).

e.g.
kmtune -l -q maxdsiz

This will tell you if the tunables is dynamic or not; if it is dynamic then no reboot is needed. Alas, maxdsiz is not dynamic so a kernel rebuild and reboot will be needed.

[Don Morris_1]

Well, maxdsiz *is* dynamic on 11i v1.6 and later (11.22). Just fyi given all the above. :)