User received the following error in LogMiner option when displaying data in an archivelog file:
"ORA-04030: out of process memory when trying to allocate 204 bytes"
Issue caused by Oracle parameter udp_recvspace setting or Registry parameters not set properly. Refer to Oracle Metalink Doc ID 297030.1.
Refer to Oracle Metalink Doc ID 297030.1 which provides workarounds on Oracle parameter udp_recvspace setting and Windows Registry parameters.
Running the below background query causes the same error:
Select SCN, timestamp, session# session_num, sql_redo
From V$LOGMNR_CONTENTS
Order by 1
