Hi,
Can someone tell "What is the maximum size that should be set within the MAX_DUMP_FILE_SIZE and what should we do if it is already set to the maximum?"
Current value set for parameter in the DB as below.
SQL> show parameter MAX_DUMP_FILE_SIZE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string 2M
SQL>
Oracle -- 11.2.0.4.0
OS --- Linux
This is Exadata server with 2 nodes.
Regards,
Balaji.C