What about external logging systems
July 28, 2020 - 8:13 am UTC
Reviewer: Andrzej from Warsaw
Yes, this are quite well known solutions but at the end even whet there are only select queries in procedure than Oracle has to create a transaction and usually write data through lgwr.
I wish there was asynchronous logging.
What about logging using audit through syslog to external system (over UDP) or logstach, fluentd to store this kind of information in dedicated logging systems like: Datadog, ELK, Prometheus.
July 29, 2020 - 2:36 am UTC
You could do asynch logging by using a buffered queue - that would be a simple add-on to either mine or logger.
And once you use AQ, then the potential external subscribers is large.
August 04, 2020 - 7:54 am UTC
The idea about buffered queue sounds good. It is worth considering.
August 05, 2020 - 3:10 am UTC
glad we could help