We have the following setting, with Oracle 10g:
- One primary database
- One logical standby database with setup with data guard. The logical standby is only used for generating reports and alike.
Currently the parameter PRESERVE_COMMIT_ORDER of DBMS_LOGSTDBY is set to true. In order to enhance the speed of data replication, we are thinking of setting it to false. But what are the risks, if any, of doing so? (Oracle says: "See the Usage Notes for details and recommendations." ... but I couldn't find these recommendations.)