Can we have Multiple audit_file_dest ?
Currently we used to have only one audit_file_dest as per my understanding. Please correct me if I am wrong.
Due to this single dir option, when a file system that is holding this directory becomes 100% full, the database cannot write the audit entries, and gets into hung status, which in turn halts the application access/connections.
Do we have an option to keep multiple directories to avoid these kinds of situation ?
For instance, we used to have multiple *log_archive_dest1/2/3... ?
Please share your thoughts. Highly appreciate your ideas and suggestions.