AIX

 View Only
  • 1.  Changing oracle user stack value

    IBM Champion
    Posted Fri October 08, 2021 02:37 AM
    Hi,

    If I would need modify oracle user limits like following

    chuser nofiles=32768 nofiles_hard=65536 oracle
    chuser fsize=-1 fsize_hard=-1 oracle
    chuser data=-1 data_hard=-1 oracle
    chuser stack=-1 stack_hard=-1 oracle
    chuser rss=-1 rss_hard=-1 oracle
    chuser core=-1 core_hard=-1 oracle

    which all parameters get active / enabled on fly, and which ones require Oracle database to be restarted?

    ------------------------------
    Tommi Sihvo, Lead Service Architect
    TietoEVRY, Compute Services
    email tommi.sihvo@tieto.com mobile +358 (0)40 5180 Finland
    ------------------------------


  • 2.  RE: Changing oracle user stack value

    IBM Champion
    Posted Mon October 11, 2021 05:20 AM

    Hi,

    All of them require the DB to be restarted.

    The reason is that those parameters are inherited from parent to child, so the only time they're set is when an oracle process is started by a uid=0 process (either via a login, "su - oracle", or oracle's crontab).



    ------------------------------
    José Pina Coelho
    ------------------------------



  • 3.  RE: Changing oracle user stack value

    IBM Champion
    Posted Mon October 11, 2021 05:24 AM
    Thanks Jose! Good to know :)

    Br,
    tommi

    ------------------------------
    Tommi Sihvo, Lead Service Architect
    TietoEVRY, Compute Services
    email tommi.sihvo@tieto.com mobile +358 (0)40 5180 Finland
    ------------------------------