Oracle 19c generate lot of large trace files like RDMAV_FORK_SAFE

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:

  1. Stop the trace files from start creating.
  2. Purge the trace files which creating to avoid space crunch.
  1. 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)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.