使用 Oracle Streams 实施审计跟踪
我将使用 Oracle Streams（用于重做和归档日志的日志挖掘）为高负载系统实现异步审计跟踪功能。在我的例子中，审计跟踪不得减慢对我的表集的任何 DML 操作。此外，审核还必须包含有关最终用户身份以及修改日期和时间的附加信息。
有人有使用 Oracle Streams 实施审计跟踪的经验吗？这样移动是个好主意吗？
是否有任何教程提供有关使用 Oracle Streams 实施审计跟踪的提示和技巧？
I'm going to implement asynchronous audit trails functionality for highly loaded system with using of Oracle Streams (for log mining on redo and archive logs). Audit trails in my case mustn't slow down any DML operations over set of my tables. Also audits must contain additional information about end user identity and date and time of modification.
Does someone have experience in implementing audit trails with using of Oracle Streams? Is it good idea to move this way?
Is there any tutorials exist with tips and tricks about implementing audit trails with using of Oracle Streams?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Oracle 声称数据库中的审计功能所产生的开销微不足道。您是否尝试过将它们作为测试用例来看看它的性能如何？它不需要表上的任何 DML 触发器。我使用过它们，没有发现明显的差异，但系统资源也没有耗尽。
使用流进行审计听起来是可能的，但我认为这是一个过于复杂的解决方案。我想您可以使用流将事务复制到另一个数据库，然后在该数据库中使用审核。您仍然需要向存储重做日志的位置添加 I/O 负载。
Oracle claims the auditing features in the database create an insignificant amount of overhead. Have you tried those as a test case to see how it performs? It doesn't require any DML triggers on the tables. I've used them and got no noticeable difference but the system resources weren't maxed out either.
Using streams for auditing sounds possible but I think it's an overly complicated solution. I supposes you could use streams to replicate transactions to another database and then use the auditing in that database. You're still going to add I/O load to wherever you store your redo logs.
同意@JOTN。添加 wrt Oracles 流的另一件事是，它在 12c 中已弃用，并被打包/提供为具有单独许可成本的“金门”。
Agree with @JOTN. One more thing to add wrt Oracles streams, it is deprecated in 12c and being packaged/offered as 'Golden gate' with a separate license cost.