stack_hard setting due to ORA-4030
Recently , my customer is hitting ora-4030 repeatedly on their AIX 10.2.0.5 RAC database. It turned out the shell limit setting stack was not set to -1. Customer is going to set the stack for root and oracle to -1. The question is about the stack_hard, currently it is AIX default 8388608 . Does customer need to change hard_stack to -1 too?
* The following table contains the default hard values if the
* hard values are not explicitly defined:
*
* Attribute Value
* ========== ============
* fsize_hard set to fsize
* cpu_hard set to cpu
* core_hard -1
* data_hard -1
* stack_hard 8388608
* rss_hard -1
* nofiles_hard -1