Oracle 19c generate lot of large trace files like RDMAV_FORK_SAFE & RDMAV_HUGEPAGES_SAFE
After upgrade to 19c database from 12c,
In Windows environment we will start getting the lot of trace file.
Trace file contains this information:
Required IPC RDMAV_FORK_SAFE environment not set
Required IPC RDMAV_HUGEPAGES_SAFE environment not set
Solution:
There are possible two solution:
- Stop the trace files from start creating.
- Purge the trace files which creating to avoid space crunch.
- Stop the trace files start created.
Set Windows Environment Variables RDMAV_FORK_SAFE and RDMAV_HUGEPAGES_SAFE as “0” to prevent the trace outputs.
2. Purge the files after every five day instead of default 30 days.
adrci> show homes
ADR Homes:
diag\rdbms\xe\xe
diag\tnslsnr\hostoracle\listener
adrci> set home diag\rdbms\xe\xe
adrci> show home
ADR Homes:
diag\rdbms\xe\xe
adrci> show control
ADR Home = C:\Oracle\diag\rdbms\xe\xe:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
213375795 720 8760 2019-09-18 15:33:15.739000 +05:30 2021-09-13 11:14:10.553000 +05:30 1 2 110 1 2019-09-18 15:33:15.739000 +05:30
1 row fetched
adrci> set control (shortp_policy = 120)