Some Questions On CEP Implementation Behaviour (Doc ID 1435989.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Event Processing - Version 10gR3 and later
Information in this document applies to any platform.

Goal

The purpose of this document is to address the following (related) frequently asked questions:

  1. What are the differences between sequences and relations?
  2. How often each query is executed?
  3. What are the cases when we have to convert relation to sequence?
  4. How the join statement works? Is it applicable only for relations?
  5. According to the documentation table and cache event source are pull event sources. Does it mean that the database table or cache will be queried for each event in the current relation when performing join statement?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms