Search

Top 60 Oracle Blogs

Recent comments

Hi Vivek, Right, but in a mixed workload, reporting is done at the same time as OLTP.

Hi Vivek,
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.