Looking for some suggestions here. We are currently running Oracle 12.2.1 Enterprise Edition. The server is a VM running 2 instances. Both instances have a login trigger which gathers some instrumental information on the connections and then stores that data in a table, and also aggregates the data into another table. Likewise, we have a process that logs the execution of each stored procedure and aggregates that data also. Of course, each of these are transactions, with commits, which takes up I/O and redo log writing and other resources. And, if one instance connects to the other instance via a DB Link, the number of commits doubles, since the same logging is done in all databases.
While these are autonomous transactions, when the connections to our website increase, the number of commits from these instrumental process increase, and performance takes a hit.
So, we were considering that rather than writing this data to a table, maybe we write it to logs on disk, and eliminate the commit & redo contention. However, I've read that UTL_FILE is not great for high frequency writing.
What other options might be available for this type of instrumental logging which we need to do?