O'Reilly logo

Getting Started with Oracle Event Processing 11g by Lloyd Williams, Robin J. Smith, Alexandre Alves

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using concurrency with processors

We will turn now to improving the performance in your Event Processors using the concurrency feature with the Continuous Query Language (CQL). For CQL queries that requiring ordering, the CQL engine uses internal locks, as you would expect to maintain integrity, however this can result in lock contention and slower performance if multiple threads are active in a single processor instance.

In Oracle Event Processing 11.1.1.6 and later releases, the support for parallelism in the CQL engine has been enhanced, allowing lock contention to be minimized or eliminated for CQL queries with specific types of ordering constraints. This capability is implemented using the ordering-constraint attribute.

Use ordering-constraint="UNORDERED" ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required