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
------------------------------

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
------------------------------

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
------------------------------

Original Message:
Sent: Mon October 11, 2021 05:20 AM
From: José Pina Coelho
Subject: Changing oracle user stack value

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
------------------------------