>> How do you run automated tests for applications which depend on state of an Oracle database/schema?
Oracle Multitenant (no need for option and this may be done with free Oracle XE) can flashback a Pluggable DataBase very fast.
Right, but in a mixed workload, reporting is done at the same time as OLTP. Parallel Query is ok (when resource manager manages to keep resources for the OLTP) but PDML blocks all modification on their target tables and all tables linked to them by referential integrity. It is more than a “reporting” service. It is more like an “I am alone on these tables” service.
Thanks for the feedback.
The reason is documented in https://support.oracle.com/epmos/faces/DocContentDisplay?id=2433906.1
parallel processes have their own transaction and coordinator uses 2PC to commit. Concurrent transactions could mess-up everything.