Database Memory & 4030/4031 (MOSC)

MOSC Banner

stack_hard setting due to ORA-4030

edited Sep 29, 2014 10:58PM in Database Memory & 4030/4031 (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center