Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

Audience

Documentation Accessibility

Related Documents

Conventions

Part I Introduction

1 Overview of Oracle CEP Visualizer

1.1 Overview of Using Oracle CEP Visualizer

1.2 Understanding the Oracle CEP Visualizer User Interface

1.2.1 Top Pane

1.2.2 Left Pane

1.2.3 Right Pane

1.2.4 Overview of the Oracle CEP Visualizer Dashboard

1.2.5 Overview of the Stream Visualizer (ViewStream) Panel

1.2.6 Overview of the Event Processing Network

1.2.6.1 Event Processing Network Context Menu

1.2.7 Oracle CEP Visualizer Panels that Require Refresh

1.3 Understanding Oracle CEP Visualizer Administration Tasks

1.3.1 Managing Oracle CEP Applications

1.3.1.1 The com.bea.wlevs.dataservices Application

1.3.2 Managing Oracle CEP Servers

1.3.3 Managing Security

1.3.4 Updating Configuration Data

1.4 Who Uses Oracle CEP Visualizer?

1.4.1 Administrators

1.4.2 Developers

1.4.3 Business Users

1.5 National Language Support

1.5.1 Configuration File Encoding: UTF-8

1.6 Next Steps

2 Using Oracle CEP Visualizer

2.1 Starting the Oracle CEP Visualizer

2.1.1 Prerequisites

2.1.2 How to Start Oracle CEP Visualizer Using a Browser

2.1.3 How to Start Oracle CEP Visualizer Using Oracle CEP IDE for Eclipse

2.1.4 How to Start Oracle CEP Visualizer in a Multi-Server Domain

2.2 Managing User Preferences

2.2.1 How to Manage User Preferences

2.3 Improving Oracle CEP Visualizer Accessibility

Part II Application Tasks

3 Overview of Application Tasks

3.1 Event Processing Network (EPN) Management

3.2 Application Lifecycle Management

3.3 Rules Management

3.4 Configuration History Management

3.4.1 Enabling and Disabling Configuration History Management

3.4.2 Resource Configuration History Management

3.4.3 Application Configuration History Management

3.4.4 Application Lifecycle and Configuration History Management

3.4.5 Multi-Server Domains and Configuration History Management

3.4.5.1 Rejoining a Multi-Server Domain

3.4.5.2 Simultaneous Updates

4 Managing the Event Processing Network

4.1 Viewing the EPN of an Application

4.1.1 How to View the EPN of an Application

4.2 Viewing and Editing the Configuration of a Stage

4.2.1 How to View and Edit the Configuration of a Stage

4.2.1.1 Channel Properties

4.2.1.2 Channel Properties: Outbound Channel

4.2.1.3 Channel Properties: Outbound Channel With Query Selector

4.2.1.4 Stream Properties

4.2.1.5 Oracle CQL Processor Properties

4.2.1.6 EPL Processor Properties

4.2.1.7 Adapter Properties

4.2.1.8 JMS Adapter Properties

4.2.1.9 Oracle CEP High Availability Input Adapter Properties

4.2.1.10 Oracle CEP High Availability Buffering Output Adapter Properties

4.2.1.11 Oracle CEP High Availability Broadcast Output Adapter Properties

4.2.1.12 Oracle CEP High Availability Correlating Output Adapter Properties

4.2.1.13 Event Bean Properties

4.2.1.14 POJO Properties

4.2.1.15 Cache Properties: Oracle Coherence Cache

4.2.1.16 Cache Properties: Oracle CEP Local Cache

4.3 Recording and Playing Back Events in the EPN

4.3.1 How to Record Events

4.3.2 How to Playback Events

4.4 Tracing and Injecting Events in the EPN

4.4.1 How to Trace Events on a Dynamic Channel

4.4.2 How to Inject a Simple Event on an Event Inspector Service Dynamic Channel

4.4.3 How to Inject an Event as a JSON String on an Event Inspector Service Dynamic Channel

4.5 Monitoring a Channel Stage in the EPN

4.5.1 How to Monitor a Channel Stage in the EPN

4.6 Monitoring the Throughput and Latency of a Stage or Path in the EPN

4.6.1 How to Monitor the Throughput and Latency of a Stage or Path in the EPN

5 Managing Application Lifecycle

5.1 Deploying an Application

5.1.1 How to Deploy an Application in a Standalone-Server Domain

5.1.2 How to Deploy an Application in a Multi-Server Domain

5.2 Suspending or Resuming an Application

5.2.1 How to Suspend or Resume an Application

5.3 Updating an Application

5.3.1 How to Update an Application

5.4 Uninstalling an Application

5.4.1 How to Uninstall an Application

6 Managing Oracle CQL Rules

6.1 Using the Query Wizard

6.1.1 How to Create a Rule in an Oracle CQL Processor Using the Query Wizard

6.1.2 How to Edit a Rule in an Oracle CQL Processor Using the Query Wizard

6.1.3 How to Create a Parameterized Rule in an Oracle CQL Processor

6.1.4 How to Edit a Parameterized Query in an Oracle CQL Processor

6.1.4.1 Adding a Parameter

6.1.4.2 Replacing a Parameter

6.1.4.3 Deleting a Parameter

6.1.4.4 Editing the Query

6.1.4.5 Deleting the Query

6.1.5 How to Stop and Start a Parameterized Query

6.1.6 How to Delete a Rule in an Oracle CQL Processor

6.1.7 How to Replace a Rule in an Oracle CQL Processor

6.1.8 How to View a Rule in an Oracle CQL Processor

6.1.9 How to Configure Query Wizard Oracle CQL Constructs

6.1.9.1 Configuring an RSource CQL Construct

6.1.9.2 Configuring an SSource CQL Construct

6.1.9.3 Configuring a Cache-Table CQL Construct

6.1.9.4 Configuring a Pattern CQL Construct

6.1.9.5 Configuring a Select CQL Construct

6.1.9.6 Configuring a Join CQL Construct Using + Syntax

6.1.9.7 Configuring a Join CQL Construct Using LEFT or RIGHT OUTER JOIN

6.1.9.8 Configuring a Window CQL Construct

6.1.9.9 Configuring a Filter CQL Construct

6.1.9.10 Configuring a Union CQL Construct

6.1.9.11 Configuring an Intersect CQL Construct

6.1.9.12 Configuring a Minus CQL Construct

6.1.9.13 Configuring an IStream CQL Construct

6.1.9.14 Configuring a DStream CQL Construct

6.1.9.15 Configuring an RStream CQL Construct

6.1.9.16 Configuring an Output CQL Construct

6.1.9.17 Configuring an Expression Using the Expression Builder

6.1.10 How to Create an Oracle CQL Template for the Query Wizard

6.1.11 Managing the Query Wizard Diagram

6.1.11.1 Choose Layout

6.1.11.2 Clear Canvas

6.1.11.3 Save Query

6.1.11.4 Open Query

6.1.11.5 Hover

6.1.11.6 Zoom In and Zoom Out

6.1.11.7 Fit Content

6.1.11.8 Toggle Constructs

6.1.11.9 Zoom

6.2 Using the Query Plan

6.2.1 How to View a Query Plan for an Oracle CQL Processor

6.2.2 Managing the Query Plan Diagram

6.2.2.1 Choose Layout

6.2.2.2 Collapse All and Expand All

6.2.2.3 Get Statistics and Stop Statistics

6.2.2.4 Refresh

6.2.2.5 Show Legend

6.2.2.6 Preferences

6.2.2.7 Fit Content

6.2.2.8 Zoom

7 Managing EPL Rules

7.1 Creating a Rule in an EPL Processor

7.1.1 How to Create a Rule in an EPL Processor

7.2 Deleting a Rule From an EPL Processor

7.2.1 How to Delete a Rule in an EPL Processor

7.3 Replacing a Rule in an EPL Processor

7.3.1 How to Replace a Rule in an EPL Processor

7.4 Changing the dataservices Application Event Filter Rule Using EPL

7.4.1 How to Change the Dataservices Application Event Filter Rule Using EPL

8 Managing Configuration History

8.1 Managing Resource Configuration History

8.1.1 How to Manage Resource Configuration History

8.2 Managing Application Configuration History

8.2.1 How to Manage Application Configuration History

Part III Server and Domain Tasks

9 Overview of Server and Domain Tasks

9.1 Deployment Management

9.2 Jetty Management

9.3 JMX Management

9.4 Data Source Management

9.5 HTTP Publish-Subscribe Server Management

9.6 Event Type Repository Management

9.7 Persistent Event Store Management

9.8 Multi-Server Domain Management

9.9 Event Inspector Service Management

9.10 Cache Management

9.11 Log Management

10 Managing Deployments

10.1 Viewing Deployments

10.1.1 How to View the Applications Deployed to an Oracle CEP Server

10.1.2 How to View the Application Libraries Deployed to an Oracle CEP Server

10.2 Adding or Deleting Deployments

10.2.1 How to Add or Delete an Application

10.2.2 How to Add or Delete an Application Library

11 Managing Jetty

11.1 Managing Jetty Web Server Configuration

11.1.1 How to View Jetty Web Server Configuration

11.1.2 How to Edit Jetty Web Server Configuration

11.2 Managing Work Manager Configuration

11.2.1 How to View and Edit Work Manager Configuration

11.2.2 How to Create a Work Manager

11.2.3 How to Delete a Work Manager

12 Managing JMX

12.1 Viewing JMX Configuration

12.1.1 How to View JMX Configuration

12.2 Editing JMX Configuration

13 Managing Data Sources

13.1 Viewing and Editing a Data Source

13.1.1 How to View a Data Source Configuration

13.1.2 How to Edit Data Source Configuration

13.2 Adding a Data Source

13.2.1 How to Add a Data Source Configuration

14 Managing HTTP Publish-Subscribe Servers

14.1 Viewing HTTP Publish-Subscribe Servers

14.1.1 How to View HTTP Publish-Subscribe Server Channels

14.2 Adding or Deleting an HTTP Publish-Subscribe Server

14.2.1 How to Add an HTTP Publish-Subscribe Server Channel

14.2.2 How to Delete an HTTP Publish-Subscribe Server Channel

15 Managing the Event Inspector Service

15.1 Configuring the Event Inspector Service HTTP Pub-Sub Server

15.1.1 How to Configure the Event Inspector Service HTTP Pub-Sub Server

16 Managing the Event Type Repository

16.1 Viewing the Event Type Repository

16.1.1 How to View the Event Type Repository

16.2 Configuring the Event Type Repository

17 Managing the Persistent Event Store

17.1 Viewing the Persistent Event Store

17.1.1 How to View the Persistent Event Store

17.2 Configuring the Persistent Event Store

18 Managing Multi-Server Domains

18.1 Managing Cluster Groups and Topologies

18.1.1 How to View Cluster Group Membership

18.1.2 How to View all Cluster Topologies

18.1.3 How to View Oracle CEP High Availability Cluster Topologies

18.1.3.1 Visualizing an Oracle High Availability Configuration

18.1.3.2 Visualizing an Oracle High Availability and Scalability Configuration

18.2 Managing Oracle Coherence

18.2.1 How to View Oracle Coherence Cluster Topologies

18.2.2 How to Monitor Nodes in an Oracle Coherence Cluster

18.2.3 How to Monitor an Oracle Coherence Cache

18.2.4 How to Tune Oracle Coherence

18.3 Managing the Cluster Topology Diagram

18.3.1 Choose Layout

18.3.2 Show All Groups

18.3.3 Zoom

18.3.4 Fit Content

18.3.5 Zoom In and Zoom Out

18.3.6 Toggle Properties

19 Managing Oracle CEP Server Logs

19.1 Configuring Logs

19.1.1 How to Configure the Oracle CEP Server Logging Service

19.1.2 How to Configure a Component Logger

19.2 Viewing Logs

19.2.1 How to Query Logs

19.2.2 How to View Console Output

Part IV Security Tasks

20 Overview of Security Tasks

20.1 User, Group, and Role Management

20.2 HTTP Publish-Subscribe Server Channel Security Management

20.3 SSL Management

21 Managing Users

21.1 Creating and Editing a User

21.1.1 How to Create a User

21.1.2 How to Edit a User

21.1.3 How to Change the Password of a User

21.2 Deleting a User

21.2.1 How to Delete a User

22 Managing Groups

22.1 Creating and Editing a Group

22.1.1 How to Create a Group

22.1.2 How to Change the Roles to Which a Group Maps

22.1.3 How to Change the Groups to Which a User is Assigned

22.2 Deleting a Group

22.2.1 How to Delete a Group

23 Managing Roles

23.1 Creating an Application Role

23.1.1 How to Create an Application Role

23.2 Deleting a Role

23.2.1 How to Delete a Role

24 Managing HTTP Publish-Subscribe Server Security

24.1 Configuring Security for an HTTP Publish-Subscribe Channel

24.1.1 How to Configure Security for an HTTP Publish-Subscribe Channel

25 Managing SSL

25.1 Viewing SSL Configuration

25.1.1 How to View the SSL Configuration for an Oracle CEP Server

25.2 Editing SSL Configuration

A Oracle CQL Query Wizard Template Schema Reference

Index

List of Examples

1-1 UTF-8 Encoding Attribute in Oracle CEP Server config.xml

4-1 recplay Application Configuration File config.xml: adapter Element

4-2 recplay Oracle CEP Server Configuration File config.xml: data-source and rdbms-event-store-provider Elements

4-3 recplay Application Configuration File config.xml: stream Element

4-4 recplay Oracle CEP Server Configuration File config.xml: data-source and rdbms-event-store-provider Elements

4-5 JSON-Formatted Event String

6-1 myTemplate.xml XML File

6-2 Rule Element

6-3 Rule Element: Operators

6-4 Rule Element: Connect Operators

6-5 Oracle CEP registry.xml File

A-1 wlevs_queryconstructor_config.xsd

List of Figures

1-1 Sample Oracle CEP Visualizer Window

1-2 Oracle CEP Visualizer Dashboard

1-3 Oracle CEP Visualizer Stream Visualizer (ViewStream)

1-4 Event Processing Network Panel

1-5 Event Processing Network Tab - Requiring Refresh

2-1 Oracle CEP Visualizer Logon Screen

2-2 The Preference Screen

4-1 Event Processing Network Panel

4-2 General Tab for Channel Stage: Before Clicking Edit

4-3 General Tab for Channel Stage: After Clicking Edit

4-4 General Tab for Channel Stage

4-5 General Tab Outbound Channel Parameters

4-6 General Tab Selectors for Outbound Channel Stage

4-7 General Tab for Channel Stage

4-8 General Tab for Oracle CQL Processor Stage

4-9 General Tab for EPL Processor Stage

4-10 General Tab for an Adapter Stage

4-11 General Tab for a JMS Adapter Stage

4-12 General Tab for an Oracle CEP High Availability Input Adapter Stage

4-13 General Tab for an Oracle CEP High Availability Buffering Output Adapter Stage

4-14 General Tab for an Oracle CEP High Availability Broadcast Output Adapter Stage

4-15 General Tab for an Oracle CEP High Availability Correlating Output Adapter Stage

4-16 General Tab for Event Bean Stage

4-17 General Tab for POJO Stage

4-18 Oracle Coherence Cache Stage Properties

4-19 Oracle CEP Local Cache Stage Properties

4-20 Event Processing Network Panel

4-21 The Record Tab

4-22 Record Schedule Confirmation Dialog

4-23 Record Schedule Confirmation Dialog

4-24 Event Processing Network Panel

4-25 The Playback Tab

4-26 Playback Schedule Confirmation Dialog

4-27 Playback Schedule Confirmation Dialog

4-28 Playback Schedule Confirmation Dialog

4-29 Event Processing Network Panel

4-30 The Trace Event Tab: Start

4-31 Trace Event Confirmation Dialog

4-32 Stream Visualizer (ViewStream): Subscribe

4-33 The Trace Event Tab: Stop

4-34 Trace Event Stop Confirmation Dialog

4-35 Event Processing Network Panel

4-36 The Inject Event Tab: Start

4-37 Inject Event Start Confirmation Dialog

4-38 Stream Visualizer (ViewStream): Publishing Simple Events

4-39 The Inject Event Tab: Stop

4-40 Inject Event Stop Confirmation Dialog

4-41 Event Processing Network Panel

4-42 The Inject Event Tab: Start

4-43 Inject Event Start Confirmation Dialog

4-44 Stream Visualizer (ViewStream): Publishing JSON Events

4-45 The Inject Event Tab: Stop

4-46 Inject Event Stop Confirmation Dialog

4-47 Channel Monitor Tab

4-48 General Tab for Channel Stage

4-49 New Latency Profile Screen - Profile Information Tab

4-50 New Latency Profile Screen - Latency Tab

4-51 New Latency Profile Screen - Throughput Tab

4-52 Left Domain Tree - Mydiagprofile

4-53 Oracle CEP Visualizer Dashboard With Diagnostic Profiles

5-1 The Install Application Screen: Standalone-Server Domain

5-2 The Review Deployment Information Screen: Standalone-Server Domain

5-3 The Install Application Screen: Multi-Server Domain

5-4 The Review Deployment Information Screen: Multi-Server Domain

5-5 HelloWorld Application Deployed to All the Servers in Group testgroup

6-1 Oracle CQL Processor Panel

6-2 Oracle CQL Query Wizard

6-3 Valid Connection

6-4 Invalid Connection

6-5 All Saved Queries Dialog: Saving

6-6 Query Save Dialog

6-7 All Saved Queries Dialog: Loading

6-8 Oracle CQL Processor Panel

6-9 CQL Rules Tab

6-10 Query Wizard: With Existing Rule

6-11 Hovering Over an Oracle CQL Operator

6-12 Editor Dialog for Oracle CQL Join Operator

6-13 Oracle CQL Processor Panel

6-14 CQL Rules Tab

6-15 Query Save Dialog

6-16 Oracle CQL Processor Panel

6-17 CQL Rules Tab: Parameterized Query

6-18 CQL Rules Tab: Add Parameter

6-19 Add New Binding Dialog

6-20 CQL Rules Tab: Add Parameter Complete

6-21 CQL Rules Tab: Select Parameter

6-22 CQL Rules: Replace Parameter

6-23 Update Binding Dialog

6-24 CQL Rules Tab: Select Parameter

6-25 Delete Binding Dialog

6-26 Oracle CQL Processor Panel

6-27 CQL Rules Tab

6-28 CQL Rules: Filtered by View

6-29 Delete Rule Dialog

6-30 Delete All Rule Dialog

6-31 Oracle CQL Processor Panel

6-32 CQL Rules Tab

6-33 CQL Rules: Filtered by View

6-34 Oracle CQL Processor Panel

6-35 CQL Rules Tab

6-36 RSource Icon

6-37 Query Wizard RSource Editor Dialog

6-38 SSource Icon

6-39 Query Wizard Source Editor Dialog

6-40 Cache-Table Icon

6-41 Query Wizard Cache-Table Editor Dialog

6-42 Pattern Icon

6-43 Query Wizard Pattern Editor Dialog: Pattern Tab

6-44 Query Wizard Pattern Editor Dialog: Define Tab

6-45 Query Wizard Pattern Editor Dialog: Subset Tab

6-46 Query Wizard Pattern Editor Dialog: Measure Tab

6-47 Select Icon

6-48 Query Wizard Select Editor Dialog: Project Tab

6-49 Query Wizard Select Editor Dialog: Group Tab

6-50 Query Wizard Select Editor Dialog: Condition Tab

6-51 Query Wizard Select Editor Dialog: Order Tab

6-52 Join Icon

6-53 Query Wizard Join Editor Dialog

6-54 Oracle CQL Outer Join

6-55 Join Icon

6-56 Query Wizard Join Editor Dialog: LEFT or RIGHT OUTER JOIN Syntax

6-57 Window Icon

6-58 Query Wizard Window Editor Dialog

6-59 Filter Icon

6-60 Query Wizard Filter Editor Dialog

6-61 Union Icon

6-62 Query Wizard Union Editor Dialog

6-63 Intersect Icon

6-64 Query Wizard Intersect Editor Dialog

6-65 Minus Icon

6-66 Query Wizard Minus Editor Dialog

6-67 IStream Icon

6-68 Query Wizard IStream Editor Dialog

6-69 DStream Icon

6-70 Query Wizard DStream Editor Dialog

6-71 RStream Icon

6-72 Query Wizard RStream Editor Dialog

6-73 Output Icon

6-74 Query Wizard Output Editor Dialog

6-75 Query Wizard Expression Builder

6-76 Query Wizard User-defined templates Tab

6-77 Query Wizard Tools

6-78 Oracle CQL Processor Panel

6-79 Query Plan Tab

6-80 Query Plan Preference Dialog

6-81 Query Plan While Getting Statistics

6-82 Query Plan Showing Dependencies

6-83 Query Plan Tools

7-1 EPL Processor Panel

7-2 EPL Rules Tab

7-3 Create Rule Dialog

7-4 EPL Processor Panel

7-5 EPL Rules Tab

7-6 Delete Rule Dialog

7-7 Delete All Rule Dialog

7-8 EPL Processor Panel

7-9 EPL Rules Tab

7-10 Replace Rule Dialog

7-11 EPL Rules Tab

8-1 History Tab

8-2 Revisions Tab

8-3 History Tab

8-4 Changes Tab

10-1 Applications Tab

10-2 Extension Libraries Tab

10-3 Libraries Tab

11-1 Work Manager Tab

12-1 JMX Tab

13-1 DataSource Tab

13-2 DataSource Tab

13-3 Edit Datasource: Data Source Tab

13-4 Edit Datasource: Global Tx Protocol Tab

13-5 Edit Datasource: Connection Pool Tab

13-6 DataSource Tab

13-7 New Datasource: Data Source Tab

13-8 New Datasource: Global Tx Protocol Tab

13-9 New Datasource: Connection Pool Tab

14-1 HTTP Publish-Subscribe Server Channel List

15-1 Event Inspector Tab

17-1 Event Repository Panel

18-1 Cluster Groups/Server Tab

18-2 Cluster Topology Tab

18-3 Primary Server

18-4 Group Member Tab

18-5 Group Member Tab

18-6 Cluster Topology Tab: Oracle CEP High Availability

18-7 Primary Server

18-8 Cluster Topology Tab: Oracle CEP High Availability and Scalability

18-9 Primary Server

18-10 Oracle Coherence Cluster Topology Tab

18-11 Multi-Nodes Monitor Tab

18-12 Node Detail View Tab

18-13 Cache Chart Tab

18-14 Tuning Tab: Cache Tuning

18-15 Tuning Tab: Node Tuning

18-16 Tuning Tab: Service Tuning

18-17 Cluster Topology Tools

19-1 Logging Services Tab

19-2 Component Log Setting Tab

19-3 Component Log Setting Tab

19-4 Component Log Setting Tab

19-5 Component Log Configuration Delete Confirmation

19-6 Log Query Screen

19-7 Log Query Screen - Logs Displayed

19-8 Sample Console Output for HelloWorld Application

21-1 User Tab

21-2 Add a User Panel

21-3 Change User Panel

21-4 Selecting a User

21-5 Change Password Panel

21-6 Selecting a User

21-7 Delete User Dialog

22-1 Group Tab

22-2 Add a Group Panel

22-3 Selecting a Group

22-4 Change Group Panel

22-5 Selecting a Group

22-6 Delete Group Dialog

23-1 Role Tab

23-2 Add Application Role

23-3 Selecting a Role

23-4 Delete Role Dialog

25-1 SSL Tab

List of Tables

1-1 Panel Controls

1-2 Event Processing Network Context Menu

2-1 Oracle CEP Visualizer Preferences Attributes

4-1 General Tab Properties: Channel

4-2 General Tab Properties: Outbound Channel

4-3 General Tab Properties: Stream

4-4 Properties: Oracle CEP Local Cache

4-5 Profile Information Attributes

4-6 Latency Attributes

4-7 Throughput Attributes

6-1 Query Wizard RSource Editor Attributes

6-2 Query Wizard Source Editor Attributes

6-3 Query Wizard Cache-Table Editor Attributes

6-4 Query Wizard Pattern Editor Attributes: Pattern Tab

6-5 Pattern Quantifiers

6-6 Query Wizard Pattern Editor Attributes: Define Tab

6-7 Query Wizard Pattern Editor Attributes: Subset Tab

6-8 Query Wizard Pattern Editor Attributes: Measure Tab

6-9 Query Wizard Select Editor Attributes: Project Tab

6-10 Query Wizard Select Editor Attributes: Group Tab

6-11 Query Wizard Select Editor Attributes: Condition Tab

6-12 Query Wizard Select Editor Attributes: Order Tab

6-13 Query Wizard Join Editor Attributes

6-14 Query Wizard Window Editor Attributes

6-15 Query Wizard Filter Editor Attributes

6-16 Query Wizard Union Editor Attributes

6-17 Query Wizard Intersect Editor Attributes

6-18 Query Wizard Minus Editor Attributes

6-19 Query Wizard IStream Editor Attributes

6-20 Query Wizard DStream Editor Attributes

6-21 Query Wizard RStream Editor Attributes

6-22 Query Wizard Output Editor Attributes

6-23 Query Wizard Expression Builder Attributes

6-24 Query Plan Preference Attributes

10-1 Deployed Application Attributes

10-2 Application Extension Library Attributes

10-3 Application Library Attributes

13-1 Edit Datasource: Data Source Parameters

13-2 Edit Datasource: Global Tx Protocol Parameters

13-3 Edit Datasource: Connection Pool Parameters

13-4 New Datasource: Data Source Parameters

13-5 New Datasource: Global Tx Protocol Parameters

13-6 New Datasource: Connection Pool Parameters

15-1 Event Inspector Options

17-1 Event Repository Panel Attributes

18-1 Properties You Can Watch on the Multi-Nodes Monitor Tab

18-2 Properties You Can Watch on the Node Detail View Tab

18-3 Columns and Properties for the Cache Chart Tab

18-4 Cache Tuning: Properties

18-5 Cache Tuning: Operations

18-6 Node Tuning: Properties

18-7 Node Tuning: Operations

18-8 Service Tuning: Properties

18-9 Service Tuning: Operations

19-1 Logging Services Options

19-2 Logging Component Name Constants

20-1 Default Oracle CEP Task Roles and Groups

21-1 Add a User Panel Attributes

21-2 Change User Panel Attributes

21-3 Change User Panel Attributes

22-1 Add a Group Panel Attributes

22-2 Change Group Panel Attributes

23-1 Add Application Role Panel Attributes

25-1 SSL Options

Oracle® Fusion Middleware

Visualizer User's Guide for Oracle Complex Event Processing

11g Release 1 (11.1.1.6.0)

E14302-06

November 2011

Documentation for Oracle Complex Event Processing (Oracle CEP) administrators and developers that describes how to use Oracle CEP Visualizer to build, configure, deploy, and manage single- or multi-server event processing applications that incorporate Oracle Continuous Query Language (CQL) and a variety of services.

Oracle Fusion Middleware Visualizer User's Guide for Oracle Complex Event Processing 11g Release 1 (11.1.1.6.0)

E14302-06

Copyright © 2007, 2011,  Oracle and/or its affiliates. All rights reserved.

Primary Author: Steve Traut, Peter Purich

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Preface

This document describes how to use the Oracle CEP Visualizer to manage Oracle CEP applications and servers at runtime.

Oracle CEP (formally known as the WebLogic Event Server) is a Java server for the development of high-performance event driven applications. It is a lightweight Java application container based on Equinox OSGi, with shared services, including the Oracle CEP Service Engine, which provides a rich, declarative environment based on Oracle Continuous Query Language (Oracle CQL) - a query language based on SQL with added constructs that support streaming data - to improve the efficiency and effectiveness of managing business operations. Oracle CEP supports ultra-high throughput and microsecond latency using JRockit Real Time and provides Oracle CEP Visualizer and Oracle CEP IDE for Eclipse developer tooling for a complete real time end-to-end Java Event-Driven Architecture (EDA) development platform.

Audience

This document is intended for all users of Oracle CEP.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Documents

For more information, see the following:

Oracle CEP Getting Started

Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

Oracle Fusion Middleware Java API Reference for Oracle Complex Event Processing

Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

Oracle Fusion Middleware EPL Language Reference for Oracle Complex Event Processing

Oracle Database SQL Language Reference at http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/toc.htm

SQL99 Specifications (ISO/IEC 9075-1:1999, ISO/IEC 9075-2:1999, ISO/IEC 9075-3:1999, and ISO/IEC 9075-4:1999)

Oracle CEP Forum: http://forums.oracle.com/forums/forum.jspa?forumID=820

Oracle CEP Samples: http://www.oracle.com/technologies/soa/complex-event-processing.html

Oracle Event Driven Architecture Suite sample code: http://www.oracle.com/technology/sample_code/products/event-driven-architecture

Conventions

The following text conventions are used in this document:

Convention | Meaning
boldface | Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic | Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace | Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

Part I

Introduction

Part I contains the following chapters:

Chapter 1, "Overview of Oracle CEP Visualizer"

Chapter 2, "Using Oracle CEP Visualizer"

1 Overview of Oracle CEP Visualizer

This chapter introduces Oracle CEP Visualizer, a browser-based tool with which you can view, develop, and configure aspects of Oracle Complex Event Processing (Oracle CEP) event-driven applications, including security, Oracle Continuous Query Language (CQL) rules, diagnostics, and more.

Section 1.1, "Overview of Using Oracle CEP Visualizer"

Section 1.2, "Understanding the Oracle CEP Visualizer User Interface"

Section 1.3, "Understanding Oracle CEP Visualizer Administration Tasks"

Section 1.4, "Who Uses Oracle CEP Visualizer?"

Section 1.5, "National Language Support"

Section 1.6, "Next Steps"

1.1 Overview of Using Oracle CEP Visualizer

Oracle CEP Visualizer is a Web 2.0 application that consumes data from Oracle Complex Event Processing Server (or Oracle CEP for short), displays it in a useful and intuitive way to system administrators and operators, and, for specified tasks, accepts data that is then passed back to Oracle CEP so as to change its configuration.

Oracle CEP Visualizer is itself an Oracle CEP application that is automatically deployed each time you start a server. You invoke Oracle CEP Visualizer in a browser to use it.

In particular, you can use the tool to perform the following tasks:

View the structure of an Oracle CEP domain

Manage security

Configure Oracle CEP server instances

Install, uninstall, suspend, resume, and update applications

View, update, create, and delete Oracle CQL and EPL rules

View the EPN associated with an application

Tune application parameters and monitor application status

Record and playback of events flowing through the EPN.

Create diagnostic profile to monitor application stage latency and throughput.

Monitor and perform diagnosis on your CQL Processor with Query Plan.

Manage and create server wide resources such as HTTP publish-subscribe channels and data sources.

Dynamically turn server and application logging on and off.

Manage Oracle Coherence cluster and server instances.

This section describes:

Section 1.2, "Understanding the Oracle CEP Visualizer User Interface"

Section 1.3, "Understanding Oracle CEP Visualizer Administration Tasks"

Section 1.4, "Who Uses Oracle CEP Visualizer?"

1.2 Understanding the Oracle CEP Visualizer User Interface

As Figure 1-1 shows, the Oracle CEP Visualizer has the following main panes:

Section 1.2.1, "Top Pane"

Section 1.2.2, "Left Pane"

Section 1.2.3, "Right Pane"

Figure 1-1 Sample Oracle CEP Visualizer Window

Figure 1-1 shows a domain that contains a single server instance called NonClusteredServer. The server contains four deployed applications: com.bea.wlevs.dataservices, cql, fx, and signalgeneration; the signalgeneration application is currently opened. The right pane contains the configuration of the rules of the processor1 stage; in particular, processor1 has been configured with rules vTrend, trend, percent, and S. The application called com.bea.wlevs.dataservices is associated with Oracle CEP Visualizer itself and is always deployed in an Oracle CEP server instance. Section 1.3.1.1, "The com.bea.wlevs.dataservices Application" for details.

1.2.1 Top Pane

This pane includes the most used buttons:

Home button that takes you to the main Oracle CEP Visualizer page.

Security button that takes you to the security page in which you can add or configure users and groups and map users to application roles and task roles; see Chapter 20, "Overview of Security Tasks" for details.

Dashboard button takes you to the performance management screen that you use to monitor the throughput and latency of a running application and its stages; see Section 1.2.4, "Overview of the Oracle CEP Visualizer Dashboard" for more information.

ViewStream button takes you to a screen from which you can monitor the messages streaming through the configured HTTP publish-subscribe channels; see Section 1.2.5, "Overview of the Stream Visualizer (ViewStream) Panel" for more information.

Full Screen button fills your entire computer screen with the Oracle CEP Visualizer tool; press the Esc key to return to a normal screen.

Preferences button takes you to a page where you can set user preferences, such as the language and maximum number of open panes, and accessibility settings such as restricting the maximum number of open panes to 1 and disabling Full Screen mode.

Help button takes you to the task-oriented online-help hosted by the Oracle CEP server.

1.2.2 Left Pane

This pane displays a domain tree for the domain that includes all the objects contained in the domain, such as the Oracle CEP server instances, the deployed applications and services within each server instance, and domain-level security configuration.

The domain name is determined by the Oracle CEP server config.xml file domain element. For example, the domain tree is named mydomain if your config.xml file is like this:

<domain>
    <name>mydomain</name>
</domain>

The Open Items box in the lower half of the left pane lists the items that are currently open, making it easy to return to or close the windows after you have navigated away from them. Any open panels that require refresh are marked with a red X in the Open Items list. For more information, see Section 1.2.7, "Oracle CEP Visualizer Panels that Require Refresh".

1.2.3 Right Pane

This pane is a multi-document container. When you open multiple documents, the documents are overlaid one on top of the other.

This pane displays information about objects that you have clicked on in the left pane. The format of the information depends on the object; for example, if you click on a deployed application in the domain tree in the left pane, the right pane shows general information about the application (General tab) as well as various visual representations of the event processing network of the application (Event Processing Network tab). If you click on a particular stage of the network, such as a stream or processor, the right pane shows general information about it as well as stage-specific information, such as the rules for a processor. For more information, see Section 1.2.6, "Overview of the Event Processing Network".

Any open panels that require refresh are marked with a red X in the title of the panel. For more information, see Section 1.2.7, "Oracle CEP Visualizer Panels that Require Refresh".

Table 1-1 describes the buttons in the top right corner of the right pane that you can use to manage panels. Note that these buttons are not visible if you set the Max Open Panels preference to 1 (see Section 2.2, "Managing User Preferences").

Table 1-1 Panel Controls

Button
Description

Minimize panel.

Maximize panel to full window size.

Maximize panel.

Close all panels.

Close panel.

1.2.4 Overview of the Oracle CEP Visualizer Dashboard

Figure 1-2 shows the Oracle CEP Visualizer dashboard: a performance management screen that you use to monitor the throughput and latency of a running application and its stages or a path between two stages. You get to the dashboard by clicking the Dashboard button in the top pane.

Figure 1-2 Oracle CEP Visualizer Dashboard

The dashboard has two main sections:

Management Events: the section at the top of the dashboard displays information and warning messages about the incoming monitoring events. Click the Warning bar to view the list of warning messages; click the Information bar to view the list of information messages. The Oracle CEP Visualizer monitoring feature defines a set of default EPL rules that specify when these alerts show up in the Management Events table; you can change the EPL rules to customize this behavior; see Section 7.4, "Changing the dataservices Application Event Filter Rule Using EPL".

Performance Monitoring: the latency and throughput graphs display the amount of time it takes an event to pass through the specified stage or path in the EPN or the number of events passing through, respectively. The stage or path is defined in the diagnostic profile. The table at the bottom lists the available diagnostic profiles; when you click on a particular profile, the corresponding latency and throughput information is displayed in the graphs. See Section 4.6, "Monitoring the Throughput and Latency of a Stage or Path in the EPN" for details.

For detailed instructions on how to use this monitoring feature, see Section 4.6, "Monitoring the Throughput and Latency of a Stage or Path in the EPN".

1.2.5 Overview of the Stream Visualizer (ViewStream) Panel

The main purpose of the ViewStream panel is to allow users to watch events being published to a given HTTP publish-subscribe channel without any additional work. This is useful for debugging your application or just monitoring events flowing through the EPN.

Click the ViewStream button in the top panel of Oracle CEP Visualizer, to display the Stream Visualizer panel as Figure 1-3 shows.

Figure 1-3 Oracle CEP Visualizer Stream Visualizer (ViewStream)

The Pub/Sub Server URL text box displays the HTTP pub-sub server URL included with Oracle CEP. Click the Initialize Client button to start the process. You can either subscribe or publish a message to a channel using the options mentioned in this panel.

You can subscribe to a user or internal channel and view the events on it or you can publish to a user or internal channel.

For more information, see:

Section 4.4, "Tracing and Injecting Events in the EPN"

Chapter 14, "Managing HTTP Publish-Subscribe Servers"

1.2.6 Overview of the Event Processing Network

The main purpose of the Event Processing Network (EPN) panel is to give users an overall view of the stages in an Oracle CEP application and the various event types they produce and consume.

In the left pane, navigate to and expand the Applications node, select an application, and in the right pane, click the Event Processing Network tab to view the EPN as Figure 1-4 shows.

Figure 1-4 Event Processing Network Panel

1.2.6.1 Event Processing Network Context Menu

You can right-click any stage in the Event Processing Network and select one of the options from the Event Processing Network context menu that Table 1-2 describes.

Table 1-2 Event Processing Network Context Menu

Option
Description

Open Panel

Opens the General tab for the selected stage.

See Section 4.2, "Viewing and Editing the Configuration of a Stage".

Record Event

Opens the Record tab for the selected stage.

See Section 4.3.1, "How to Record Events".

Playback Event

Opens the Playback tab for the selected stage.

See Section 4.3.2, "How to Playback Events".

Trace Event

Opens the Trace Event tab for the selected stage.

See Section 4.4.1, "How to Trace Events on a Dynamic Channel".

Inject Event

Opens the Inject Event tab for the selected stage.

See:

Section 4.4.2, "How to Inject a Simple Event on an Event Inspector Service Dynamic Channel"

Section 4.4.3, "How to Inject an Event as a JSON String on an Event Inspector Service Dynamic Channel"

1.2.7 Oracle CEP Visualizer Panels that Require Refresh

Some operations, such as uninstalling and redeploying an application, will require you to refresh open panels.

When CEPVIS receives a notification for application re-deployment, it goes though all the affected panels that are still opened and marks the title of the panel with a red X to indicate that this panel is obsolete. To refresh such a panel, close and then re-open the panel.

For example, Figure 1-5 shows the Event Processing Network tab for an application that has been redeployed.

Figure 1-5 Event Processing Network Tab - Requiring Refresh

1.3 Understanding Oracle CEP Visualizer Administration Tasks

This section describes the principle administration tasks you can perform using the Oracle CEP Visualizer, including:

Section 1.3.1, "Managing Oracle CEP Applications"

Section 1.3.2, "Managing Oracle CEP Servers"

Section 1.3.3, "Managing Security"

Section 1.3.4, "Updating Configuration Data"

1.3.1 Managing Oracle CEP Applications

Using Oracle CEP Visualizer, you can monitor and configure applications you develop and deploy as well as applications that Oracle CEP server deploys such as the com.bea.wlevs.dataservices application. You can monitor and configure the Event Processing Network (EPN), application lifecycle, and Oracle CQL and EPL rules.

For more information, see:

Chapter 3, "Overview of Application Tasks"

Section 1.3.1.1, "The com.bea.wlevs.dataservices Application"

1.3.1.1 The com.bea.wlevs.dataservices Application

The com.bea.wlevs.dataservices application, called dataservices for short, is internal to Oracle CEP Visualizer and is automatically deployed every time you start an Oracle CEP server instance. You are not allowed to uninstall the dataservices application.

The purpose of this application is to provide a filter for diagnostic monitoring metrics. The application is itself an Oracle CEP application made up of adapters, streams, and a processor. The processor includes the following default EPL rule used to filter the metrics; this rule determines which event show up in the Diagnostics dashboard. The rule is as follows:

SELECT * FROM DSMonitorEvent RETAIN 1 EVENT WHERE metric > 10000

You can change this rule if you want to customize the filtering of events. See Section 7.4, "Changing the dataservices Application Event Filter Rule Using EPL" for details.

1.3.2 Managing Oracle CEP Servers

Using Oracle CEP Visualizer, you can manage Oracle CEP server instances and the services they provide such as JMX, data sources, Jetty Web server, work managers, the persistent event store, event type repository, HTTP publish-subscribe server, and logs.

For more information, see Chapter 9, "Overview of Server and Domain Tasks".

1.3.3 Managing Security

Using Oracle CEP Visualizer, you can manage Oracle CEP server and application security including users, groups, and roles, SSL, and HTTP publish-subscribe server access.

For more information, see Chapter 20, "Overview of Security Tasks".

1.3.4 Updating Configuration Data

Although you can update much of the configuration of an Oracle CEP instance and its deployed applications, not all fields can be updated. The following rules determine what fields can be updated:

Information in the EPN assembly file is static and thus read-only. Examples of this type of information include the stages of the EPN and how they are wired together.

Information in the component configuration files can be modified, although not typically added to or deleted from; the next bullet lists the two exceptions. Examples of this type of information include the maximum size and threads of a stream.

When you are allowed to update fields on a Oracle CEP Visualizer window, you will see three buttons: Edit, Save, and Cancel. Click the Edit button to modify the fields, then click Save to commit the changes to the server or Cancel to cancel.

The Oracle CQL and EPL rules associated with a processor and the channels associated with an HTTP publish-subscribe server cannot be modified, but you can add or delete to the existing list of rules or channels.

For these two scenarios you will see buttons for adding and deleting rules or channels; the Modify button will not be provided.

Some information in the Oracle CEP server's configuration file (config.xml) can be modified, although much of it is read-only. An example of this type of information includes the configuration of work managers, the logging service, and user-defined channels of the HTTP publish-subscribe server.

Note:

Do not modify or delete the internal channels of the HTTP publish-subscribe server. If you modify or delete these internal channels, Oracle CEP Visualizer will not function properly

Server configuration updates also use the three buttons: Edit, Save, and Cancel.

Note:

The preceding rules assume that you have logged onto Oracle CEP Visualizer with the required authentication credentials for performing the desired update task.

For more information, see Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

1.4 Who Uses Oracle CEP Visualizer?

Oracle CEP Visualizer provides valuable services to a variety of Oracle CEP users, including:

Section 1.4.1, "Administrators"

Section 1.4.2, "Developers"

Section 1.4.3, "Business Users"

1.4.1 Administrators

Administrators who use Oracle CEP Visualizer to connect to an Oracle CEP instance use role-based authorization to gain access. Users that successfully authenticate themselves when using Oracle CEP Visualizer are assigned roles based on their group membership, and then subsequent access to administrative functions is restricted according to the roles held by the user. Anonymous users (non-authenticated users) will not have any access to Oracle CEP Visualizer.

When an administrator uses the Configuration Wizard to create a new domain, they enter an administrator user that will be part of the wlevsAdministrators group. By default, this information is stored in a file-based provider filestore. The password is hashed using the SHA-256 algorithm. Once the domain has been created, the administrator can create new groups using Oracle CEP Visualizer, assign roles to them, and then create new users and assign them to groups.

For more information, see Section 20.1, "User, Group, and Role Management".

Note:

The security features of Oracle CEP Visualizer work only if you have security enabled for Oracle CEP server. If you disable Oracle CEP server security, then:

Oracle CEP Visualizer does not provide default users, groups, and roles.

You cannot create new users, groups, and roles.

There is still a login page when first entering Oracle CEP Visualizer but you may enter anything for user and password.

Anonymous users may access the Oracle CEP Visualizer.

For more information, see "Enabling and Disabling Security" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

1.4.2 Developers

Developers can use Oracle CEP Visualizer to view server resources (such as data sources), perform event record and playback, and trouble shoot performance issues by turning on latency and throughput statistics.

1.4.3 Business Users

Business users can use the Oracle CEP Visualizer Query Wizard to create and modify queries within a given processor. This allows rule experts to manage Oracle CQL queries and views with minimal development assistance.

1.5 National Language Support

Oracle CEP Visualizer observes Java localization and supports the use of double-byte characters in all configuration files and Oracle CEP Visualizer text entry fields.

This section describes topics of interest when using Oracle CEP Visualizer with double-byte locales, including:

Section 1.5.1, "Configuration File Encoding: UTF-8"

Note:

By default, Oracle CEP Visualizer ships with an English resource bundle that supplies all the text that appears in the Oracle CEP Visualizer user interface.

1.5.1 Configuration File Encoding: UTF-8

Oracle CEP server encodes all configuration XML files using UTF-8 encoding. This encoding is specified in the header of all Oracle CEP configuration XML files. Example 1-1 shows the encoding specified in the config.xml file.

Example 1-1 UTF-8 Encoding Attribute in Oracle CEP Server config.xml

<?xml version="1.0" encoding="UTF-8"?>
<n1:config xsi:schemaLocation="http://www.bea.com/ns/wlevs/config/server wlevs_server_config.xsd"
    xmlns:n1="http://www.bea.com/ns/wlevs/config/server"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <domain>
        <name>WLEventServerDomain</name>
    </domain>

    <netio>
        <name>NetIO</name>
        <port>9002</port>
    </netio>

    ...
</config>

When manually editing an Oracle CEP configuration XML file, be sure to save the file in UTF-8 encoding. Some editors will automatically save configuration XML files in the correct encoding based on the encoding attribute. However, some editors will not automatically save configuration XML files in the correct encoding. In this case, you must ensure that you select UTF-8 encoding when you save an Oracle CEP configuration XML file.

You can enter double-byte characters in any Oracle CEP Visualizer text field. The Oracle CEP Visualizer and Oracle CEP server will always write configuration XML files in the correct UTF-8 encoding.

1.6 Next Steps

For more information, see:

Chapter 2, "Using Oracle CEP Visualizer"

Part II, "Application Tasks"

Part III, "Server and Domain Tasks"

Part IV, "Security Tasks"

2 Using Oracle CEP Visualizer

This chapter describes how to start and set preferences for Oracle CEP Visualizer, an application management tool provided with Oracle Complex Event Processing (Oracle CEP).

Section 2.1, "Starting the Oracle CEP Visualizer"

Section 2.2, "Managing User Preferences"

Section 2.3, "Improving Oracle CEP Visualizer Accessibility"

For more information, see Chapter 1, "Overview of Oracle CEP Visualizer".

2.1 Starting the Oracle CEP Visualizer

Before you start Oracle CEP Visualizer, ensure that your system meets the minimum prerequisites as Section 2.1.1, "Prerequisites" describes.

Choose how you want to start Oracle CEP Visualizer:

Section 2.1.2, "How to Start Oracle CEP Visualizer Using a Browser"

Section 2.1.3, "How to Start Oracle CEP Visualizer Using Oracle CEP IDE for Eclipse"

Section 2.1.4, "How to Start Oracle CEP Visualizer in a Multi-Server Domain"

After you start Oracle CEP Visualizer, you are ready to begin using Oracle CEP Visualizer to manage, configure, and monitor Oracle CEP instances and the applications deployed to the server instances. For information on typical tasks, see:

Part II, "Application Tasks"

Part III, "Server and Domain Tasks"

Part IV, "Security Tasks"

2.1.1 Prerequisites

Before starting Oracle CEP Visualizer, the following prerequisites must be met:

For best performance, install version 10,0,22,87 of the Adobe Flash Player.

For instructions on testing the current version of Flash Player installed on your computer, see the Version test for Adobe Flash Player Web site: http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_15507.

For more information, see http://www.adobe.com/products/flashplayer/.

You must configure your computer display for a resolution of 1024x768 or higher.

Oracle recommends that you use Internet Explorer 7 or higher.

For some Oracle CEP Visualizer tasks, you must log into Oracle CEP Visualizer using an Oracle CEP server account configured for the administrator role. For more information, see Section 20.1, "User, Group, and Role Management".

2.1.2 How to Start Oracle CEP Visualizer Using a Browser

You can start the Oracle CEP Visualizer using any browser that meets the minimum perquisites as Section 2.1.1, "Prerequisites" describes.

To start Oracle CEP Visualizer using a browser:

Confirm that your browser meets the necessary requirements.

See Section 2.1.1, "Prerequisites".

Invoke the following URL in your browser:

http://host:port/wlevs

where host refers to the name of the computer on which Oracle CEP is running and port refers to the Jetty NetIO port configured for the server (default value 9002).

The port number is configured in the config.xml file in the ORACLE_CEP_HOME/user_projects/domains/DOMAIN_DIR/servername/config directory, where ORACLE_CEP_HOME refers to the Oracle CEP installation directory (such as d:/oracle_cep), DOMAIN_DIR refers to the domain directory (such as my_domain), and servername refers to the server instance directory (such as server1). The port number is the value of the port child element of the netio object configured for the Jetty server, as shown in the following example (only relevant parts shown):

    <netio>
        <name>NetIO</name>
        <port>9002</port>
    </netio>
    ...
    <jetty>
        <name>JettyServer</name>
        <network-io-name>NetIO</network-io-name>
        ...
    </jetty>

For example, if your browser is running on the same computer as Oracle CEP and you are using the default port, invoke the following URL:

http://localhost:9002/wlevs

If you want to use HTTPS to connect to Oracle CEP Visualizer, specify the SSL port number. This is the port assigned to the netio element referenced by the secure-network-io-name Jetty element. The default value is 9003.

For example, if you have the following configuration (only relevant parts shown):

    <netio>
        <name>sslNetIo</name>
        ...
        <port>9003</port>
    </netio>
    <jetty>
        ...
        <secure-network-io-name>sslNetIo</secure-network-io-name>
    </jetty>

use the following URL:

https://localhost:9003/wlevs

The Logon screen appears as Figure 2-1 shows.

Figure 2-1 Oracle CEP Visualizer Logon Screen

In the Logon screen, enter the name and password of the administrator user you configured when you created the domain.

Note:

The security features of Oracle CEP Visualizer work only if you have security enabled for Oracle CEP server. If you disable Oracle CEP server security, then:

Oracle CEP Visualizer does not provide default users, groups, and roles.

You cannot create new users, groups, and roles.

There is no login page when first entering Oracle CEP Visualizer.

For more information, see "Enabling and Disabling Security" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

Click Logon.

2.1.3 How to Start Oracle CEP Visualizer Using Oracle CEP IDE for Eclipse

Oracle provides an IDE targeted specifically to programmers that want to develop Oracle CEP applications. Oracle CEP IDE for Eclipse is a set of plugins for the Eclipse IDE designed to help develop, deploy, and debug applications for Oracle CEP. You can start the Oracle CEP Visualizer from within the Oracle CEP IDE for Eclipse to make using Oracle CEP Visualizer a seamless part of Oracle CEP application development.

For more information, see "How to Start the Oracle CEP Visualizer from Oracle CEP IDE for Eclipse" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

2.1.4 How to Start Oracle CEP Visualizer in a Multi-Server Domain

You can use Oracle CEP Visualizer to administer a multi-server domain. As described in Section 2.1.2, "How to Start Oracle CEP Visualizer Using a Browser," Oracle CEP Visualizer works by connecting to one particular Oracle CEP server, based on its host and port.

In the case of a multi-server domain, you connect to one Oracle CEP server in the domain and then access the other servers from that server. All servers in a multi-server domain are candidates to host Oracle CEP Visualizer, from which you administer all the other servers in the domain. However, considering the performance factor, it is recommended that you select one server to host Oracle CEP Visualizer and disable Oracle CEP Visualizer access from all servers except for one in the multi-server domain.

To avoid a single point of failure, consider enabling Oracle CEP Visualizer on a small subset of n machines in the domain.

When using Oracle CEP Visualizer in a multi-server domain, the navigation tree in the left pane is automatically refreshed to reflect changes in the domain. For example, when a new server joins the domain, it automatically shows up in the navigation tree. Conversely, if the server leaves the domain, the server automatically disappears from the navigation tree.

Note:

The server-host-name element is mandatory if one or more Oracle CEP servers in your multi-server domain are on different hosts and you plan to manage the multi-server domain using the Oracle CEP Visualizer. It is also mandatory if a server is deployed on a host machine that has multiple IP addresses configured (whether in a multi-server or standalone-server environment). You must configure cluster element child element server-host-name in the config.xml of each Oracle CEP server.

For more information, see "Introduction to Multi-Server Domains" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

You can perform configuration management, of both the servers and applications, and operation management (such as diagnostics and event record and playback) on all servers in the multi-server domain.

To start Oracle CEP Visualizer in a multi-server domain:

Create a multi-server domain.

For example, assume you have a multi-server domain with three servers (defaultserver, server1, and server2). Each server directory is a child directory of the domain directory, which is /oracle_cep/user_projects/domains/myDomain.

For more information, see "Multi-Server Domain Directory Structure" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

Configure SSL to secure communication between the servers in the multi-server domain.

For more information, see "Securing the Messages Sent Between Servers in a Multi-Server Domain" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

Choose one Oracle CEP server in the multi-server domain to host Oracle CEP Visualizer access.

In this example, defaultserver will host Oracle CEP Visualizer access.

Specify the -disablevisualizer flag when you start the other servers in the multi-server domain that will not provide access to Oracle CEP Visualizer.

You want the defaultserver to host Oracle CEP Visualizer and thus must disable access to Oracle CEP Visualizer from the other two servers. In this case, you would start each server as follows:

  prompt> cd /oracle_cep/user_projects/domains/myDomain/defaultserver
  prompt> startwlevs
  prompt> cd ../server1
  prompt> startwlevs -disablevisualizer
  prompt> cd ../server2
  prompt> startwlevs -disablevisualizer

Configure SSL to secure communication between Oracle CEP Visualizer and defaultserver.

For more information, see "How to Configure SSL in a Multi-Server Domain for Oracle CEP Visualizer" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

Start Oracle CEP Visualizer.

For more information, see:

Section 2.1.2, "How to Start Oracle CEP Visualizer Using a Browser"

Section 2.1.3, "How to Start Oracle CEP Visualizer Using Oracle CEP IDE for Eclipse"

2.2 Managing User Preferences

Oracle CEP Visualizer allows you to customize its behavior using user preferences.

2.2.1 How to Manage User Preferences

You can use Oracle CEP Visualizer to manage user preferences.

To manage user preferences:

Click the Preference button at the top-right corner of any Oracle CEP Visualizer screen. The Preference screen appears in the right panel, as shown in Figure 2-2.

Figure 2-2 The Preference Screen

Update the preferences as Table 2-1 describes:

Table 2-1 Oracle CEP Visualizer Preferences Attributes

Attribute
Description

Select Language

Select the language that Oracle CEP Visualizer uses.

Default: English.

For more information, see Section 1.5, "National Language Support".

Client Idle Timeout: (Minutes)

Set the time, in minutes, after which the client (browser) times out and automatically logs you out.

Default value is 20 minutes, maximum 30.

Max Opened Panels

Set the maximum number of open items that will appear in the Open Items frame in the lower left corner.

Default value is 5; maximum value is 10.

NOTE: For users that require accessibility, set the maximum open items to 1 to make keyboard navigation easier to use. For more information, see Section 2.3, "Improving Oracle CEP Visualizer Accessibility".

Expand All Tree Nodes at Start

Click whether you want the domain tree in the left panel to be fully expanded every time you start Oracle CEP Visualizer

Enable Fullscreen

Click whether you want to enable the full screen function in Oracle CEP Visualizer.

NOTE: For users that require accessibility, uncheck this item. For more information, see Section 2.3, "Improving Oracle CEP Visualizer Accessibility"

Click Save.

When the preferences have been successfully modified, a confirmation message appears momentarily.

2.3 Improving Oracle CEP Visualizer Accessibility

Oracle CEP Visualizer is a Web application that uses Adobe Flex. This section describes how to improve the accessibility of Oracle CEP Visualizer when using a screen reader like JAWS.

For more information, see:

"Documentation Accessibility"

http://www.adobe.com/accessibility/products/flex/jaws.html

To improve Oracle CEP Visualizer accessibility:

Open the Oracle CEP Visualizer preferences panel.

See Section 2.2, "Managing User Preferences".

Set the Max Opened Panels option to 1.

Uncheck the Enable Fullscreen option.

Click Save.

Part II

Application Tasks

Part II contains the following chapters:

Chapter 3, "Overview of Application Tasks"

Chapter 4, "Managing the Event Processing Network"

Chapter 5, "Managing Application Lifecycle"

Chapter 6, "Managing Oracle CQL Rules"

Chapter 7, "Managing EPL Rules"

Chapter 8, "Managing Configuration History"

3 Overview of Application Tasks

This chapter introduces the typical application tasks you can perform with Oracle CEP Visualizer, including managing event processing networks (EPNs), application lifecycle, Oracle Continuous Query Language (CQL) rules, and configuration history.

Section 3.1, "Event Processing Network (EPN) Management"

Section 3.2, "Application Lifecycle Management"

Section 3.3, "Rules Management"

Section 3.4, "Configuration History Management"

3.1 Event Processing Network (EPN) Management

The Oracle CEP Event Processing Network (EPN) represents the interconnections between the various Oracle CEP components of an Oracle CEP application. Using Oracle CEP Visualizer, you can manage the EPN, including viewing and changing the configuration of a stage, recording and playing back events, and monitoring the throughput and latency of a stage or path. Right-click a stage to select common stage-related functions from a convenient context menu.

For more information, see:

Chapter 4, "Managing the Event Processing Network"

Section 1.2.6.1, "Event Processing Network Context Menu"

"Components of the Oracle CEP Event Processing Network" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

3.2 Application Lifecycle Management

You can manage the full application lifecycle including uploading an application, deploying it, suspending and resuming the application, and undeploying the application.

For more information, see:

Chapter 5, "Managing Application Lifecycle"

"Oracle CEP Application Lifecycle" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

3.3 Rules Management

You can create, replace, and delete the rules in the Oracle CQL and EPL processors of Oracle CEP applications you develop and deploy as well as applications that Oracle CEP server deploys.

It is important to note that Oracle CEP Visualizer will update your configuration file on the server with any queries that you create. However, you will not see this take effect in your application from within the Oracle CEP IDE for Eclipse, in order to make the change there you will need to copy and paste the query from Oracle CEP Visualizer into your application.

For more information, see:

Chapter 6, "Managing Oracle CQL Rules"

Chapter 7, "Managing EPL Rules"

3.4 Configuration History Management

Using the Oracle CEP Visualizer, you can manage the configuration changes you make to Oracle CEP components. You can review change history and you can undo (roll back) changes to an earlier version. You can perform these operations on a given resource or application in both standalone-server and multi-server domains.

Alternatively, you can manage configuration history using the wlevs.Admin command-line tool.

For more information, see:

Section 3.4.1, "Enabling and Disabling Configuration History Management"

Section 3.4.2, "Resource Configuration History Management"

Section 3.4.3, "Application Configuration History Management"

Section 3.4.4, "Application Lifecycle and Configuration History Management"

Section 3.4.5, "Multi-Server Domains and Configuration History Management"

Chapter 8, "Managing Configuration History"

"Commands for Managing Configuration History" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

3.4.1 Enabling and Disabling Configuration History Management

By default, Oracle CEP provides resource and application configuration history management.

Optionally, you can disable this feature by editing the CEP_SERVER/startwlevs.cmd/sh file and adding the com.oracle.ocep.config.version.enabled system property to the last line (in practice, the command should be on one line):

"$JAVA_HOME/bin/java" $JVM_ARGS $DEBUG_ARGS -Dwlevs.home="$USER_INSTALL_DIR"
    -Dcom.oracle.ocep.config.version.enabled=false -Dbea.home="$BEA_HOME"
    -jar "${USER_INSTALL_DIR}/bin/wlevs.jar" $ARGS

If you disable this feature, Oracle CEP cannot propagate rules amongst the Oracle CEP servers in a multi-server domain. In this case, to propagate rule changes, you must manually update the rules in all the servers of a multi-server domain.

If you disable this feature and then wish to re-enable it, you must do so as follows:

Undeploy your Oracle CEP application.

Shut down the Oracle CEP server.

Edit the startwlevs.cmd/sh file to either remove the -Dcom.oracle.ocep.config.version.enabled system property or set it to true.

Start the Oracle CEP server.

Deploy your Oracle CEP application.

Failure to do so may cause rule propagation to fail in a multi-server domain and may prevent the Oracle CEP Visualizer from maintaining a consistent view of the Oracle CEP servers in a multi-server domain.

3.4.2 Resource Configuration History Management

You can manage the configuration history of the following Oracle CEP resources:

Oracle CEP high availability adapters

Oracle CQL rules

For more information, see Section 8.1, "Managing Resource Configuration History".

3.4.3 Application Configuration History Management

You can manage the configuration history for a given application. This allows you to see a summary of all the configuration changes made to all resources of a given application.

For more information, see Section 8.2, "Managing Application Configuration History".

3.4.4 Application Lifecycle and Configuration History Management

When you deploy an application, the Oracle CEP server creates a new configuration history for the application.

When you update an application, the Oracle CEP server erases the existing configuration history and creates a new configuration history for the application.

When you uninstall an application, the Oracle CEP server erases the configuration history for the application.

For more information, see Section 3.2, "Application Lifecycle Management".

3.4.5 Multi-Server Domains and Configuration History Management

When you deploy an application to a multi-server domain, consider the following configuration history management restrictions:

Section 3.4.5.1, "Rejoining a Multi-Server Domain"

Section 3.4.5.2, "Simultaneous Updates"

For more information, see Section 9.8, "Multi-Server Domain Management".

3.4.5.1 Rejoining a Multi-Server Domain

When an Oracle CEP server joins (or rejoins) a multi-server domain, the server's existing configuration history records (if any) are deleted and replaced with the current multi-server domain configuration history when the Oracle CEP server has synchronized with the primary.

3.4.5.2 Simultaneous Updates

Oracle CEP does not support simultaneous configuration updates from more than one Oracle CEP server in a multi-server domain.

Make configuration changes from one Oracle CEP Visualizer instance on one node in the multi-server domain.

4 Managing the Event Processing Network

This chapter describes how you can use Oracle CEP Visualizer to manage the event processing networks (EPNs) of a deployed Oracle CEP application. It includes information on viewing the EPN graphically, recording and playing back event flow for debugging, tracing and injecting events, and monitoring channels and throughput.

Section 4.1, "Viewing the EPN of an Application"

Section 4.2, "Viewing and Editing the Configuration of a Stage"

Section 4.3, "Recording and Playing Back Events in the EPN"

Section 4.4, "Tracing and Injecting Events in the EPN"

Section 4.5, "Monitoring a Channel Stage in the EPN"

Section 4.6, "Monitoring the Throughput and Latency of a Stage or Path in the EPN"

For more information, see Section 3.1, "Event Processing Network (EPN) Management".

4.1 Viewing the EPN of an Application

Using the Oracle CEP Visualizer, you can view the EPN of a deployed application.

4.1.1 How to View the EPN of an Application

You can use the Oracle CEP Visualizer to view the EPN of a deployed application.

To view the EPN of an application:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application whose EPN you want to view.

In the right pane, click the Event Processing Network tab.

The Event Processor Network panel is displayed as Figure 4-1 shows.

Figure 4-1 Event Processing Network Panel

The name of a stage appears above the stage in black text. For example, there is an Oracle CQL processor called FindCrossRates and the name of its inbound channel is FxQuoteStream.

The name of the event type transmitted on a given channel is shown below the connecting line in blue text. For example, the event type transmitted on the FxQuoteStream is CrossRateEvent.

To navigate to areas of the EPN that are off the screen, click in the miniature EPN view, and drag.

To change the layout of the EPN, select a layout option from the Layout menu:

organic

tree

hierarchic (default)

balloon

orthogonal

To change the way the EPN fits in the browser window:

Click on the Zoom slider and drag to the right to increase the zoom level; drag left to decrease the zoom level.

Click the Fit Content button to automatically adjust the zoom level to make all of the EPN visible in the browser window; click the Actual Size button to reset the zoom level to zero.

Click the Zoom Out (+) button or Zoom In (-) button.

4.2 Viewing and Editing the Configuration of a Stage

Using Oracle CEP Visualizer, you can view the configuration of any stage and change the configuration for some stages.

Note:

Any changes to rules and Oracle high availability adapters are propagated to the other servers in the same group. That is, all rule and and Oracle high availability adapter configurations is automatically synchronized. Other configuration changes are not synchronized. For example, if you change record/playback or JMS adapter configuration on one server in a multi-server domain, then these changes are not synchronized with the other servers in the same group. For more information, see Chapter 18, "Managing Multi-Server Domains"

4.2.1 How to View and Edit the Configuration of a Stage

You can view and change the configuration of a stage using the Oracle CEP Visualizer.

To view and edit the configuration of a stage:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want.

Select the stage you wish to view and configure:

To use the EPN diagram:

Click the Event Processing Network tab.

Double-click the stage you wish to view or Right-click the stage and select Open Panel.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to view.

Click the stage you wish to view.

In the right pane, click the General tab

The stage's configuration appears.

For example, Figure 4-2 shows the General tab for a channel.

Figure 4-2 General Tab for Channel Stage: Before Clicking Edit

Note:

Not all stage's configuration can be updated by Oracle CEP Visualizer. An Edit button will appear if the configuration can be updated.

For a description of the configuration properties for each possible stage, see:

Section 4.2.1.1, "Channel Properties"

Section 4.2.1.2, "Channel Properties: Outbound Channel"

Section 4.2.1.3, "Channel Properties: Outbound Channel With Query Selector"

Section 4.2.1.4, "Stream Properties"

Section 4.2.1.5, "Oracle CQL Processor Properties"

Section 4.2.1.6, "EPL Processor Properties"

Section 4.2.1.7, "Adapter Properties"

Section 4.2.1.8, "JMS Adapter Properties"

Section 4.2.1.9, "Oracle CEP High Availability Input Adapter Properties"

Section 4.2.1.10, "Oracle CEP High Availability Buffering Output Adapter Properties"

Section 4.2.1.11, "Oracle CEP High Availability Broadcast Output Adapter Properties"

Section 4.2.1.12, "Oracle CEP High Availability Correlating Output Adapter Properties"

Section 4.2.1.13, "Event Bean Properties"

Section 4.2.1.14, "POJO Properties"

Section 4.2.1.15, "Cache Properties: Oracle Coherence Cache"

Section 4.2.1.16, "Cache Properties: Oracle CEP Local Cache"

Click the Edit button, if present.

Modifiable attributes become editable as Figure 4-3 shows.

Figure 4-3 General Tab for Channel Stage: After Clicking Edit

Enter new values for editable fields.

For example, for the Max Size and Max Threads fields in Figure 4-3.

To commit your changes, click Save.

To leave the configuration unchanged, click Cancel.

4.2.1.1 Channel Properties

Figure 4-4 shows the General tab for a channel stage.

Figure 4-4 General Tab for Channel Stage

After you click Edit, you can modify the attributes that are not shaded grey. Table 4-1 describes all the attributes on the General tab for this stage.

Table 4-1 General Tab Properties: Channel

Attribute
Description

Channel Type

Stream or Relation.

For more information, see "Streams and Relations" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

Max Size

Specifies the maximum size of the channel. Zero-size channels synchronously pass-through events. Non-zero size channels process events asynchronously, buffering events by the requested size. The default value is 1024.

Max Threads

Specifies the maximum number of threads that will be used to process events for this channel.

You can change Max Threads from 0 to a positive integer (that is, from a pass-through to multiple threads) without redeploying. However, if you change Max Threads from a positive integer to 0 (that is, from multiple threads to a pass-through), then you must redeploy your application.

If the Max Size attribute is 0, then setting a value for Max Threads has no effect.

The default value for this attribute is 1.

Event Type Name

The name of the event type that this channel carries.

Timestamp Type

Use this element to specify whether or not the channel is application timestamped, that is, if the application is responsible for assigning a timestamp to each event, using any time domain. Valid values are:

SYSTEM-TIME (default)

APPLICATION-TIME

For more information, see child element application-timestamped in "wlevs:channel" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

Automatic HeartBeat

For system timestamped relations or streams, time is dependent upon the arrival of data on the relation or stream data source. Oracle CEP generates a heartbeat on a system timestamped relation or stream if there is no activity (no data arriving on the stream or relation's source) for more than this number of nanoseconds. Either the relation or stream is populated by its specified source or Oracle CEP generates a heartbeat every Automatic HeartBeat number of nanoseconds.

Note: This attribute is only applicable when a non-streaming source is connected to the channel.

For more information, see "heartbeat" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

For more information, see:

"channel" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

Section 4.2.1.2, "Channel Properties: Outbound Channel"

Section 4.2.1.3, "Channel Properties: Outbound Channel With Query Selector"

4.2.1.2 Channel Properties: Outbound Channel

Figure 4-5 shows the General tab for an outbound channel stage with an upstream Oracle CQL processor. The Channel Parameter accordion tab is selected.

Figure 4-5 General Tab Outbound Channel Parameters

After you click Edit, you can modify the attributes that are not shaded grey. Table 4-2 describes all the attributes on the General tab for this stage.

Table 4-2 General Tab Properties: Outbound Channel

Attribute
Description

Channel Type

Stream or Relation.

For more information, see "Streams and Relations" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

Max Size

Specifies the maximum size of the channel. Zero-size channels synchronously pass-through events. Non-zero size channels process events asynchronously, buffering events by the requested size. The default value is 1024.

Max Threads

Specifies the maximum number of threads that will be used to process events for this channel.

You can change Max Threads from 0 to a positive integer (that is, from a pass-through to multiple threads) without redeploying. However, if you change Max Threads from a positive integer to 0 (that is, from multiple threads to a pass-through), then you must redeploy your application.

If the Max Size attribute is 0, then setting a value for Max Threads has no effect.

The default value for this attribute is 1.

Event Type Name

The name of the event type that this channel carries.

For more information, see:

"channel" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

Section 4.2.1.1, "Channel Properties"

Section 4.2.1.3, "Channel Properties: Outbound Channel With Query Selector"

4.2.1.3 Channel Properties: Outbound Channel With Query Selector

Figure 4-6 shows the General tab for a channel stage with an upstream Oracle CQL processor. The Selectors accordion tab is selected.

Figure 4-6 General Tab Selectors for Outbound Channel Stage

The Selector tab is only applicable if the up-stream node is an Oracle CQL processor.

After you click Edit, use the Selector tab, you can specify which up-stream Oracle CQL processor queries are permitted to output their results to the channel:

Select an up-stream Oracle CQL processor from the Processor pull-down menu.

The available Oracle CQL rules associated with the selected processor are listed below the pull-down menu.

Use the left and right-pointing arrow buttons to move one or more rules to the Selected Queries list.

Only rules in the Selected Queries list will output events to the channel.

Note:

You must add a query to the upstream Oracle CQL processor before you can add the query name to the channel selector. For more information, see Section 6.1.1, "How to Create a Rule in an Oracle CQL Processor Using the Query Wizard".

For more information, see:

"Controlling Which Queries Output to a Downstream Channel" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

Section 4.2.1.1, "Channel Properties"

Section 4.2.1.2, "Channel Properties: Outbound Channel"

4.2.1.4 Stream Properties

Figure 4-7 shows the General tab for a stream stage.

Figure 4-7 General Tab for Channel Stage

After you click Edit, you can modify the attributes that are not shaded grey. Table 4-3 describes all the attributes on the General tab for this stage.

Table 4-3 General Tab Properties: Stream

Attribute
Description

Max Size

Specifies the maximum size of the stream. Zero-size streams synchronously pass-through events. Non-zero size streams process events asynchronously, buffering events by the requested size. The default value is 1024.

Max Threads

Specifies the maximum number of threads that will be used to process events for this stream.

You can change Max Threads from 0 to a positive integer (that is, from a pass-through to multiple threads) without redeploying. However, if you change Max Threads from a positive integer to 0 (that is, from multiple threads to a pass-through), then you must redeploy your application.

If the Max Size attribute is 0, then setting a value for Max Threads has no effect.

The default value for this attribute is 1.

4.2.1.5 Oracle CQL Processor Properties

Table 4-3 shows the General tab for an Oracle CQL processor stage.

Figure 4-8 General Tab for Oracle CQL Processor Stage

There are no editable properties for this type of stage.

For more information, see "processor (Oracle CQL)" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.2.1.6 EPL Processor Properties

Figure 4-9 shows the General tab for an EPL processor stage.

Figure 4-9 General Tab for EPL Processor Stage

There are no editable properties for this type of stage.

For more information, see "processor (EPL)" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.2.1.7 Adapter Properties

Figure 4-10 shows the General tab for an adapter stage.

Figure 4-10 General Tab for an Adapter Stage

There are no editable properties for this type of stage.

For more information, see "adapter" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.2.1.8 JMS Adapter Properties

Figure 4-16 shows the General tab for a JMS adapter.

Figure 4-11 General Tab for a JMS Adapter Stage

There are no editable properties for this type of stage.

For more information, see "adapter" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.2.1.9 Oracle CEP High Availability Input Adapter Properties

Figure 4-12 shows the General tab for an Oracle CEP high availability input adapter.

Figure 4-12 General Tab for an Oracle CEP High Availability Input Adapter Stage

There are no editable properties for this type of stage.

For more information, see "How to Configure the High Availability Input Adapter" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.2.1.10 Oracle CEP High Availability Buffering Output Adapter Properties

Figure 4-13 shows the General tab for an Oracle CEP high availability buffering output adapter.

Figure 4-13 General Tab for an Oracle CEP High Availability Buffering Output Adapter Stage

There are no editable properties for this type of stage.

For more information, see "How to Configure the Buffering Output Adapter" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.2.1.11 Oracle CEP High Availability Broadcast Output Adapter Properties

Figure 4-14 shows the General tab for an Oracle CEP high availability broadcast output adapter.

Figure 4-14 General Tab for an Oracle CEP High Availability Broadcast Output Adapter Stage

There are no editable properties for this type of stage.

For more information, see "How to Configure the Broadcast Output Adapter" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.2.1.12 Oracle CEP High Availability Correlating Output Adapter Properties

Figure 4-15 shows the General tab for an Oracle CEP high availability correlating output adapter.

Figure 4-15 General Tab for an Oracle CEP High Availability Correlating Output Adapter Stage

There are no editable properties for this type of stage.

For more information, see "How to Configure the Correlating Output Adapter" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.2.1.13 Event Bean Properties

Figure 4-16 shows the General tab for an event bean stage.

Figure 4-16 General Tab for Event Bean Stage

There are no editable properties for this type of stage.

For more information, see "event-bean" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.2.1.14 POJO Properties

Figure 4-17 shows the General tab for a Plain Old Java Object (POJO) stage.

Figure 4-17 General Tab for POJO Stage

There are no editable properties for this type of stage.

4.2.1.15 Cache Properties: Oracle Coherence Cache

Figure 4-18 shows the properties for an Oracle Coherence Cache stage.

Figure 4-18 Oracle Coherence Cache Stage Properties

There are no editable properties for this type of stage.

For more information, see:

Section 18.2, "Managing Oracle Coherence"

"coherence-cache-config" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

4.2.1.16 Cache Properties: Oracle CEP Local Cache

Figure 4-19 shows the properties for an Oracle CEP Local Cache stage.

Figure 4-19 Oracle CEP Local Cache Stage Properties

After you click Edit, you can modify the attributes that are not shaded grey. Table 4-4 describes all the attributes on the General tab for this stage.

Table 4-4 Properties: Oracle CEP Local Cache

Attribute
Description

Max Size

Specifies the max-size element to define the number of cache elements in memory after which eviction or paging occurs. Currently, the maximum cache size is 2^31-1 entries. This element may be changed dynamically.

Idle Time

Specifies the number of milliseconds a cache entry may not be accessed before being actively removed from the cache. By default, there is no idle-time set. This element may be changed dynamically.

Write Policy

Specifies how Oracle CEP server writes information into the cache. Valid values are:

WriteNone: Specifies no writes to a cache store. This is the default write policy. This element may be changed dynamically. For more information, see "write-none" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

WriteThrough: Specifies synchronous writes to the cache store. As soon as an entry is created or updated the write occurs. This element may be changed dynamically. For more information, see "write-through" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

WriteBehind: Specifies asynchronous writes to the cache store. The cache store is invoked from a separate thread after a create or update of a cache entry. This element may be changed dynamically. For more information, see "write-behind" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

Eviction Policy

Use this element to define the eviction policy the cache uses when Max Size is reached.

Valid values are:

FIFO: first in, first out.

LRU: least recently used

LFU: least frequently used (default)

NRU: not recently used

Time To Live

Specifies the maximum amount of time, in milliseconds, that an entry is cached. Default value is 0 (which means infinite).

For more information, see "cache" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

4.3 Recording and Playing Back Events in the EPN

The event repository feature of Oracle CEP allows you to record events flowing through an event processing network (EPN) and store them so you can later play back the events. You configure the recording and playing back of events per stage, such as a processor or stream. Additionally, only events coming out of an event source can be recorded, and playback is possible only on event sinks (events are played back to the inbound side of the event sink stage.)

The only configuration options of record and playback that you can control using Oracle CEP Visualizer are event type, time, and speed.

For detailed information about how event and record playback works and how to configure a component, see "Configuring Event Record and Playback" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

For an example, see "Event Record and Playback Example" in the Oracle Fusion Middleware Getting Started Guide for Oracle Complex Event Processing.

Alternatively, you can trace and inject events as Section 4.4, "Tracing and Injecting Events in the EPN" describes.

This section describes:

Section 4.3.1, "How to Record Events"

Section 4.3.2, "How to Playback Events"

4.3.1 How to Record Events

Using Oracle CEP Visualizer you can record events for a selected stage. Later, you can playback these events (see Section 4.3.2, "How to Playback Events").

To record events:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to record and playback events with.

In the right pane, click the Event Processing Network tab.

The Event Processor Network panel is displayed as Figure 4-20 shows.

Figure 4-20 Event Processing Network Panel

Select the stage for which you wish to record an event:

To use the EPN diagram:

Right-click the stage for which you wish to record an event and select Record Event.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to record and playback events with.

Click the stage for which you wish to record an event.

In the right pane, click the Record tab

The Record panel appears as shown in Figure 4-21.

Figure 4-21 The Record Tab

The Record tab in Oracle CEP Visualizer for a particular stage is divided into the following sections:

Recording Current Status: displays the current status of a recording. When the system has begun a recording session, then this field displays a blinking Recording message and it changes back to blank when the recording sessions ends. This section is read-only.

Recording Parameters: specifies the name of the database schema (Dataset name) and the provider information. You must pre-configure the provider for the event repository.

For more information, see:

"Storing Events in the Persistent Event Store" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

Chapter 17, "Managing the Persistent Event Store"

Event Type List: contains the Event Type List pane that displays the list of event types that are associated with a selected stage of the Oracle CEP application. Choose one or more events to record.

Record Schedule Entry: entries in this table displays the recording start time and end time for an event type. The fields in this table are disabled by default. Click Update Record to enable the fields in this table. The start and end time entries are optional fields, to start recording immediately, click the Start Recording button at the bottom of the panel.

Change Recording Schedule: allows you to change some of the properties of your existing recording entry. Certain properties, such as the event type, cannot be changed using Oracle CEP Visualizer. Use the calendar and clock controls to specify or change an existing start and end time for recording events.

Decide what you want to do:

To add a new record schedule entry, click Add.

To modify an existing record schedule entry, select the entry in the Record Schedule Entry table and click Edit.

To delete an existing record schedule entry, select the entry in the Record Schedule Entry table and click Delete.

Configure the Recording Parameters:

DataSet Name: the value of the record-parameters child element dataset-name element from the simpleEventSource adapter application configuration file ORACLE-CEP-HOME\ocep_11.1\samples\domains\recplay_domain\defaultserver\applications\recplay\config.xml as Example 4-1 shows.

Example 4-1 recplay Application Configuration File config.xml: adapter Element

<adapter>
    <name>simpleEventSource</name>
    <record-parameters>
        <dataset-name>recplay_sample</dataset-name>
        <event-type-list>
            <event-type>SimpleEvent</event-type>
        </event-type-list>
        <provider-name>test-rdbms-provider</provider-name>
        <batch-size>1</batch-size>
        <batch-time-out>10</batch-time-out>
    </record-parameters>
</adapter>

Provider Name: the value of the rdbms-event-store-provider child element name which corresponds to the data-source child element name as Example 4-2 shows.

When using the default Berkeley database provider, select default provider.

Example 4-2 recplay Oracle CEP Server Configuration File config.xml: data-source and rdbms-event-store-provider Elements

<data-source>
    <name>derby1</name>
    <connection-pool-params>
        <initial-capacity>15</initial-capacity>
        <max-capacity>50</max-capacity>
    </connection-pool-params>
    <driver-params>
        <url>jdbc:derby:dbtest1;create=true</url>
        <driver-name>org.apache.derby.jdbc.EmbeddedDriver</driver-name>
    </driver-params>
</data-source>
<rdbms-event-store-provider>
    <name>test-rdbms-provider</name>
    <data-source-name>derby1</data-source-name>
</rdbms-event-store-provider>

For more information, see Chapter 13, "Managing Data Sources".

Configure the Event type list:

Use the left and right-pointing arrow buttons to move the events you want recorded from the Available event list to the Recorded event list.

For more information, see Chapter 16, "Managing the Event Type Repository".

Decide when you want recording to start and end:

If you want to schedule a record start and end time:

Click the calendar and clock controls to add a start time and end time.

Click Save.

An alert dialog appears as Figure 4-22 shows.

Figure 4-22 Record Schedule Confirmation Dialog

Click OK.

If you want to record events immediately:

Click Save.

An alert dialog appears as Figure 4-22 shows.

Figure 4-23 Record Schedule Confirmation Dialog

Click OK.

Click Start.

Oracle CEP Visualizer keeps track of whether a particular stage is currently recording or playing back events; based on this information, the Start and End buttons may be enabled or disabled as appropriate.

When you start recording using Oracle CEP Visualizer, Oracle CEP uses the event type information from your record entry and begins recording immediately; the pre-scheduled time, if any, remains unchanged. Use the End button to stop recording of your session immediately.

Decide when you want to stop recording:

If you scheduled a stop time, event recording will stop at that time.

If you want to stop event recording immediately, click Stop.

4.3.2 How to Playback Events

Using Oracle CEP Visualizer you can playback previously recorded events (see Section 4.3.2, "How to Playback Events") for a selected stage.

To playback events:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to record and playback events with.

In the right pane, click the Event Processing Network tab.

The Event Processor Network panel is displayed as Figure 4-24 shows.

Figure 4-24 Event Processing Network Panel

Select the stage for which you wish to playback an event:

To use the EPN diagram:

Right-click the stage for which you wish to playback an event and select Playback Event.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to record and playback events with.

Click the stage for which you wish to playback an event.

In the right pane, click the Playback tab

The Record panel appears as shown in Figure 4-25.

Figure 4-25 The Playback Tab

The Playback tab in Oracle CEP Visualizer for a particular stage is divided into the following sections:

Playback Current Status: displays the current status of playback. When the system has begun playing back a session, then this field displays a blinking Playback message and it changes back to blank when the playback session ends. This section is read-only.

Playback Parameters: specifies the name of the database schema (Dataset name) and the provider information. You must pre-configure the provider for the event repository.

For more information, see:

"Storing Events in the Persistent Event Store" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

Chapter 17, "Managing the Persistent Event Store"

Event Type List: contains the Event Type List pane that displays the list of event types that are associated with a selected stage of the Oracle CEP application. Choose one or more events to playback.

Playback Filter Entry: specify a set of filters using the clock and time controls, to run a playback for an event type in event type repository. Only events that were recorded during the start and end times you specify here will be played back.

Playback Schedule Entry: entries in this table displays the playback start time and end time for an event type. The fields in this table are disabled by default. Click Update Playback to enable the fields in this table. The start and end time entries are optional fields, to start recording immediately, click the Start Playback button at the bottom of the panel.

Change Playback Filter Parameters: allows you to change some of the properties of the selected playback filter entry.

Change Playback Schedule Parameters: allows you to change some of the properties of the selected playback schedule entry. Use the calendar and clock controls to specify or change an existing start and end time for playing back events.

Configure the Playback Parameters:

DataSet Name: the value of the record-parameters child element dataset-name element from the simpleEventSource adapter application configuration file ORACLE-CEP-HOME\ocep_11.1\samples\domains\recplay_domain\defaultserver\applications\recplay\config.xml as Example 4-3 shows.

Example 4-3 recplay Application Configuration File config.xml: stream Element

<stream>
    <name>eventStream</name>
    <playback-parameters>
        <dataset-name>recplay_sample</dataset-name>
        <event-type-list>
            <event-type>SimpleEvent</event-type>
        </event-type-list>
        <provider-name>test-rdbms-provider</provider-name>
    </playback-parameters>
    <max-size>10000</max-size>
    <max-threads>2</max-threads>
</stream>

Provider Name: the value of the rdbms-event-store-provider child element name which corresponds to the data-source child element name as Example 4-4 shows.

When using the default Berkeley database provider, select default provider.

Example 4-4 recplay Oracle CEP Server Configuration File config.xml: data-source and rdbms-event-store-provider Elements

<data-source>
    <name>derby1</name>
    <connection-pool-params>
        <initial-capacity>15</initial-capacity>
        <max-capacity>50</max-capacity>
    </connection-pool-params>
    <driver-params>
        <url>jdbc:derby:dbtest1;create=true</url>
        <driver-name>org.apache.derby.jdbc.EmbeddedDriver</driver-name>
    </driver-params>
</data-source>
<rdbms-event-store-provider>
    <name>test-rdbms-provider</name>
    <data-source-name>derby1</data-source-name>
</rdbms-event-store-provider>

For more information, see Chapter 13, "Managing Data Sources".

Configure the Event type list:

Use the left and right-pointing arrow buttons to move the events you want played back from the Available event list to the Playback event list.

For more information, see Chapter 16, "Managing the Event Type Repository".

Decide what you want to do:

To add a new playback schedule entry, click Add.

To modify an existing playback filter entry, select the entry in the Playback Filter Entry table and click Edit.

To modify an existing playback schedule entry, select the entry in the Playback Schedule Entry table and click Edit.

To delete an existing playback filter or schedule entry, select the entry in the appropriate table and click Delete.

Decide when you want playback to start and end:

If you want to create a new playback filter entry:

Click the calendar and clock controls in the Change Playback Filter Parameters area to add a start time and end time.

Click Save.

An alert dialog appears as Figure 4-26 shows.

Figure 4-26 Playback Schedule Confirmation Dialog

Click OK.

If you want to create a new playback schedule entry:

Click the calendar and clock controls in the Change Playback Schedule Parameters area to add a start time and end time and to specify a speed and repeat mode.

Speed: the default speed value is 1, which corresponds to normal speed. A value of 2 means that events will be played back 2 times faster than the original record speed. Similarly, a value of 0.5 means that events will be played back at half the speed.

Repeat: set this to true to repeat playback until the scheduled end time or until you stop playback manually; set this to false to playback only once.

Click Save.

An alert dialog appears as Figure 4-27 shows.

Figure 4-27 Playback Schedule Confirmation Dialog

Click OK.

If you want to playback events immediately:

Click Save.

An alert dialog appears as Figure 4-22 shows.

Figure 4-28 Playback Schedule Confirmation Dialog

Click OK.

Click Start.

Oracle CEP Visualizer keeps track of whether a particular stage is currently recording or playing back events; based on this information, the Start and End buttons may be enabled or disabled as appropriate.

When you start playback using Oracle CEP Visualizer, Oracle CEP uses the event type information from your playback entry and begins playback immediately; the pre-scheduled time, if any, remains unchanged. Use the End button to stop playback session immediately.

Decide when you want to stop playback:

If you scheduled a stop time, event playback will stop at that time.

If you want to stop event playback immediately, click Stop.

4.4 Tracing and Injecting Events in the EPN

Using the Event Inspector service and the stream visualizer, you can:

Trace events on any HTTP pub-sub server channel.

Trace events on any stage in the EPN on the Event Inspector service dynamic HTTP pub-sub server channel.

Inject events to any HTTP pub-sub server channel

Inject events into any stage in the EPN using the Event Inspector service dynamic HTTP pub-sub server channel.

Note:

The Event Inspector service is not for use on a production Oracle CEP server. It is for use only during development.

This section describes:

Section 4.4.1, "How to Trace Events on a Dynamic Channel"

Section 4.4.2, "How to Inject a Simple Event on an Event Inspector Service Dynamic Channel"

Section 4.4.3, "How to Inject an Event as a JSON String on an Event Inspector Service Dynamic Channel"

For more information, see:

Chapter 15, "Managing the Event Inspector Service"

Chapter 14, "Managing HTTP Publish-Subscribe Servers"

Section 4.5, "Monitoring a Channel Stage in the EPN"

"Testing Applications With the Event Inspector" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

Alternatively, you can record and playback events as Section 4.3, "Recording and Playing Back Events in the EPN" describes.

4.4.1 How to Trace Events on a Dynamic Channel

You can use Oracle CEP Visualizer to view the messages that are currently being published to a static channel.

For more information, see Section 9.5, "HTTP Publish-Subscribe Server Management".

To trace events on a dynamic channel:

Optionally, configure the HTTP pub-sub server to use to trace events.

See Chapter 15, "Managing the Event Inspector Service".

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application in which you want to trace and inject events.

In the right pane, click the Event Processing Network tab.

The Event Processor Network panel is displayed as Figure 4-24 shows.

Figure 4-29 Event Processing Network Panel

Select the stage for which you wish to trace events:

To use the EPN diagram:

Right-click the stage for which you wish to trace events and select Trace Event.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application in which you want to trace events.

Click the stage for which you wish to trace an event.

In the right pane, click the Trace Event tab

The Trace Event panel appears as shown in Figure 4-30.

Figure 4-30 The Trace Event Tab: Start

Click Start.

An alert dialog appears as Figure 4-31 shows.

Figure 4-31 Trace Event Confirmation Dialog

Click OK.

The Status field reads ON.

The Channel Name field shows the dynamic channel on which events passing through this stage are written. The Event Inspector service HTTP pub-sub channel is named:

/SERVERNAME/APPLICATIONNAME/STAGENAME/output

Where:

SERVERNAME: the name of the Oracle CEP server on which the application and stage you want to trace are executing.

APPLICATIONNAME: the name of the Oracle CEP application that owns the stage you want to trace.

STAGENAME: the name of the Oracle CEP application stage you want to trace.

For example: /NonClusteredServer/cql/orderCSVAdapter/output.

In the top pane, click ViewStream.

The Stream Visualizer panel appears as Figure 4-32 shows.

Figure 4-32 Stream Visualizer (ViewStream): Subscribe

In the PubSub Server Name pull down menu, select the name of the HTTP pub-sub server to use to trace events.

Click Initialize Client.

Select the Subscribe tab.

Click Refresh.

The Subscribe tab is refreshed to show the dynamic channel for your stage.

Click the radio button next to the name of the channel to which the Oracle CEP server is publishing messages.

For example: /NonClusteredServer/cql/orderCSVAdapter/output.

Click Subscribe.

The Output messages received from subscription text box displays events being published to the channel.

Note:

If the Oracle CEP Visualizer fails to subscribe to the channel and displays an error in the Debug Messages area such as:

14:25:54 GMT-0400: httpFaultHandler(): [RPC Fault faultString="Error #2096" faultCode="InvokeFailed" faultDetail="null"]

Then, confirm the following:

Have you met the Oracle CEP Visualizer Adobe Flash and browser prerequisites? See Section 2.1.1, "Prerequisites".

To clear the Output messages received from subscription text, click Clear Text.

To unsubscribe from the channel, click Unsubscribe.

To stop event trace, select the stage you configured to trace events:

To use the EPN diagram:

Right-click the stage for which you wish to trace an event and select Trace Event.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application in which you want to trace and inject events.

Click the stage for which you wish to trace an event.

In the right pane, click the Trace Event tab

The Trace Event panel appears as shown in Figure 4-30.

Figure 4-33 The Trace Event Tab: Stop

Click Stop.

An alert dialog appears as Figure 4-34 shows.

Figure 4-34 Trace Event Stop Confirmation Dialog

Click OK.

The Status field reads OFF.

The Channel Name field is blank.

4.4.2 How to Inject a Simple Event on an Event Inspector Service Dynamic Channel

You can inject a single, simple event by type into any stage in the EPN using the Event Inspector service dynamic channel.

The Oracle CEP Visualizer only supports simple event types whose properties are all simple Java types without nested Java objects. Event properties must be restricted to the following types:

primitive Java types

Java array or collection with simple Java type values

Date

BigDecimal

BigInteger

Alternatively, you can inject an event with more complex properties by specifying the event as a JSON message. For more information, see Section 4.4.3, "How to Inject an Event as a JSON String on an Event Inspector Service Dynamic Channel".

Note:

The Event Inspector service is not for use on a production Oracle CEP server. It is for use only during development.

To inject a simple event on an Event Inspector service dynamic channel:

Optionally, configure the HTTP pub-sub server to use to trace events.

See Chapter 15, "Managing the Event Inspector Service".

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application in which you want to trace and inject events.

In the right pane, click the Event Processing Network tab.

The Event Processor Network panel is displayed as Figure 4-24 shows.

Figure 4-35 Event Processing Network Panel

Select the stage for which you wish to inject events:

To use the EPN diagram:

Right-click the stage for which you wish to inject an event and select Inject Event.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application in which you want to trace and inject events.

Click the stage for which you wish to inject an event.

In the right pane, click the Inject Event tab

The Inject Event panel appears as shown in Figure 4-30.

Figure 4-36 The Inject Event Tab: Start

Click Start.

An alert dialog appears as Figure 4-31 shows.

Figure 4-37 Inject Event Start Confirmation Dialog

Click OK.

The Status field reads ON.

The Channel Name field shows the dynamic channel on which events passing through this stage are injected. The Event Inspector service HTTP pub-sub channel is named:

/SERVERNAME/APPLICATIONNAME/STAGENAME/input

Where:

SERVERNAME: the name of the Oracle CEP server on which the application and stage you want to trace are executing.

APPLICATIONNAME: the name of the Oracle CEP application that owns the stage you want to trace.

STAGENAME: the name of the Oracle CEP application stage you want to trace.

For example: /NonClusteredServer/cql/orderCSVAdapter/input.

In the top pane, click ViewStream.

The Stream Visualizer panel appears as Figure 4-38 shows.

Figure 4-38 Stream Visualizer (ViewStream): Publishing Simple Events

In the PubSub Server Name pull down menu, select the name of the HTTP pub-sub server to use to trace events.

Click Initialize Client.

Select the Publish tab.

Click Refresh.

The Publish tab is refreshed to show the dynamic channel for your stage.

Click the radio button next to the name of the channel to which the Oracle CEP server will inject messages.

For example: /NonClusteredServer/cql/orderCSVAdapter/output.

From the Input Method radio button group, select Form Based Event.

From the Event Type pull down menu, select an event type.

The View Stream panel updates to list the attributes of the event type you select.

For example, Figure 4-38 shows the attributes for the DataStockTick event, which include:

Price

Symbol

PercChange

Volume

LastPrice

Note:

The View Stream Event Type pull down menu lists all the events defined in the event type repository that meet the restrictions that Section 4.4.2, "How to Inject a Simple Event on an Event Inspector Service Dynamic Channel" describes. To inject a more complex events, see Section 4.4.3, "How to Inject an Event as a JSON String on an Event Inspector Service Dynamic Channel".

Configure the attributes for the event type you selected.

Hover your mouse over an attribute field to display a tool tip that indicates the data type for the attribute.

Click Publish.

Oracle CEP Visualizer publishes the event on the Event Inspector service dynamic channel and it is received and processed by the stage that the channel identifies.

To stop event injection, select the stage you configured for event injection:

To use the EPN diagram:

Right-click the stage for which you wish to inject an event and select Inject Event.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application in which you want to trace and inject events.

Click the stage for which you wish to inject an event.

In the right pane, click the Inject Event tab

The Inject Event panel appears as shown in Figure 4-39.

Figure 4-39 The Inject Event Tab: Stop

Click Stop.

An alert dialog appears as Figure 4-31 shows.

Figure 4-40 Inject Event Stop Confirmation Dialog

Click OK.

The Status field reads OFF.

The Channel Name field is blank.

4.4.3 How to Inject an Event as a JSON String on an Event Inspector Service Dynamic Channel

You can inject a single event directly to the HTTP pub-sub channel as a JSON-formatted character string.

You can use any event property that JSON can represent.

For details on the Event Inspector service JSON event structure and mandatory attributes, see "Event Inspector Event Types" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

Alternatively, you can inject a simple, pre-existing event. For more information, see Section 4.4.2, "How to Inject a Simple Event on an Event Inspector Service Dynamic Channel".

Note:

The Event Inspector service is not for use on a production Oracle CEP server. It is for use only during development.

To inject an event as a JSON string on an Event Inspector service dynamic channel:

Optionally, configure the HTTP pub-sub server to use to trace events.

See Chapter 15, "Managing the Event Inspector Service".

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application in which you want to trace and inject events.

In the right pane, click the Event Processing Network tab.

The Event Processor Network panel is displayed as Figure 4-24 shows.

Figure 4-41 Event Processing Network Panel

Select the stage for which you wish to inject events:

To use the EPN diagram:

Right-click the stage for which you wish to inject an event and select Inject Event.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application in which you want to trace and inject events.

Click the stage for which you wish to inject an event.

In the right pane, click the Inject Event tab

The Inject Event panel appears as shown in Figure 4-30.

Figure 4-42 The Inject Event Tab: Start

Click Start.

An alert dialog appears as Figure 4-31 shows.

Figure 4-43 Inject Event Start Confirmation Dialog

Click OK.

The Status field reads ON.

The Channel Name field shows the dynamic channel on which events passing through this stage are injected. The Event Inspector service HTTP pub-sub channel is named:

/SERVERNAME/APPLICATIONNAME/STAGENAME/input

Where:

SERVERNAME: the name of the Oracle CEP server on which the application and stage you want to trace are executing.

APPLICATIONNAME: the name of the Oracle CEP application that owns the stage you want to trace.

STAGENAME: the name of the Oracle CEP application stage you want to trace.

For example: /NonClusteredServer/cql/orderCSVAdapter/input.

In the top pane, click ViewStream.

The Stream Visualizer panel appears as Figure 4-44 shows.

Figure 4-44 Stream Visualizer (ViewStream): Publishing JSON Events

In the PubSub Server Name pull down menu, select the name of the HTTP pub-sub server to use to trace events.

Click Initialize Client.

Select the Publish tab.

Click Refresh.

The Publish tab is refreshed to show the dynamic channel for your stage.

Click the radio button next to the name of the channel to which the Oracle CEP server will inject messages.

For example: /NonClusteredServer/cql/orderCSVAdapter/output.

From the Input Method radio button group, select Json String.

Enter a JSON-formatted string in the text field as Example 4-5 shows.

Example 4-5 JSON-Formatted Event String

{
    "event-type": "myEventType",
    "operation": "insert",
    "binding": "outbound",
    "value":{
        "firstname": "Jane",
        "lastname": "Doe",
        "phone": {
            "code": 12345,
            "number": "office"
        },
    }
}

For complete details on the Event Inspector service JSON event structure and mandatory attributes, see "Event Inspector Event Types" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

Click Publish.

Oracle CEP Visualizer publishes the event on the Event Inspector service dynamic channel and it is received and processed by the stage that the channel identifies.

To stop event injection, select the stage you configured for event injection:

To use the EPN diagram:

Right-click the stage for which you wish to inject an event and select Inject Event.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application in which you want to trace and inject events.

Click the stage for which you wish to inject an event.

In the right pane, click the Inject Event tab

The Inject Event panel appears as shown in Figure 4-39.

Figure 4-45 The Inject Event Tab: Stop

Click Stop.

An alert dialog appears as Figure 4-31 shows.

Figure 4-46 Inject Event Stop Confirmation Dialog

Click OK.

The Status field reads OFF.

The Channel Name field is blank.

4.5 Monitoring a Channel Stage in the EPN

You can use Oracle CEP Visualizer to monitor any channel stage (stream) of the event processing network (EPN) of an application.

Oracle CEP defines the following metrics that you can monitor for each channel:

size: the number of events in the channel's queue.

4.5.1 How to Monitor a Channel Stage in the EPN

You can monitor a channel stage in the EPN using the Oracle CEP Visualizer.

To monitor a channel in the EPN:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to monitor.

In the right pane, click the Channel Monitor tab.

The Channel Monitor tab appears as Figure 4-47 shows.

Figure 4-47 Channel Monitor Tab

To monitor a channel, click on a channel in the All Channels list and drag and drop it onto one of the four graphs in the Channel Monitor tab.

The channel name is added to a color-coded legend below the graph. The color corresponds to the channel's line in the graph.

The channel name is also added to the Monitored Channels list.

You can display all channels on one graph or distribute channels amongst the four graphs in any combination.

To change the scale of the graphs, click on the slider to the left of the vertical axis and drag it up or down.

To stop monitoring a channel, click the Remove button associated with it in the Monitored Channels list.

4.6 Monitoring the Throughput and Latency of a Stage or Path in the EPN

You can use Oracle CEP Visualizer to monitor the entry and exit points of a stage, or a specified path, of the event processing network (EPN) of an application. Oracle CEP defines the following metrics that you can monitor for each stage or path:

Throughput: The number of events processed by the stage.

Average Latency: The average amount of time it takes an event to pass through a specified path of the EPN, or latency.

Maximum Latency: The maximum amount of time it takes an event to pass through a specified path of the EPN.

Average Latency Threshold: Calculates the average latency values greater than the specified threshold value for specified start and end points.

The Oracle CEP Visualizer monitoring feature is itself implemented as an Oracle CEP application; this means that the diagnostic information can be viewed as an event, and the application uses EPL rules to process these diagnostic events.

4.6.1 How to Monitor the Throughput and Latency of a Stage or Path in the EPN

You can monitor the throughput and latency of a stage or path in the EPN using the Oracle CEP Visualizer.

To monitor the throughput and latency of a stage or path in the EPN:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application for which you want to monitor throughput and latency.

Select the stage you wish to view and configure:

To use the EPN diagram:

Click the Event Processing Network tab.

Double-click the stage you wish to monitor or the first stage in the path that you want to monitor.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to monitor.

Click the stage you wish to monitor or the first stage in the path that you want to monitor.

In the right pane, click the General tab

The stage's General tab appears. For example, Figure 4-48 shows the General tab for a channel.

Figure 4-48 General Tab for Channel Stage

Click the Create Diagnostics button.

A New Latency Profile accordion menu appears as shown in Figure 4-49. It contains the following tabs:

Profile Information

Latency

Throughput

Click the Profile Information tab in the accordion menu as shown in Figure 4-49 and enter the information that Table 4-5 lists.

Figure 4-49 New Latency Profile Screen - Profile Information Tab

Table 4-5 Profile Information Attributes

Attribute
Description

Profile Name

The name of the diagnostic profile that you want to create.

State

Select On if you want to enable the profile for immediate use.

Select Off if you do not want to enable the profile for immediate use.

Click the Latency tab in the accordion menu as shown in Figure 4-50 and enter the information that Table 4-6 lists.

Figure 4-50 New Latency Profile Screen - Latency Tab

Table 4-6 Latency Attributes

Attribute
Description

Max Latency Metric

Specifies that you want to monitor the maximum amount of time it takes for events to flow through a stage or a subset of the event processing network (path).

Average Latency Metric

Specifies that you want to monitor the average amount of time it takes for events to flow through a stage or a subset of the event processing network (path)

Average Collection Interval

Specifies the time interval for which you want to gather diagnostic data. In other words, the sliding window across which the Average Latency Metric is computed.

This value is enabled only if you specify Max Latency Metric.

Threshold

Specify a value if you are interested in only receiving latency metrics that exceed a certain value. For example, if you would like to know when the latency exceeds 250 ms, specify a Threshold value of 250 ms.

This value is enabled only if you specify Average Latency Metric.

Start Stage Name

Specifies the name that you have provided for the start stage.

If you want to monitor just the current stage, rather than a path in the EPN, then set the Start Stage Name and End Stage Name to the name of the current stage.

Select Entry for the Start Stage Name option and Exit for the End Stage Name.

End Stage Name

Specifies the name that you have provided for the end stage.

If you want to monitor a path in the EPN, Oracle CEP Visualizer assumes that the current stage is the start of the path, and thus automatically selects it for the Start Stage Name field.

Specify whether the start of the path should be the Entry or Exit of the current stage. Then, select the End Stage Name, or the end of the path you want to monitor, and specify whether the end of the path should be the Entry or Exit of the stage

Click the Latency tab in the accordion menu as shown in Figure 4-50 and enter the information that Table 4-6 lists.

Figure 4-51 New Latency Profile Screen - Throughput Tab

Table 4-7 Throughput Attributes

Attribute
Description

Average Throughput Metric

Specifies that you want to monitor the average throughput of events flowing through the stage.

Stage Name

Specify whether you want to monitor the throughput at the entry or exit of the stage

Throughput Interval

Specifies the period of time for which the throughput is calculated.

For example, if you specify a Throughput Interval of 1 second, the number of events passing through the stage in 1 second will be calculated. This will be averaged over the Average Interval you specify.

Specify the time unit as Second, Millisecond, or Microsecond.

Average Interval

Specifies the interval for gathering the average throughput.

For example, if you specify a Throughput Interval of 1 second, the number of events passing through the stage in 1 second will be calculated. This will be averaged over the Average Interval you specify.

Specify the time unit as Second, Millisecond, or Microsecond.

Click Save.

A pop-up confirmation dialog appears in the lower-right corner of the panel.

The saved diagnostic profile appears in the left domain tree, under the stage from which you created it, as shown in Figure 4-52.

Figure 4-52 Left Domain Tree - Mydiagprofile

Note:

You can now restart a server or undeploy an application without losing the diagnostic profile you created.

Click OK.

Add the diagnostic profile to the Oracle CEP Visualizer Dashboard:

Select the diagnostic profile in the left domain tree and click the Add to Dashboard button.

Click the Dashboard link at the top of Oracle CEP Visualizer and drag and drop the diagnostic profile you created from the domain tree in the left pane to the table at the bottom of the right pane.

Click the Dashboard link at the top of Oracle CEP Visualizer.

The Dashboard screen is displayed with the Management Events and Performance Monitoring panes as Figure 4-53 shows.

Click the name of the diagnostic profile in the table.

The latency and throughput information is displayed in the graphs in the middle of the dashboard as Figure 4-53 shows.

Figure 4-53 Oracle CEP Visualizer Dashboard With Diagnostic Profiles

To expand the performance monitoring graphs to fill the screen, click Expand Chart.

To restore the performance monitoring graphs to their original size, click Restore Chart.

The Management Events section at the top of the Dashboard displays alerts about the incoming monitoring events. The Oracle CEP monitoring feature defines a set of default EPL rules that specify when these alerts show up in the Management Events table. You can change the EPL rules to customize this behavior, as described in Section 7.4, "Changing the dataservices Application Event Filter Rule Using EPL."

5 Managing Application Lifecycle

This chapter describes how you can use Oracle CEP Visualizer to deploy, suspend, update, and uninstall Oracle Complex Event Processing (Oracle CEP) applications.

Section 5.1, "Deploying an Application"

Section 5.2, "Suspending or Resuming an Application"

Section 5.3, "Updating an Application"

Section 5.4, "Uninstalling an Application"

For more information, see:

Section 3.2, "Application Lifecycle Management"

Chapter 10, "Managing Deployments"

5.1 Deploying an Application

Deploying an application refers to uploading to the server the JAR file that contains the application and then installing it, which makes it available to clients.

Oracle CEP internally deploys an application as a two step processes. The first step involves starting the application bundle inside the OSGi container. The second step involves starting and initializing the application. Because the second step is asynchronous in nature, Oracle CEP Visualizer does not wait for the completion of the second operation. As soon as the application has successfully started, the Oracle CEP Visualizer navigation tree is updated automatically with the new deployment and a successful message will be sent to the dashboard. However, if the application fails to start, you must check for errors on the server side because no messages/updates will occur on the Oracle CEP Visualizer.

When you deploy an application, the Oracle CEP server starts a new configuration history for it. See Section 3.4, "Configuration History Management".

Note:

You may only deploy to a group if the target Oracle CEP server is part of a multi-server domain (that is, if clustering is enabled). You may not deploy to a group if the target Oracle CEP server is part of a standalone-server domain (that is, if clustering is disabled). For more information, see "Overview of Oracle CEP Multi-Server Domain Administration" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

This section describes:

Section 5.1.1, "How to Deploy an Application in a Standalone-Server Domain"

Section 5.1.2, "How to Deploy an Application in a Multi-Server Domain"

5.1.1 How to Deploy an Application in a Standalone-Server Domain

This section describes how to deploy an application to a standalone-server domain. For information on deploying an application in a multi-server domain, see Section 5.1.2, "How to Deploy an Application in a Multi-Server Domain".

Note:

Uploading an application JAR file via Oracle CEP Visualizer running in the Firefox browser over HTTPS is not supported. For uploading over HTTPS, use Internet Explorer.

To deploy an application in a standalone-server domain:

In the left pane, navigate to and select the Deployment node.

The Deployed Applications table is displayed in the Deployment screen on the right pane.

Click the Install button.

The Install Application screen is displayed.

Click the Upload tab.

Click the ... button to open a file browsing window.

Browse to the local directory that contains the JAR file of the application you want to install and click Open.

Click Upload.

In the Install Application tab, the JAR file appears in the table of uploaded files, as shown in Figure 5-1.

Figure 5-1 The Install Application Screen: Standalone-Server Domain

If you want the application JAR file removed from the Oracle CEP server after deploying, check the Remove file after deploy check box.

In this case, you must upload the application JAR file again if you want to redeploy this application.

Select your application in the table and click Deploy.

The Review Deployment Information screen is displayed, as shown in Figure 5-2.

Figure 5-2 The Review Deployment Information Screen: Standalone-Server Domain

Click OK.

Your application is deployed and ready for use.

5.1.2 How to Deploy an Application in a Multi-Server Domain

This section describes how to deploy an application to a multi-server domain. For information on deploying an application in a standalone-server domain, see Section 5.1.1, "How to Deploy an Application in a Standalone-Server Domain".

For more information, see Chapter 18, "Managing Multi-Server Domains".

Note:

Uploading an application JAR file via Oracle CEP Visualizer running in the Firefox browser over HTTPS is not supported. For uploading over HTTPS, use Internet Explorer.

To deploy an application in a multi-server domain:

In the left pane, navigate to and select the Deployment node.

The Deployed Applications table is displayed in the Deployment screen on the right pane.

Click the Install button.

The Install Application screen is displayed.

Click the Upload tab.

Click the ... button to open a file browsing window.

Browse to the local directory that contains the JAR file of the application you want to install and click Open.

Click Upload.

In the Install Application tab, the JAR file appears in the table of uploaded files, as shown in Figure 5-3.

Figure 5-3 The Install Application Screen: Multi-Server Domain

Configure the Select Target Group to Deploy field.

The group name appears in the Target Group to Deploy field.

To unselect this selection, click the Clear Group button.

Select your application in the table and click Deploy.

The Review Deployment Information screen is displayed, as shown in Figure 5-4.

Figure 5-4 The Review Deployment Information Screen: Multi-Server Domain

Click OK.

Oracle CEP Visualizer deploys your application to all servers in the selected target group as Figure 5-5 shows.

Figure 5-5 HelloWorld Application Deployed to All the Servers in Group testgroup

5.2 Suspending or Resuming an Application

You can temporarily suspend an application from running and resume the operation using the Suspend and Resume operations in the Deployment screen.

5.2.1 How to Suspend or Resume an Application

You can suspend or resume an application using the Oracle CEP Visualizer.

To suspend or resume an application:

In the left pane, navigate to Deployment node. The Deployed Applications table is displayed in the Deployment screen on the right pane.

Select the application you want to suspend or resume by checking the box to the left of its name.

Click Suspend to suspend the application or Resume to resume a suspended application.

5.3 Updating an Application

You can update your currently existing application with your latest application using the Update operation in the Deployment screen.

When you update an application, the Oracle CEP server erases the application's existing configuration history and starts a new configuration history for it. See Section 3.4, "Configuration History Management".

5.3.1 How to Update an Application

You can update an application using the Oracle CEP Visualizer.

Note:

Uploading an application JAR file via Oracle CEP Visualizer running in the Firefox browser over HTTPS is not supported. For uploading over HTTPS, use Internet Explorer.

To update an application:

In the left pane, navigate to Deployment node. The Deployed Applications table is displayed in the Deployment screen on the right pane.

Select the application you want to update by checking the box to the left of its name.

Click Update. The Update application screen is displayed.

Click the Upload tab.

Click on the "..." button to invoke a file browsing window, browse to the directory that contains the JAR file of application, and click Open.

Click Upload. In the Update Application tab, the JAR file appears in the table of uploaded files.

Select your application in the table and click OK.

The existing application is updated with the latest application.

5.4 Uninstalling an Application

When you uninstall an application, you completely remove it from the server so that you can no longer access it.

When you uninstall an application, the Oracle CEP server erases the application's existing configuration history. See Section 3.4, "Configuration History Management".

5.4.1 How to Uninstall an Application

You can uninstall an application using the Oracle CEP Visualizer.

To uninstall an application:

In the left pane, navigate to Deployment node. The Deployed Applications table is displayed in the Deployment screen on the right pane.

Select the application you want to uninstall by checking the box to the left of its name.

Click Uninstall.

You have undeployed the application successfully.

6 Managing Oracle CQL Rules

This chapter describes how you can use Oracle CEP Visualizer to develop and manage Oracle Continuous Query Language (CQL) rules, which you can use to select events as they pass through an event processing network (EPN).

Section 6.1, "Using the Query Wizard"

Section 6.2, "Using the Query Plan"

For more information, see:

Section 3.3, "Rules Management"

Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"Oracle Continuous Query Language (CQL) Example" in the Oracle Fusion Middleware Getting Started Guide for Oracle Complex Event Processing

6.1 Using the Query Wizard

Using the Oracle CEP Visualizer, you can manage the Oracle CQL rules in the Oracle CQL processors of an Oracle CEP application.

This section describes the following topics:

Section 6.1.1, "How to Create a Rule in an Oracle CQL Processor Using the Query Wizard"

Section 6.1.2, "How to Edit a Rule in an Oracle CQL Processor Using the Query Wizard"

Section 6.1.4, "How to Edit a Parameterized Query in an Oracle CQL Processor"

Section 6.1.6, "How to Delete a Rule in an Oracle CQL Processor"

Section 6.1.7, "How to Replace a Rule in an Oracle CQL Processor"

Section 6.1.8, "How to View a Rule in an Oracle CQL Processor"

Section 6.1.9, "How to Configure Query Wizard Oracle CQL Constructs"

Section 6.1.10, "How to Create an Oracle CQL Template for the Query Wizard"

6.1.1 How to Create a Rule in an Oracle CQL Processor Using the Query Wizard

Oracle CEP Visualizer provides a sophisticated Query Wizard to simplify Oracle CQL view and query construction. You can drag and drop Oracle CQL elements to construct a view or query or you can drag and drop a complete Oracle CQL view or query template and customize it to suit your needs. The Oracle CQL Query Wizard is designed to allow business users to efficiently create syntactically correct Oracle CQL views and queries and apply them immediately to a deployed Oracle CEP application.

Using the Query Wizard, you can create Oracle CQL views and query. You cannot create Oracle CQL streams and relations. Your deployed Oracle CEP application must provide the streams and relations. For more information, see Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

Note:

An Oracle CQL query will immediately begin outputting events if its input channels provide input events. If you plan to use a query selector on a channel with an upstream Oracle CQL processor, you may observe unwanted query results on the downstream channel between the time you add the query to the upstream Oracle CQL processor and the time you configure the query selector on the downstream channel. For more information, see Section 4.2.1.3, "Channel Properties: Outbound Channel With Query Selector".

Alternatively, you can modify an existing Oracle CQL view or query; see Section 6.1.2, "How to Edit a Rule in an Oracle CQL Processor Using the Query Wizard".

To create a rule in an Oracle CQL processor using the Query Wizard:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to use.

Select the Oracle CQL processor you wish to use:

To use the EPN diagram:

Click the Event Processing Network tab.

Double-click the Oracle CQL processor you wish to use.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to use.

Click the Oracle CQL processor you wish to use.

In the right pane, click the General tab

The Processor panel is displayed as Figure 6-1 shows.

Figure 6-1 Oracle CQL Processor Panel

Click the Query Wizard tab.

The Query Wizard tab appears as Figure 6-2 shows.

Figure 6-2 Oracle CQL Query Wizard

For information on the various tools along the top of the Query Wizard canvas, see Section 6.1.11, "Managing the Query Wizard Diagram".

Decide how you want to create the Oracle CQL statement:

To construct the query based on an existing Oracle CEP server template:

Click the Templates tab.

Select a template and drag and drop it into the canvas.

To construct the query based on an existing user-defined template:

Click the User defined templates tab.

Select a template and drag and drop it into the canvas.

Note:

For more information about adding user-defined Oracle CQL statement templates, see Section 6.1.10, "How to Create an Oracle CQL Template for the Query Wizard".

To construct the query one operator at a time or to add additional operators to a template-based Oracle CQL statement:

Click the CQL Constructs tab.

Select a construct and drag and drop it into the canvas.

Repeat until you have added the required constructs to the canvas.

Configure the connections between constructs:

To connect constructs, click on a source construct and drag to a destination construct.

Oracle CEP Visualizer only allows interconnections that conform to Oracle CQL syntax.

Figure 6-3 shows a valid interconnection.

Figure 6-3 Valid Connection

Figure 6-4 shows an invalid interconnection.

Figure 6-4 Invalid Connection

For more information about valid Oracle CQL syntax, see "Oracle CQL Statements" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing.

To abandon a connection attempt, click the Esc key on your keyboard.

To delete an existing connection, click on the connection to select it and then click the Delete key on your keyboard.

Configure each construct by double-clicking the construct and using the editor dialog that appears.

A construct icon without a green check mark is not configured.

A construct icon with a green check mark is configured.

For more information, see:

Section 6.1.9.1, "Configuring an RSource CQL Construct"

Section 6.1.9.2, "Configuring an SSource CQL Construct"

Section 6.1.9.3, "Configuring a Cache-Table CQL Construct"

Section 6.1.9.4, "Configuring a Pattern CQL Construct"

Section 6.1.9.5, "Configuring a Select CQL Construct"

Section 6.1.9.6, "Configuring a Join CQL Construct Using + Syntax"

Section 6.1.9.7, "Configuring a Join CQL Construct Using LEFT or RIGHT OUTER JOIN"

Section 6.1.9.8, "Configuring a Window CQL Construct"

Section 6.1.9.9, "Configuring a Filter CQL Construct"

Section 6.1.9.10, "Configuring a Union CQL Construct"

Section 6.1.9.11, "Configuring an Intersect CQL Construct"

Section 6.1.9.12, "Configuring a Minus CQL Construct"

Section 6.1.9.13, "Configuring an IStream CQL Construct"

Section 6.1.9.14, "Configuring a DStream CQL Construct"

Section 6.1.9.15, "Configuring an RStream CQL Construct"

Section 6.1.9.16, "Configuring an Output CQL Construct"

To save your Oracle CQL statement at any time, click the Save Query button.

The All Saved Queries dialog appears as Figure 6-5 shows.

The All Saved Queries dialog lists any saved queries for the processor you are configuring.

Figure 6-5 All Saved Queries Dialog: Saving

Enter a query name in the Query Id field and click Save.

A confirmation dialog appears as Figure 6-6 shows.

Figure 6-6 Query Save Dialog

Click OK.

Your query is saved to the local disk of the computer you are currently using. To reload your query, you must access the Oracle CEP Visualizer from the same local host.

To reload your Oracle CQL statement after saving, click the Open Query button.

The All Saved Queries dialog appears as Figure 6-7 shows.

Figure 6-7 All Saved Queries Dialog: Loading

Select your query and click Load CQL.

The Oracle CQL statement is loaded to the canvas.

To inject your Oracle CQL statement into the Oracle CQL processor, edit the Output CQL construct and click Inject Rule.

The rule now appears on the CQL Rules tab.

For more information, see Section 6.1.9.16, "Configuring an Output CQL Construct".

After you create a query, update the selector for the outbound channel (the channel down-stream from the Oracle CQL processor you created your query on). This will only work with pre-existing event types.

For more information, see Section 4.2.1.2, "Channel Properties: Outbound Channel".

6.1.2 How to Edit a Rule in an Oracle CQL Processor Using the Query Wizard

Oracle CEP Visualizer provides a sophisticated Query Wizard to simplify Oracle CQL query construction. You can select an existing query on the CQL Query tab and edit the query in the Query Wizard. The Oracle CQL Query Wizard is designed to allow business users to efficiently create syntactically correct Oracle CQL queries and apply them to a deployed Oracle CEP application.

Query Wizard will import a given rule and display it graphically as a set of Oracle CQL operators. You can go into an individual operator and make changes (for example, to change the select expression) without affecting other parts of the Oracle CQL statement.

You can edit existing Oracle CQL queries and views. You cannot edit Oracle CQL streams and relations. Your deployed Oracle CEP application must provide the streams and relations. For more information, see Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

To edit a rule in an Oracle CQL processor using the Query Wizard:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to use.

Select the Oracle CQL processor you wish to use:

To use the EPN diagram:

Click the Event Processing Network tab.

Double-click the Oracle CQL processor you wish to use.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to use.

Click the Oracle CQL processor you wish to use.

In the right pane, click the General tab

The Processor panel is displayed as Figure 6-1 shows.

Figure 6-8 Oracle CQL Processor Panel

Click the CQL Rules tab.

The CQL Rules tab appears as Figure 6-32 shows.

Figure 6-9 CQL Rules Tab

Select the rule you want to edit and click the Query Wizard button.

The Query Wizard opens with the selected rule on the canvas as Figure 6-10 shows.

Figure 6-10 Query Wizard: With Existing Rule

For information on the various tools along the top of the Query Wizard canvas, see Section 6.1.11, "Managing the Query Wizard Diagram".

To view the Oracle CQL statements associated with any operator:

Ensure that the Hover check box is checked.

Hover the mouse pointer over an operator.

The Oracle CQL statement appears as Figure 6-11 shows.

Figure 6-11 Hovering Over an Oracle CQL Operator

To modify the Oracle CQL statements associated with any operator, double click the operator.

The corresponding editor dialog appears.

Figure 6-12 shows the editor dialog after double clicking the Join operator.

Figure 6-12 Editor Dialog for Oracle CQL Join Operator

Use the editor dialog to modify the operator.

For information on configuring all the Query Wizard editor dialogs, see Section 6.1.9, "How to Configure Query Wizard Oracle CQL Constructs".

Click the Add Join button to apply your changes to the generated Oracle CQL statement.

Click the Validate button to ensure that your changes are syntactically correct.

Correct any errors before proceeding.

Click Save to save your changes.

Your query is saved in memory.

Double click your query's Output operator.

Click Replace Rule.

The Oracle CQL rule is now changed and the new version appears in the CQL Rules tab.

Close the Output construct.

6.1.3 How to Create a Parameterized Rule in an Oracle CQL Processor

You can create a parameterized Oracle CQL query.

Note:

You cannot delete a parameterized query and you cannot edit the Oracle CQL query using the Query Wizard.

For more information, see:

Section 6.1.4, "How to Edit a Parameterized Query in an Oracle CQL Processor"

"Paramaterized Queries" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

To create a parameterized rule in an Oracle CQL processor:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to use.

Select the Oracle CQL processor you wish to use:

To use the EPN diagram:

Click the Event Processing Network tab.

Double-click the Oracle CQL processor you wish to use.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to use.

Click the Oracle CQL processor you wish to use.

In the right pane, click the General tab

The Processor panel is displayed as Figure 6-1 shows.

Figure 6-13 Oracle CQL Processor Panel

Click the CQL Rules tab.

The CQL Rules tab appears as Figure 6-32 shows.

Figure 6-14 CQL Rules Tab

Click the Query radio button.

Click Add Query.

Enter a query name in the Query Id field.

Enter the Oracle CQL query in the Query field.

Use placeholder characters (:n) to specify parameterized values.

Configure the Enable option:

To enable the query as soon as it is saved, click true.

To keep the query disabled after it is saved, click false.

Click Save.

A confirmation dialog appears as Figure 6-15 shows.

Figure 6-15 Query Save Dialog

Click OK.

Your query is saved to the local disk of the computer you are currently using. To reload your query, you must access the Oracle CEP Visualizer from the same local host.

Edit the parameterized query to add parameter values as Section 6.1.4, "How to Edit a Parameterized Query in an Oracle CQL Processor" describes.

After you create a query, update the selector for the outbound channel (the channel down-stream from the Oracle CQL processor you created your query on). This will only work with pre-existing event types.

For more information, see Section 4.2.1.2, "Channel Properties: Outbound Channel".

6.1.4 How to Edit a Parameterized Query in an Oracle CQL Processor

You can edit the parameter values of an existing Oracle CQL parameterized query. You can add a new list of parameter values, modify an existing list of parameter values, or delete an existing list of parameter values.

Note:

You cannot add or remove placeholder characters (:n) nor can you edit the Oracle CQL query using the Query Wizard.

For more information, see:

Section 6.1.3, "How to Create a Parameterized Rule in an Oracle CQL Processor"

"Paramaterized Queries" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

To edit a parameterized query in an Oracle CQL processor:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to use.

Select the Oracle CQL processor you wish to use:

To use the EPN diagram:

Click the Event Processing Network tab.

Double-click the Oracle CQL processor you wish to use.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to use.

Click the Oracle CQL processor you wish to use.

In the right pane, click the General tab

The Processor panel is displayed as Figure 6-1 shows.

Figure 6-16 Oracle CQL Processor Panel

Click the CQL Rules tab.

The CQL Rules tab appears as Figure 6-32 shows.

Figure 6-17 CQL Rules Tab: Parameterized Query

Note:

The Query Wizard button is not available for parameterized queries.

Select the parameterized query.

Use the CQL Rules tab to modify the paramaterized query:

Section 6.1.4.1, "Adding a Parameter"

Section 6.1.4.2, "Replacing a Parameter"

Section 6.1.4.3, "Deleting a Parameter"

Section 6.1.4.4, "Editing the Query"

Section 6.1.4.5, "Deleting the Query"

6.1.4.1 Adding a Parameter

To add a parameter to a parameterized query:

Click the Add Parameter button.

The CQL Rules tab changes as Figure 6-18 shows.

Figure 6-18 CQL Rules Tab: Add Parameter

Enter a binding name in the Binding Name field.

Enter the new parameter values as a comma-separated list of values in the Binding Values field.

Click Save.

The Add New Binding Dialog appears as Figure 6-19 shows.

Figure 6-19 Add New Binding Dialog

Click OK.

The CQL Rules tab updates to list the new parameter as Figure 6-20 shows.

Figure 6-20 CQL Rules Tab: Add Parameter Complete

6.1.4.2 Replacing a Parameter

To replace a parameter in a paramaterized query:

Select an existing parameter as Figure 6-21 shows.

Figure 6-21 CQL Rules Tab: Select Parameter

Click Replace Parameter.

The CQL Rules tab changes as Figure 6-22 shows.

Figure 6-22 CQL Rules: Replace Parameter

Edit the Binding Values field.

Click Save.

The Update Binding Dialog appears as Figure 6-23 shows.

Figure 6-23 Update Binding Dialog

Click OK.

6.1.4.3 Deleting a Parameter

To delete a parameter in a parametrized query:

Select an existing parameter as Figure 6-24 shows.

Figure 6-24 CQL Rules Tab: Select Parameter

Click Delete Parameter.

The Delete Binding Dialog appears as Figure 6-23 shows.

Figure 6-25 Delete Binding Dialog

Click OK.

6.1.4.4 Editing the Query

To edit a parameterized query, you must first delete all query parameters before the Edit Query button is available. For information on deleting parameters, see Section 6.1.4.3, "Deleting a Parameter."

6.1.4.5 Deleting the Query

To delete a parameterized query, you must first delete all query parameters before the Delete Query button is available. For more information, see Section 6.1.4.3, "Deleting a Parameter."

6.1.5 How to Stop and Start a Parameterized Query

When you stop or start a parameterized query, all bindings associated with the parameterized query are stopped or started.

To stop or start a parameterized query, select the query on the CQL Rules tab and click the Stop or Start button.

6.1.6 How to Delete a Rule in an Oracle CQL Processor

You can delete an existing Oracle CQL view or query or delete all Oracle CQL views or queries in an Oracle CQL processor.

To delete a rule in an Oracle CQL processor:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to use.

Select the Oracle CQL processor you wish to use:

To use the EPN diagram:

Click the Event Processing Network tab.

Double-click the Oracle CQL processor you wish to use.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to use.

Click the Oracle CQL processor you wish to use.

In the right pane, click the General tab

The Processor panel is displayed as Figure 6-26 shows.

Figure 6-26 Oracle CQL Processor Panel

Click the CQL Rules tab.

The CQL Rules tab appears as Figure 6-32 shows.

Figure 6-27 CQL Rules Tab

Filter the list of rules to show only the type of rule you want to delete:

Select View to see only view rules.

Select Query to see only query views.

Note:

You cannot add, delete, or modify a single rule if you select All Rules. You must select a particular view or query to add, delete, or modify a single rule. To make changes to either views or queries, you must select View or Query. The All Rules page is a read-only panel.

Also note that you can turn off a query dynamically using the Enable radio buttons.

The Delete All Views or Delete All Queries button is active as Figure 6-28 shows.

Figure 6-28 CQL Rules: Filtered by View

Decide what rules you want to delete:

To delete a single rule:

Select the rule you want to delete.

Click Delete View or Delete Query.

A confirmation dialog appears as Figure 6-29 shows.

Figure 6-29 Delete Rule Dialog

To delete all rules:

Click Cancel to unselect any rules that may be currently selected.

Click Delete All Views or Delete All Queries.

A confirmation dialog appears as Figure 6-30 shows.

Figure 6-30 Delete All Rule Dialog

Click OK.

6.1.7 How to Replace a Rule in an Oracle CQL Processor

Using Oracle CEP Visualizer, you can replace an existing view or query by either editing the Oracle CQL statement directly or using the Query Wizard.

To replace a rule in an Oracle CQL processor:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to use.

Select the Oracle CQL processor you wish to use:

To use the EPN diagram:

Click the Event Processing Network tab.

Double-click the Oracle CQL processor you wish to use.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to use.

Click the Oracle CQL processor you wish to use.

In the right pane, click the General tab

The Processor panel is displayed as Figure 6-31 shows.

Figure 6-31 Oracle CQL Processor Panel

Click the CQL Rules tab.

The CQL Rules tab appears as Figure 6-32 shows.

Figure 6-32 CQL Rules Tab

Filter the list of rules to show only the type of rule you want to replace:

Select View to see only view rules.

Select Query to see only query views.

Select the rule you wish to replace.

The View or Query field is now editable and the Replace Rule button is active as Figure 6-33 shows.

Figure 6-33 CQL Rules: Filtered by View

Edit the Oracle CQL statement by doing one of the following:

Directly edit the Oracle CQL statement in the View or Query field.

Click the Query Wizard button to edit the rule in the Query Wizard.

For more information, see Section 6.1.2, "How to Edit a Rule in an Oracle CQL Processor Using the Query Wizard".

Commit your changes:

If you directly edited the Oracle CQL statement in the View or Query field, click Replace View or Replace Query.

If you edited the Oracle CQL statement using the Query Wizard, you commit your changes in the Query Wizard.

For more information, see Section 6.1.2, "How to Edit a Rule in an Oracle CQL Processor Using the Query Wizard".

6.1.8 How to View a Rule in an Oracle CQL Processor

Using Oracle CEP Visualizer, you can view the existing rules defined on an Oracle CQL processor.

To view a rule in an Oracle CQL processor:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application you want to use.

Select the Oracle CQL processor you wish to use:

To use the EPN diagram:

Click the Event Processing Network tab.

Double-click the Oracle CQL processor you wish to use.

To use the domain tree:

Expand the appname > Stages node, where appname is the name of the application you want to use.

Click the Oracle CQL processor you wish to use.

In the right pane, click the General tab

The Processor panel is displayed as Figure 6-1 shows.

Figure 6-34 Oracle CQL Processor Panel

Click the CQL Rules tab.

The CQL Rules tab appears as Figure 6-32 shows.

Figure 6-35 CQL Rules Tab

6.1.9 How to Configure Query Wizard Oracle CQL Constructs

This section describes how to configure the various Oracle CQL constructs that the Query Wizard provides, including:

Section 6.1.9.1, "Configuring an RSource CQL Construct"

Section 6.1.9.2, "Configuring an SSource CQL Construct"

Section 6.1.9.3, "Configuring a Cache-Table CQL Construct"

Section 6.1.9.4, "Configuring a Pattern CQL Construct"

Section 6.1.9.5, "Configuring a Select CQL Construct"

Section 6.1.9.6, "Configuring a Join CQL Construct Using + Syntax"

Section 6.1.9.7, "Configuring a Join CQL Construct Using LEFT or RIGHT OUTER JOIN"

Section 6.1.9.8, "Configuring a Window CQL Construct"

Section 6.1.9.9, "Configuring a Filter CQL Construct"

Section 6.1.9.10, "Configuring a Union CQL Construct"

Section 6.1.9.11, "Configuring an Intersect CQL Construct"

Section 6.1.9.12, "Configuring a Minus CQL Construct"

Section 6.1.9.13, "Configuring an IStream CQL Construct"

Section 6.1.9.14, "Configuring a DStream CQL Construct"

Section 6.1.9.15, "Configuring an RStream CQL Construct"

Section 6.1.9.16, "Configuring an Output CQL Construct"

Section 6.1.9.17, "Configuring an Expression Using the Expression Builder"

6.1.9.1 Configuring an RSource CQL Construct

The RSource Oracle CQL construct represents an Oracle CQL relation that your Oracle CEP application provides or a relation type of view that you create. To create a stream type of source, an SSource, see Section 6.1.9.2, "Configuring an SSource CQL Construct".

For more information and detailed syntax, see:

"Streams and Relations" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"Queries, Views, and Joins" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"Oracle CQL Statements" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

To configure an RSource CQL construct:

Double click the RSource icon as Figure 6-36 shows.

Figure 6-36 RSource Icon

The RSource editor dialog appears as Figure 6-37 shows.

Figure 6-37 Query Wizard RSource Editor Dialog

Edit the dialog as Table 6-1 describes.

Table 6-1 Query Wizard RSource Editor Attributes

Attribute
Description

Type

Select the type of source:

Relation: select this option to process events offered by a relation (query) currently running on this Oracle CQL processor.

View: select this option to process events offered by a view currently running on this Oracle CQL processor.

Select a source

Select the relation or view to use as the source of events.

As

Optionally specify an alias for this source.

Source Properties

Read-only list of the properties of the event offered by this source.

Generated CQL Statement

Read-only Oracle CQL fragment associated with this CQL Construct.

Click the Validate button to ensure that your changes are syntactically correct.

Correct any errors before proceeding.

Click Save.

The RSource icon displays a green check mark to indicate that it is configured.

6.1.9.2 Configuring an SSource CQL Construct

The SSource Oracle CQL construct represents an Oracle CQL stream that your Oracle CEP application provides or a stream type of view you create. To create a relation type of source, an RSource, see Section 6.1.9.1, "Configuring an RSource CQL Construct".

For more information and detailed syntax, see:

"Streams and Relations" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"Queries, Views, and Joins" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"Oracle CQL Statements" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

To configure an SSource CQL construct:

Double click the SSource icon as Figure 6-36 shows.

Figure 6-38 SSource Icon

The SSource editor dialog appears as Figure 6-37 shows.

Figure 6-39 Query Wizard Source Editor Dialog

Edit the dialog as Table 6-1 describes.

Table 6-2 Query Wizard Source Editor Attributes

Attribute
Description

Type

Select the type of source:

Stream: select this option to process events offered by a stream provided by your Oracle CEP application.

View: select this option to process events offered by a view currently running on this Oracle CQL processor.

Select a source

Select the stream or view to use as the source of events.

As

Optionally specify an alias for this source.

Source Properties

Read-only list of the properties of the event offered by this source.

Generated CQL Statement

Read-only Oracle CQL fragment associated with this CQL Construct.

Click the Validate button to ensure that your changes are syntactically correct.

Correct any errors before proceeding.

Click Save.

The Source icon displays a green check mark to indicate that it is configured.

6.1.9.3 Configuring a Cache-Table CQL Construct

The Cache-Table CQL construct represents an external relation, usually a pull data source, that a cache or relational database table provides. The only operation that is allowed on the Cache-Table CQL construct is a join with another stream source using the Now window.

For more information, see:

"Configuring Access to a Relational Database" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

"Configuring an Oracle CQL Processor Table Source" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

"Configuring Caching" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

"Configuring an Oracle CQL Processor Cache Source" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

"Oracle Continuous Query Language (CQL) Example" in the Oracle Fusion Middleware Getting Started Guide for Oracle Complex Event Processing

Section 6.1.9.6, "Configuring a Join CQL Construct Using + Syntax"

Section 6.1.9.8, "Configuring a Window CQL Construct"

To configure a Cache-Table CQL construct:

Double click the Cache-Table icon as Figure 6-40 shows.

Figure 6-40 Cache-Table Icon

The Cache-Table editor dialog appears as Figure 6-41 shows.

Figure 6-41 Query Wizard Cache-Table Editor Dialog

Edit the dialog as Table 6-3 describes.

Table 6-3 Query Wizard Cache-Table Editor Attributes

Attribute
Description

Select a source

Select the cache to use as the source of events.

As

Optionally specify an alias for this source.

Source Properties

Read-only list of the properties of the event offered by this source.

Generated CQL Statement

Read-only Oracle CQL fragment associated with this CQL Construct.

Click Save.

The Cache-Table icon displays a green check mark to indicate that it is configured.

6.1.9.4 Configuring a Pattern CQL Construct

The Pattern Oracle CQL construct represents the Oracle CQL MATCH_RECOGNIZE condition. The MATCH_RECOGNIZE condition is the principle means of performing complex event processing. Using its various clauses, you can succinctly express complex conditions among stream elements to perform advanced comparisons optimized for data streams.

The Pattern Oracle CQL construct editor provides a tab for each of the following MATCH_RECOGNIZE sub-clauses:

PATTERN: Use this clause to specify quantifiers that constrain and control when conditions in the DEFINE clause match.

See Figure 6-43, "Query Wizard Pattern Editor Dialog: Pattern Tab".

DEFINE: Use this clause to specify one or more conditions. Specify one or more patterns made up of a pattern identifier, the AS operator, and a condition. The condition can use any stream elements in the schema of the stream, view, or sliding window specified by the identifier you used in your query or view select statement.

See Figure 6-44, "Query Wizard Pattern Editor Dialog: Define Tab".

SUBSET: Using this clause, you can bind a name to the stream elements that one or more patterns select. You can use this named subset in the MEASURE and DEFINE clauses.

See Figure 6-45, "Query Wizard Pattern Editor Dialog: Subset Tab".

MEASURE: Use this clause to define expressions in a MATCH_RECOGNIZE condition and to bind stream elements that match conditions in the DEFINE clause to arguments that you can include in the select statement of a query. You can use any of the Oracle CQL built-in or user-defined functions.

See Figure 6-46, "Query Wizard Pattern Editor Dialog: Measure Tab".

For more information and detailed syntax, see:

"MATCH_RECOGNIZE Condition" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"PATTERN Clause" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"DEFINE Clause" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"SUBSET Clause" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"MEASURES Clause" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"Functions" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

"Oracle CQL Statements" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing

To configure a Pattern CQL construct:

Double click the Pattern icon as Figure 6-42 shows.

Figure 6-42 Pattern Icon

The Pattern editor dialog appears as Figure 6-43 shows.

Figure 6-43 Query Wizard Pattern Editor Dialog: Pattern Tab

Edit the Pattern tab as Table 6-4 describes.

Table 6-4 Query Wizard Pattern Editor Attributes: Pattern Tab

Attribute
Description

Pattern Expression

Use this clause to specify quantifiers that constrain and control when conditions in the DEFINE clause match. For example:

(A B* C)

Table 6-5 lists the pattern quantifiers Oracle CQL supports. Use the pattern quantifiers to specify the allowed range of pattern matches. The one-character pattern quantifiers are maximal or "greedy"; they will attempt to match the biggest quantity first. The two-character pattern quantifiers are minimal or "reluctant"; they will attempt to match the smallest quantity first.

For more information, see "PATTERN Clause" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing.

Duration

By default, Oracle CEP updates the output relation at the time it recognizes a pattern match. Enter a duration value to specify a time delay between when Oracle CEP recognizes a pattern match and when it updates the output relation. You can use either of the following:

When you specify a duration like 10, each time Oracle CEP recognizes a pattern match, it delays the specified time interval before updating the output relation. If no input matches the pattern, Oracle CEP does not update the output relation

When you specify a duration like MULTIPLES OF 10, each time Oracle CEP recognizes a pattern match, it delays the specified time interval before updating the output relation. If no input matches the pattern or if no input is received, Oracle CEP still updates the output relation. In this case, some terms in the selection may be null and aggregate values may be reset.

For more information, see "DURATION Clause" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing.

Partition By

Use this optional clause to specify the stream elements by which a MATCH_RECOGNIZE clause should partition its results. You can reference any stream elements in the schema of the stream, view, or sliding window specified by the identifier you used in the query or view select statement.

To add a stream element to the partition by list, select a stream element from the pull-down menu and click the Add button.

To remove a stream element from the partition by list, click the Undo button.

For more information, see "PARTITION BY Clause" in the Oracle Fusion Middleware CQL Language Reference for Oracle Complex Event Processing.

Pattern Alias

Specifies the relation_variable clause AS operator to define an alias to label the immediately preceding expression in the select list so that you can reference the result by that name. The alias effectively renames the select list item for the duration of the query.

Specifying a pattern alias of its would correspond to the following example:

7 Managing EPL Rules

This chapter describes how you can use Oracle CEP Visualizer to develop and manage Event Processing Language (EPL) rules, a deprecated language for selecting events as they pass through an event processing network (new applications should use Oracle Continuous Query Language).

Section 7.1, "Creating a Rule in an EPL Processor"

Section 7.2, "Deleting a Rule From an EPL Processor"

Section 7.3, "Replacing a Rule in an EPL Processor"

Section 7.4, "Changing the dataservices Application Event Filter Rule Using EPL"

Note:

Oracle CQL replaces Event Processing Language (EPL) in Oracle CEP 11g Release 1 (11.1.1.6.0). Oracle CEP supports EPL for backwards compatibility. For more information, see Chapter 6, "Managing Oracle CQL Rules".

Note:

Any changes to rules and Oracle high availability adapters are propagated to the other servers in the same group. That is, all rule and and Oracle high availability adapter configurations is automatically synchronized. Other configuration changes are not synchronized. For example, if you change record/playback or JMS adapter configuration on one server in a multi-server domain, then these changes are not synchronized with the other servers in the same group. For more information, see Chapter 18, "Managing Multi-Server Domains"

For more information, see:

Section 3.3, "Rules Management"

Oracle Fusion Middleware EPL Language Reference for Oracle Complex Event Processing.

7.1 Creating a Rule in an EPL Processor

You can create a new rule in an existing Oracle CEP application that uses one or more EPL processors.

7.1.1 How to Create a Rule in an EPL Processor

You can create a rule in an EPL processor using the Oracle CEP Visualizer.

To create a rule in an EPL processor:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Expand the appname > Stages node to see a list of the EPN stages in the domain tree, where appname is the name of the application.

Click the EPL processor in which you want to create an EPL rule.

The Processor panel is displayed as Figure 7-1 shows.

Figure 7-1 EPL Processor Panel

In the right pane, click the Rules tab.

The Rules tab appears as Figure 7-2 shows.

Figure 7-2 EPL Rules Tab

Click in the Rule ID field and enter the name of the rule you want to create.

Click in the Rule field and enter the EPL query string.

Click Create Rule.

A confirmation dialog appears as Figure 7-3 shows.

Figure 7-3 Create Rule Dialog

Click OK.

7.2 Deleting a Rule From an EPL Processor

You can delete an existing rule in an existing Oracle CEP application that uses one or more EPL processors.

7.2.1 How to Delete a Rule in an EPL Processor

You can delete a rule in an EPL processor using the Oracle CEP Visualizer.

To delete a rule in an EPL processor:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Expand the appname > Stages node to see a list of the EPN stages in the domain tree, where appname is the name of the application.

Click the EPL processor in which you want to create an EPL rule.

The Processor panel is displayed as Figure 7-1 shows.

Figure 7-4 EPL Processor Panel

In the right pane, click the Rules tab.

The Rules tab appears as Figure 7-5 shows.

Figure 7-5 EPL Rules Tab

Decide what rules you want to delete:

To delete a single rule:

Select the rule you want to delete.

Click Delete Rule

A confirmation dialog appears as Figure 7-6 shows.

Figure 7-6 Delete Rule Dialog

To delete all rules:

Click Cancel to unselect any rules that may be currently selected.

Click Delete All Rules.

A confirmation dialog appears as Figure 7-6 shows.

Figure 7-7 Delete All Rule Dialog

Click OK.

7.3 Replacing a Rule in an EPL Processor

You can use the replace rule feature of Oracle CEP Visualizer to modify an existing rule. However, you should use this feature with extreme caution; this is because, internally, Oracle CEP Visualizer first deletes the rule and then adds it back again with the replaced text. The deletion of the rule causes all states to be lost before the rule is added again. For this reason, you should replace only stateless rules.

7.3.1 How to Replace a Rule in an EPL Processor

You can replace a rule in an EPL processor using the Oracle CEP Visualizer.

To replace a rule in an EPL processor:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Expand the appname > Stages node to see a list of the EPN stages in the domain tree, where appname is the name of the application.

Click the EPL processor in which you want to create an EPL rule.

The Processor panel is displayed as Figure 7-1 shows.

Figure 7-8 EPL Processor Panel

In the right pane, click the Rules tab.

The Rules tab appears as Figure 7-5 shows.

Figure 7-9 EPL Rules Tab

Select the rule you want to replace.

Click in the Rule field and enter the new EPL query string.

Click Replace Rule.

A confirmation dialog appears as Figure 7-3 shows.

Figure 7-10 Replace Rule Dialog

Click OK.

7.4 Changing the dataservices Application Event Filter Rule Using EPL

The com.bea.wlevs.dataservices application includes the MonitorProcessor which in turn is associated with a default rule used to filter the events that are outputted to the diagnostic Dashboard. You can change this rule, or add new ones, if you want to customize this filtering.

You can only change the dataservices application event filter rule using EPL rules.

The event type used in an EPL rule is com.bea.wlev.dataservice.cep.DSMonitorEvent; it has the following properties:

profile—Name of the diagnostic profile.

date —Date and timestamp.

metric—Metric number.

start—Start stage name.

end—End stage name.

type—The type of metric; valid values are avg-latency, avg-throughput or max-latency.

application—Application name

For example, if you want to filter the monitoring events by type and metric, you might change the EPL rules to the following:

  SELECT * FROM DSMonitorEvent
  RETAIN 1 EVENT
  WHERE metric < 300 AND type = 'avg-latency'
  SELECT * FROM DSMonitorEvent
  RETAIN 1 EVENT
  WHERE metric < 300 AND type = 'avg-throughput'
  SELECT * FROM DSMonitorEvent
  RETAIN 1 EVENT
  WHERE metric < 300 AND type = 'max-latency'

If you want to continuously view three events where the number of metrics is less than 300 and group the events by type, try this EPL rule:

  SELECT *, COUNT(metric)
  FROM DSMonitorEvent
  RETAIN BATCH OF 3 EVENTS PARTITION BY type
  WHERE metric < 300
  HAVING COUNT(metric) = 3
  OUTPUT LAST 1 EVERY 3 EVENTS

If you want to continuously view three events where the average number of metrics is less than 300 and group the events by type, try this EPL rule:

  SELECT *, AVG(metric)
  FROM DSMonitorEvent
  RETAIN BATCH OF 3 EVENTS PARTITION BY type
  HAVING AVERAGE(metric) < 300
  OUTPUT LAST 1 EVERY 3 EVENTS

For more information, see Oracle Fusion Middleware EPL Language Reference for Oracle Complex Event Processing.

7.4.1 How to Change the Dataservices Application Event Filter Rule Using EPL

You can change the dataservices application event filter EPL rule using the Oracle CEP Visualizer.

To change the dataservices application event filter rule using EPL:

In the left pane, click Domain > Server > Applications > com.bea.wlevs.dataservices > Stages > MonitorProcessor, where Domain is the name of your domain and Server is the name of your server.

In the right pane, click the Rules tab.

The Rules tab appears as Figure 7-11 shows.

Figure 7-11 EPL Rules Tab

To create a new Rule, enter a the name of the rule in the Rule ID field, enter the EPL query string in the Rule field, then click Create Rule.

For more information, see Section 7.1, "Creating a Rule in an EPL Processor".

To delete an existing rule, select a rule in the table and click Delete Rule.

For more information, see Section 7.2, "Deleting a Rule From an EPL Processor".

To change the default rule, click its name in the Rules table, make the change in the Rule field in the Working Area, and click Replace Rule.

For more information, see Section 7.3, "Replacing a Rule in an EPL Processor".

8 Managing Configuration History

This chapter describes how you can use Oracle CEP Visualizer to view, roll back, or delete configuration revision history, managing revisions by application or by resource.

Section 8.1, "Managing Resource Configuration History"

Section 8.2, "Managing Application Configuration History"

For more information, see Section 3.4, "Configuration History Management".

8.1 Managing Resource Configuration History

You can manage configuration history by resource as Section 3.4.2, "Resource Configuration History Management" describes.

Alternatively, you can view configuration change history by application (see Section 8.2, "Managing Application Configuration History").

8.1.1 How to Manage Resource Configuration History

You can manage resource configuration history using the Oracle CEP Visualizer.

To manage resource configuration history:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application whose configuration history you want to manage.

In the right pane, click the History tab.

The History tab is displayed as Figure 8-1 shows.

Figure 8-1 History Tab

In the right pane, click the Revisions tab.

The Revisions tab appears as Figure 8-2 shows.

Figure 8-2 Revisions Tab

Filter the list of revisions by entering an appropriate Start Time and End Time and then click Refresh.

The list refreshes to show only the revisions made in this time period.

Manage the resource change records:

To delete a revision, click Delete.

All the revisions pertaining to the selected Start Time and End Time are deleted from the resource change history but resource configuration is unchanged.

To undo (roll back) the changes that the revision specifies, click Undo.

All the revisions pertaining to the selected Start Time and End Time are rolled back and the affected resources assume the configuration of the previous change record.

8.2 Managing Application Configuration History

You can manage configuration history by application as Section 3.4.3, "Application Configuration History Management" describes.

Alternatively, you can manage configuration change history by resource (see Section 8.1, "Managing Resource Configuration History").

8.2.1 How to Manage Application Configuration History

You can manage application configuration history using the Oracle CEP Visualizer.

To manage application configuration history:

In the left pane, navigate to and expand the Applications node of the Oracle CEP instance to which the application is deployed.

Select appname, where appname is the name of the application whose configuration history you want to manage.

In the right pane, click the History tab.

The History tab is displayed as Figure 8-3 shows.

Figure 8-3 History Tab

In the right pane, click the Changes tab.

The Changes tab appears as Figure 8-4 shows.

Figure 8-4 Changes Tab

Filter the list of change records by entering an appropriate Start Time and End Time and then click Refresh.

The list refreshes to show only the change records that were made in this time period.

Manage the application change records:

To delete change records, click Delete.

All the change records pertaining to the selected Start Time and End Time are deleted from the application change history but the application configuration is unchanged.

To undo (roll back) the changes that a change record specifies, click Undo.

All the change records pertaining to the selected Start Time and End Time are rolled back and the affected application assumes the configuration of the previous change record.

Part III

Server and Domain Tasks

Part III contains the following chapters:

Chapter 9, "Overview of Server and Domain Tasks"

Chapter 10, "Managing Deployments"

Chapter 11, "Managing Jetty"

Chapter 12, "Managing JMX"

Chapter 13, "Managing Data Sources"

Chapter 14, "Managing HTTP Publish-Subscribe Servers"

Chapter 15, "Managing the Event Inspector Service"

Chapter 16, "Managing the Event Type Repository"

Chapter 17, "Managing the Persistent Event Store"

Chapter 18, "Managing Multi-Server Domains"

Chapter 19, "Managing Oracle CEP Server Logs"

9 Overview of Server and Domain Tasks

This chapter introduces typical server and domain management tasks you can perform with Oracle CEP Visualizer, including managing deployment, multi-server domains, logs, caches, the event type repository, and more.

Section 9.1, "Deployment Management"

Section 9.2, "Jetty Management"

Section 9.3, "JMX Management"

Section 9.4, "Data Source Management"

Section 9.5, "HTTP Publish-Subscribe Server Management"

Section 9.6, "Event Type Repository Management"

Section 9.7, "Persistent Event Store Management"

Section 9.8, "Multi-Server Domain Management"

Section 9.9, "Event Inspector Service Management"

Section 9.10, "Cache Management"

Section 9.11, "Log Management"

9.1 Deployment Management

Using the Oracle CEP Visualizer, you can view the applications and application libraries deployed to a selected Oracle CEP server.

For more information, see:

Chapter 10, "Managing Deployments"

Chapter 5, "Managing Application Lifecycle"

"Managing an Application Library" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

9.2 Jetty Management

Oracle CEP supports Jetty (see http://www.mortbay.org/jetty/) as the Java Web server to deploy HTTP servlets and static resources.

Oracle CEP support for Jetty is based on Version 1.2 the OSGi HTTP Service. This API provides the ability to dynamically register and unregister javax.servlet.Servlet objects with the run time and static resources.

Oracle CEP allows you to configure how your application prioritizes the execution of its work. Based on rules you define and by monitoring actual run time performance, you can optimize the performance of your application and maintain service level agreements. You define the rules and constraints for your application by defining a work manager.

For more information, see:

Chapter 11, "Managing Jetty"

"Configuring Jetty for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

"Jetty Work Managers" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

9.3 JMX Management

Oracle CEP provides standards-based interfaces that are fully compliant with the Java Management Extensions (JMX) specification. Software vendors can use these interfaces to monitor Oracle CEP MBeans, to change the configuration of an Oracle CEP domain, and to monitor the distribution (activation) of those changes to all server instances in the domain.

Oracle CEP Visualizer and the wlevs.Admin command line tool both use JMX to connect to a server. However, to use these tools, and the JMX interfaces in general, you must configure Oracle CEP with the JMX configuration information in the config.xml file.

For more information, see:

Chapter 12, "Managing JMX"

"Configuring JMX for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

9.4 Data Source Management

Oracle CEP supports Java Database Connectivity (JDBC) 3.0 for relational database access.

The JDBC API provides a standard, vendor-neutral mechanism for connecting to and interacting with database servers and other types of tabular resources that support the API. The JDBC javax.sql.DataSource interface specifies a database connection factory that is implemented by a driver. Instances of DataSource objects are used by applications to obtain database connections (instances of java.sql.Connection). After obtaining a connection, an application interacts with the resource by sending SQL commands and receiving results.

For more information, see:

Chapter 13, "Managing Data Sources"

"Configuring JDBC for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

9.5 HTTP Publish-Subscribe Server Management

Oracle CEP includes an HTTP publish-subscribe server to which applications can publish messages. Applications publish messages to a particular channel; other applications can then subscribe to this channel to receive these published messages.

Oracle CEP HTTP pub-sub server channels may be:

Static: those channels configured in the Oracle CEP server config.xml and used by Oracle CEP Visualizer itself.

Oracle CEP Visualizer includes the following static channels (preconfigured in config.xml) that are used by Oracle CEP Visualizer itself; they cannot be deleted or modified:

/evsmonitor

/evsalert

/evsdomainchange

Dynamic: those channels that are not configured in the Oracle CEP server config.xml but created dynamically when the Oracle CEP sever is running. You can view statistics for dynamic channels, including the number of messages sent to this channel and the number of subscribers. Dynamic channel configuration is read-only.

Oracle CEP Visualizer supports only the Event Inspector service dynamic channel.

User-defined: those static channels that your Oracle CEP application creates.

Note:

When one application (application-1) advertises a channel that a second application (application-2) subscribes to and uses as a foreign stage, you cannot view the details of the advertised channel from application-2. To view the details of this channel, you must do so from application-1.

You can use Oracle CEP Visualizer to modify existing channels, as well as create new ones and delete existing ones. When you configure channels with Oracle CEP Visualizer, they are permanent and survive server restart. Channels configured using APIs from a custom HTTP pub-sub adapter are dynamic and do not survive server restart.

For more information, see:

Chapter 14, "Managing HTTP Publish-Subscribe Servers"

Chapter 24, "Managing HTTP Publish-Subscribe Server Security"

Section 4.4, "Tracing and Injecting Events in the EPN"

"Configuring HTTP Publish-Subscribe for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

9.6 Event Type Repository Management

Event types define the properties of the events that are handled by Oracle CEP applications. All the event types used by the applications of a server make up the event type repository.

For more information, see:

Chapter 16, "Managing the Event Type Repository"

"Creating Oracle CEP Event Types" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

9.7 Persistent Event Store Management

The Oracle CEP event repository feature allows you to persist the events that flow out of a component of the event processing network (EPN) to a store, such as a database table, and then play them back at a later stage or explicitly query the events from a component such as an event bean. By default, Oracle CEP stores recorded events in a database, which means that before you can start using the record and playback feature in your own application, you must specify where the database server is located along with the name of the database server that will contain the recorded events.

For more information, see:

Chapter 17, "Managing the Persistent Event Store"

"Storing Events in the Persistent Event Store" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

9.8 Multi-Server Domain Management

An Oracle CEP multi-server domain (or cluster) is a set of two or more servers logically connected for the purposes of management, and physically connected using a shared User Datagram Protocol (UDP) multicast address and port. All servers in an Oracle CEP multi-server domain are aware of all other servers in the domain and any one server can be used as an access point for making changes to the deployments in the domain.

Oracle CEP supports the following clustering systems:

evs4j: Oracle CEP native clustering implementation.

Oracle Coherence: a JCache-compliant in-memory distributed data grid solution for clustered applications and application servers. It coordinates updates to the data using cluster-wide concurrency control, replicates data modifications across the cluster using the highest performing clustered protocol available, and delivers notifications of data modifications to any servers that request them. You take advantage of Oracle Coherence features using the standard Java collections API to access and modify data, and use the standard JavaBean event model to receive data change notifications.

Note:

Before you can use Oracle CEP with Oracle Coherence, you must obtain a valid Oracle Coherence license such as a license for Coherence Enterprise Edition, Coherence Grid Edition, or Oracle WebLogic Application Grid. For more information on Oracle Coherence, see http://www.oracle.com/technology/products/coherence/index.html.

Note:

Any changes to rules and Oracle high availability adapters are propagated to the other servers in the same group. That is, all rule and and Oracle high availability adapter configurations is automatically synchronized. Other configuration changes are not synchronized. For example, if you change record/playback or JMS adapter configuration on one server in a multi-server domain, then these changes are not synchronized with the other servers in the same group. For more information, see:

Chapter 6, "Managing Oracle CQL Rules"

Chapter 7, "Managing EPL Rules"

Section 4.2, "Viewing and Editing the Configuration of a Stage"

For more information, see:

Chapter 18, "Managing Multi-Server Domains"

Section 18.2, "Managing Oracle Coherence"

Section 3.4.5, "Multi-Server Domains and Configuration History Management"

"Administrating Oracle CEP Multi-Server Domains" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

9.9 Event Inspector Service Management

Using the Event Inspector service, you can:

View the events flowing out of any stage in the EPN

Inject events into any stage in the EPN

You can use the Event Inspector service to test and debug Oracle CQL queries during development.

For more information, see:

Chapter 15, "Managing the Event Inspector Service"

Chapter 4, "Tracing and Injecting Events in the EPN"

"Testing Applications With the Event Inspector" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

9.10 Cache Management

A cache is a temporary storage area for events, created exclusively to improve the overall performance of your Oracle CEP application; it is not necessary for the application to function correctly. Oracle CEP applications can optionally publish or consume events to and from a cache to increase the availability of the events and increase the performance of their applications.

A caching system refers to a configured instance of a caching implementation. A caching system defines a named set of configured caches as well as the configuration for remote communication if any of the caches are distributed across multiple machines.

Oracle CEP supports the following caching systems:

Oracle CEP local cache: a local, in-memory single-JVM cache.

Oracle Coherence: a JCache-compliant in-memory distributed data grid solution for clustered applications and application servers. It coordinates updates to the data using cluster-wide concurrency control, replicates data modifications across the cluster using the highest performing clustered protocol available, and delivers notifications of data modifications to any servers that request them. You take advantage of Oracle Coherence features using the standard Java collections API to access and modify data, and use the standard JavaBean event model to receive data change notifications.

Note:

Before you can use Oracle CEP with Oracle Coherence, you must obtain a valid Oracle Coherence license such as a license for Coherence Enterprise Edition, Coherence Grid Edition, or Oracle WebLogic Application Grid. For more information on Oracle Coherence, see http://www.oracle.com/technology/products/coherence/index.html.

Third-party caches: you can create a plug-in to allow Oracle CEP to work with other, third-party cache implementations.

For more information, see:

Section 18.2, "Managing Oracle Coherence"

"Configuring Oracle CEP Caching" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

9.11 Log Management

Oracle CEP Visualizer allows you to change the server-wide logging configuration, such as the severity of log messages you want the server to print out, the name of the log file, and so on.

You can also view and modify the logging level of individual components and configure logging for new components.

For more information, see:

Chapter 19, "Managing Oracle CEP Server Logs"

"Configuring Logging and Debugging for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

10 Managing Deployments

This chapter describes how you can use Oracle CEP Visualizer to view, add, or delete Oracle CEP application deployments on Oracle CEP servers.

Section 10.1, "Viewing Deployments"

Section 10.2, "Adding or Deleting Deployments"

For more information, see:

Section 9.1, "Deployment Management"

Chapter 5, "Managing Application Lifecycle"

10.1 Viewing Deployments

This section describes:

Section 10.1.1, "How to View the Applications Deployed to an Oracle CEP Server"

Section 10.1.2, "How to View the Application Libraries Deployed to an Oracle CEP Server"

10.1.1 How to View the Applications Deployed to an Oracle CEP Server

Using the Oracle CEP Visualizer, you can view the applications deployed to a selected Oracle CEP server.

To view the applications deployed to an Oracle CEP server:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the Applications tab.

The Applications tab is displayed as Figure 10-1 shows.

Figure 10-1 Applications Tab

View the list of deployed applications as Table 10-1 describes.

Table 10-1 Deployed Application Attributes

Attribute
Description

Name

The name of the application.

State

The operational state of the application.

Target

The group to which the application is deployed.

10.1.2 How to View the Application Libraries Deployed to an Oracle CEP Server

Using the Oracle CEP Visualizer, you can view the application libraries deployed to a selected Oracle CEP server.

You can view:

Extension Libraries: these libraries are deployed first along with the Oracle CEP server extension modules.

For more information, see "Library Extensions Directory" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

Libraries: these libraries are deployed after the components in the library extensions directory but before any Oracle CEP applications

For more information, see "Library Directory" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

To view the application libraries deployed to an Oracle CEP server:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

View the libraries associated with applications deployed to this server:

To view extension libraries, in the right pane, click the Extension Libraries tab.

The Extension Libraries tab is displayed as Figure 10-2 shows.

Figure 10-2 Extension Libraries Tab

View the list of deployed application libraries as Table 10-2 describes.

Table 10-2 Application Extension Library Attributes

Attribute
Description

Name

The name of the application library.

State

The operational state of the application library.

To view libraries, in the right pane, click the Libraries tab.

The Libraries tab is displayed as Figure 10-3 shows.

Figure 10-3 Libraries Tab

View the list of deployed application libraries as Table 10-3 describes.

Table 10-3 Application Library Attributes

Attribute
Description

Name

The name of the application library.

State

The operational state of the application library.

10.2 Adding or Deleting Deployments

This section describes:

Section 10.2.1, "How to Add or Delete an Application"

Section 10.2.2, "How to Add or Delete an Application Library"

10.2.1 How to Add or Delete an Application

For more information, see:

Section 5.1.1, "How to Deploy an Application in a Standalone-Server Domain"

Section 5.1.2, "How to Deploy an Application in a Multi-Server Domain"

Section 5.4, "Uninstalling an Application"

10.2.2 How to Add or Delete an Application Library

To add or remove application libraries, you must manually add or remove files from the appropriate Oracle CEP server directory.

For more information, see:

"Library Extensions Directory" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

"Library Directory" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

"Managing an Application Library" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

11 Managing Jetty

This chapter describes how you can use Oracle CEP Visualizer to view and edit Jetty web server configuration, as well as how to view Jetty work manager configuration for an Oracle CEP server.

Section 11.1, "Managing Jetty Web Server Configuration"

Section 11.2, "Managing Work Manager Configuration"

For more information, see Section 9.2, "Jetty Management".

11.1 Managing Jetty Web Server Configuration

This section describes:

Section 11.1.1, "How to View Jetty Web Server Configuration"

Section 11.1.2, "How to Edit Jetty Web Server Configuration"

11.1.1 How to View Jetty Web Server Configuration

Using the Oracle CEP Visualizer, you can view the Jetty Web server configuration for a selected Oracle CEP server.

To view Jetty web server configuration:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the HTTP Server tab.

In the right pane, the properties of the Jetty server are displayed:

The name of the Jetty server.

The network I/O object to which the Jetty server is bound.

The work manager name to which the Jetty server is bound.

The list of Web applications that are deployed to this Jetty server, along with the path of the application and its context path.

11.1.2 How to Edit Jetty Web Server Configuration

You can only view the configuration of the Jetty servers configured in your Oracle CEP server using Oracle CEP Visualizer. To change the configuration, you must manually update the server's config.xml file.

For details, see "Configuring Jetty for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

11.2 Managing Work Manager Configuration

This section describes:

Section 11.2.1, "How to View and Edit Work Manager Configuration"

Section 11.2.2, "How to Create a Work Manager"

Section 11.2.3, "How to Delete a Work Manager"

11.2.1 How to View and Edit Work Manager Configuration

Using the Oracle CEP Visualizer, you can view the work manager configuration for a selected Oracle CEP server.

To view the work manager configuration:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the Work Manager tab.

The Work Manager tab appears as shown in Figure 11-1.

Figure 11-1 Work Manager Tab

In the Work Manager table, select the work manager you want to configure by clicking on its name.

Click the Change button at the bottom of the page.

Update the work manager configuration properties:

Min threads—The minimum number of threads that the server allocates so as to reduce the initial time it takes to perform a task.

Max threads—The maximum number of concurrent threads that execute requests from the constrained work set.

Fair Share—The average thread-use time required to process requests.

Click Save to save your changes or Cancel to cancel the update.

11.2.2 How to Create a Work Manager

You cannot delete existing work managers or create new ones using Oracle CEP Visualizer; rather, you must manually update the server's config.xml file.

For details, see "Jetty Work Managers" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

11.2.3 How to Delete a Work Manager

You cannot delete existing work managers or create new ones using Oracle CEP Visualizer; rather, you must manually update the server's config.xml file.

For details, see "Jetty Work Managers" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

12 Managing JMX

This chapter describes how you can use Oracle CEP Visualizer to view Java Management Extensions (JMX) configuration for use with Oracle CEP.

Section 12.1, "Viewing JMX Configuration"

Section 12.2, "Editing JMX Configuration"

For more information, see Section 9.3, "JMX Management".

12.1 Viewing JMX Configuration

Using the Oracle CEP Visualizer, you can view JMX configuration.

12.1.1 How to View JMX Configuration

Using the Oracle CEP Visualizer, you can view the JMX configuration for a selected Oracle CEP server.

To view JMX configuration:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the JMX tab.

The JMX tab appears as Figure 12-1 shows.

Figure 12-1 JMX Tab

The JMX properties are displayed in the table:

jndi-service-name—The name of the JNDI service to which the JMX server will bind its object.

rmi-service-name—The name of the RMI service with which the JMX server will register to receive calls.

rmi-jrmp-port—The port on which to listen for RMI JRMP JMX requests.

rmi-registry-port—The port on which to start the RMIRegistry.

Note:

Oracle CEP does not support the JRMP protocol: an Oracle CEP JMX client does not use the rmi-jrmp-port or rmi-registry-port properties. Instead, JMX clients must use the more secure MSA protocol for both local and remote access to the Oracle CEP JMX server. When you connect to the Oracle CEP JMX server that is running on localhost or on a remote host, you must always use the JMX URL service:jmx:msarmi://HOST-NAME:PORT/jndi/jmxconnector so that you are always using the MSA connector (where HOST-NAME is either localhost or the name of the remote host and PORT is the Oracle CEP server JNDI port). For more information, see "Accessing the Oracle CEP JMX Server" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

12.2 Editing JMX Configuration

You can only view the JMX configuration of your Oracle CEP server using Oracle CEP Visualizer. To change the configuration, you must manually update the server's config.xml file.

For more information, see "Configuring JMX for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

13 Managing Data Sources

This chapter describes how you can use Oracle CEP Visualizer to view, edit, and add data source configuration for use with Oracle CEP.

Section 13.1, "Viewing and Editing a Data Source"

Section 13.2, "Adding a Data Source"

For more information, see Section 9.4, "Data Source Management".

13.1 Viewing and Editing a Data Source

This section describes:

Section 13.1.1, "How to View a Data Source Configuration"

Section 13.1.2, "How to Edit Data Source Configuration"

13.1.1 How to View a Data Source Configuration

Using the Oracle CEP Visualizer, you can view the data source configuration for a selected Oracle CEP server.

To view a data source configuration:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the DataSource tab.

The DataSource tab appears as Figure 13-1 shows.

Figure 13-1 DataSource Tab

13.1.2 How to Edit Data Source Configuration

Using the Oracle CEP Visualizer, you can edit the data source configuration for a selected Oracle CEP server.

To edit data source configuration:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the DataSource tab.

The DataSource tab appears as Figure 13-2 shows.

Figure 13-2 DataSource Tab

In the Data Sources table, select the data source you want to edit by clicking on its name.

Click Edit.

The Datasource dialog appears as Figure 13-3 shows.

Click the Data Source tab.

The DataSource tab appears as Figure 13-3 shows.

Figure 13-3 Edit Datasource: Data Source Tab

Configure the DataSource tab as Table 13-1 describes.

Table 13-1 Edit Datasource: Data Source Parameters

Parameter
Description

Name

The name for this data source configuration.

JNDI Name

JNDI path to where this data source will be bound. This is the name your Oracle CEP application uses to look up the data source in JNDI.

Global Tx Protocol

Select the protocol for Oracle CEP to use for the transaction branch when processing a global transaction:

OnePhaseCommit (Default)

TwoPhaseCommit

LoggingLastResource

EmulateTwoPhaseCommit

None

Click the Global Tx Protocol tab.

The Global Tx Protocol tab appears as Figure 13-4 shows.

Figure 13-4 Edit Datasource: Global Tx Protocol Tab

Configure the Global Tx Protocol tab as Table 13-2 describes.

Table 13-2 Edit Datasource: Global Tx Protocol Parameters

Parameter
Description

Database Type

Select the type of JDBC driver to use:

Derby

Oracle

SQL Server 2005

Other

URL

Specify the database connection URL appropriate for your database. This URL includes the name of the database, the host and port of the computer on which the database server is running, and so on. Oracle CEP populates a default URL for database types it provides.

Driver Name

Specify the name of the driver for the selected database type. Oracle CEP automatically populates the driver name for types it provides.

User Name

Specify database user account name that you want to use for each connection in the data source.

Password

Specify database user password that you want to use for each connection in the data source

Use XA

Specify whether or not to use distributed transactions:

true: enable distributed transactions.

false: disable distributed transactions.

Click the Connection Pool tab.

The Connection Pool tab appears as Figure 13-5 shows.

Figure 13-5 Edit Datasource: Connection Pool Tab

Configure the Connection Pool tab as Table 13-3 describes.

Table 13-3 Edit Datasource: Connection Pool Parameters

Parameter
Description

Initial Capacity

Specify the number of physical connections to create when creating the connection pool.

Max Capacity

Specify the maximum number of physical connections that this connection pool can contain.

Capacity Increment

Specify how many connections to add when all the connections in the connection pool are in use and the connection pool receives a new connection request.

Test

Enter the name of a small table to use in a query if you want to test the database connection before handing it to the requesting application. The standard query is select 1 from table_name. If you prefer to use a different query as a connection test, enter SQL followed by a space and the SQL code you want to use to test database connections.

Click Save.

The datasource is updated in the Oracle CEP server configuration.

13.2 Adding a Data Source

You can add a data source using the Oracle CEP Visualizer.

13.2.1 How to Add a Data Source Configuration

Using the Oracle CEP Visualizer, you can add the data source configuration for a selected Oracle CEP server.

To add a data source configuration:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the DataSource tab.

The DataSource tab appears as Figure 13-6 shows.

Figure 13-6 DataSource Tab

Click Add.

The New Datasource dialog appears as Figure 13-7 shows. There are three accordion tabs:

Data Source: use this tab to identify the data source and specify whether or not to use a global transaction protocol.

Global Tx Protocol: use this tab to specify connection properties and whether or not to use XA.

Connection Pool: use this tab to specify connection pool properties.

Click the Data Source tab.

The DataSource tab appears as Figure 13-7 shows.

Figure 13-7 New Datasource: Data Source Tab

Configure the DataSource tab as Table 13-4 describes.

Table 13-4 New Datasource: Data Source Parameters

Parameter
Description

Name

The name for this data source configuration.

JNDI Name

JNDI path to where this data source will be bound. This is the name your Oracle CEP application uses to look up the data source in JNDI.

Global Tx Protocol

Select the protocol for Oracle CEP to use for the transaction branch when processing a global transaction:

OnePhaseCommit (Default)

TwoPhaseCommit

LoggingLastResource

EmulateTwoPhaseCommit

None

Click the Global Tx Protocol tab.

The Global Tx Protocol tab appears as Figure 13-8 shows.

Figure 13-8 New Datasource: Global Tx Protocol Tab

Configure the Global Tx Protocol tab as Table 13-5 describes.

Table 13-5 New Datasource: Global Tx Protocol Parameters

Parameter
Description

Database Type

Select the type of JDBC driver to use:

Derby

Oracle

SQL Server 2005

Other

URL

Specify the database connection URL appropriate for your database. This URL includes the name of the database, the host and port of the computer on which the database server is running, and so on. Oracle CEP populates a default URL for database types it provides.

Driver Name

Specify the name of the driver for the selected database type. Oracle CEP automatically populates the driver name for types it provides.

User Name

Specify database user account name that you want to use for each connection in the data source.

Password

Specify database user password that you want to use for each connection in the data source

Use XA

Specify whether or not to use distributed transactions:

true: enable distributed transactions.

false: disable distributed transactions.

Click the Connection Pool tab.

The Connection Pool tab appears as Figure 13-9 shows.

Figure 13-9 New Datasource: Connection Pool Tab

Configure the Connection Pool tab as Table 13-6 describes.

Table 13-6 New Datasource: Connection Pool Parameters

Parameter
Description

Initial Capacity

Specify the number of physical connections to create when creating the connection pool.

Max Capacity

Specify the maximum number of physical connections that this connection pool can contain.

Capacity Increment

Specify how many connections to add when all the connections in the connection pool are in use and the connection pool receives a new connection request.

Test

Enter the name of a small table to use in a query if you want to test the database connection before handing it to the requesting application. The standard query is select 1 from table_name. If you prefer to use a different query as a connection test, enter SQL followed by a space and the SQL code you want to use to test database connections.

Click Save.

The new datasource is added to the Oracle CEP server configuration.

14 Managing HTTP Publish-Subscribe Servers

This chapter describes how you can use Oracle CEP Visualizer to view, add, or delete HTTP publish-subscribe server channels for use with Oracle CEP.

Section 14.1, "Viewing HTTP Publish-Subscribe Servers"

Section 14.2, "Adding or Deleting an HTTP Publish-Subscribe Server"

For more information, see:

Section 9.5, "HTTP Publish-Subscribe Server Management"

Section 15.1, "Configuring the Event Inspector Service HTTP Pub-Sub Server"

Chapter 24, "Managing HTTP Publish-Subscribe Server Security"

14.1 Viewing HTTP Publish-Subscribe Servers

You can view an existing HTTP publish-subscribe server using the Oracle CEP Visualizer.

14.1.1 How to View HTTP Publish-Subscribe Server Channels

Using the Oracle CEP Visualizer, you can view the HTTP publish-subscribe server channels currently open on the Oracle CEP server, including:

Static: those channels configured in the Oracle CEP server config.xml and used by Oracle CEP Visualizer itself.

Dynamic: those channels that are not configured in the Oracle CEP server config.xml but created dynamically when the Oracle CEP sever is running. You can view statistics for dynamic channels, including the number of messages sent to this channel and the number of subscribers. Dynamic channel configuration is read-only.

User-defined: those channels that you create in your own Oracle CEP applications. These channels may be either static or dynamic.

Note:

When one application (application-1) advertises a channel that a second application (application-2) subscribes to and uses as a foreign stage, you cannot view the details of the advertised channel from application-2. To view the details of this channel, you must do so from application-1.

To view HTTP publish-subscribe server channels:

Be sure you log on to Oracle CEP Visualizer using an administration user.

For more information, see:

"Configuring Security for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

Section 2.1, "Starting the Oracle CEP Visualizer"

In the left pane, click the Domain > Server > Services > Http Pub/Sub Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

A table appears in the right pane with the list of HTTP pub-sub servers configured for Oracle CEP.

In the right pane, double-click the name of the HTTP pub-sub server in the table. The default server is called pubsub.

The HTTP publish-subscribe server properties dialog appears as Figure 14-1 shows.

Figure 14-1 HTTP Publish-Subscribe Server Channel List

All active channels are shown in the Channels table. The Status column indicates the type of channel: static, dynamic, or user-defined.

14.2 Adding or Deleting an HTTP Publish-Subscribe Server

This section describes:

Section 14.1.1, "How to View HTTP Publish-Subscribe Server Channels"

Section 14.2.2, "How to Delete an HTTP Publish-Subscribe Server Channel"

14.2.1 How to Add an HTTP Publish-Subscribe Server Channel

Using the Oracle CEP Visualizer, you can add an HTTP publish-subscribe server channel.

To add an HTTP publish-subscribe server channel:

Be sure you log on to Oracle CEP Visualizer using an administration user.

For more information, see:

"Configuring Security for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

Section 2.1, "Starting the Oracle CEP Visualizer"

In the left pane, click the Domain > Server > Services > Http Pub/Sub Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

A table appears in the right pane with the list of HTTP pub-sub servers configured for Oracle CEP.

In the right pane, double-click the name of the HTTP pub-sub server in the table. The default server is called pubsub.

Click Add Channel.

In the working area towards the bottom of the right pane, enter the name of the new channel in the Channel Pattern text box.

The channel must start with a /, such as /mychannel.

If you have security enabled, select the security roles that are allowed to publish and subscribe to the channel.

Select more than one by holding down the Ctrl key.

Click Save.

The new channel appears in the Channels table at the top right of the pane.

14.2.2 How to Delete an HTTP Publish-Subscribe Server Channel

Using the Oracle CEP Visualizer, you can add an HTTP publish-subscribe server channel.

To delete an HTTP publish-subscribe server channel:

Be sure you log on to Oracle CEP Visualizer using an administration user.

For more information, see:

"Configuring Security for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

Section 2.1, "Starting the Oracle CEP Visualizer"

In the left pane, click the Domain > Server > Services > Http Pub/Sub server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

A table appears in the right pane with the list of HTTP pub-sub servers configured for Oracle CEP.

In the right pane, click the name of the HTTP pub-sub server in the table. The default server is called pubsub.

In the Channels table, click the name of the channel you want to delete.

Click Delete Channel at the bottom of the pane.

15 Managing the Event Inspector Service

This chapter describes how you can use Oracle CEP Visualizer to specify the HTTP publish-subscribe server used for the event inspector.

Section 15.1, "Configuring the Event Inspector Service HTTP Pub-Sub Server"

For more information, see Section 9.9, "Event Inspector Service Management".

15.1 Configuring the Event Inspector Service HTTP Pub-Sub Server

You can configure the event inspector service HTTP pub-sub server using the Oracle CEP Visualizer.

15.1.1 How to Configure the Event Inspector Service HTTP Pub-Sub Server

Using the Oracle CEP Visualizer, you can configure the HTTP pub-sub server that the event inspector service uses on a selected Oracle CEP server.

To configure the Event Inspector service HTTP pub-sub server:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the Event Inspector tab.

The Event Inspector tab appears as Figure 15-1 shows.

Figure 15-1 Event Inspector Tab

Click Edit.

Edit the dialog as Table 15-1 describes.

Table 15-1 Event Inspector Options

Attribute
Description

Pubsub Server Name

Specify the name of the local HTTP pub-sub server that the Event Inspector service will use.

Pubsub Server URL

Specify the URL of the remote HTTP pub-sub server that the Event Inspector service will use. The URL should be in the form:

http://HOST:PORT/PATH

Where:

HOST: is the host name or IP address of the remote Oracle CEP server.

PORT: the remote Oracle CEP server netio port as defined in the remote Oracle CEP server config.xml file. Default: 9002.

PATH: the value of the http-pubsub element path child element as defined in the remote Oracle CEP server config.xml file.

For example:

http://remotehost:9002/pubsub

Click the Save button to commit your changes.

16 Managing the Event Type Repository

This chapter describes how you can use Oracle CEP Visualizer to view properties for an event available through the event repository.

Section 16.1, "Viewing the Event Type Repository"

Section 16.2, "Configuring the Event Type Repository"

For more information, see Section 9.6, "Event Type Repository Management".

16.1 Viewing the Event Type Repository

You can view the event type repository using the Oracle CEP Visualizer.

16.1.1 How to View the Event Type Repository

Using the Oracle CEP Visualizer, you can view the event type repository.

To view the event type repository:

In the left pane, click Domain > Server > Services > Event Type Repository, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

The right pane displays the Event Name table that lists all the event types used by the applications of the server.

In the right pane, click the name of an event in the Event Name table. The text box at the bottom displays the properties of the event type. For example, a simple Name event type that has three properties, first and last which are Strings and age which is an integer, might look like:

{first=java.lang.String, last=java.lang.String, age=int}

16.2 Configuring the Event Type Repository

You can only view the event type repository, along with the its event types, configured for an Oracle CEP server using Oracle CEP Visualizer.

For details, see "Creating Oracle CEP Event Types" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

17 Managing the Persistent Event Store

This chapter describes how you can use Oracle CEP Visualizer to view properties of a persistent event store in use by Oracle CEP.

Section 17.1, "Viewing the Persistent Event Store"

Section 17.2, "Configuring the Persistent Event Store"

For more information, see Section 9.7, "Persistent Event Store Management".

17.1 Viewing the Persistent Event Store

You can view the persistent event store using the Oracle CEP Visualizer.

17.1.1 How to View the Persistent Event Store

Using the Oracle CEP Visualizer, you can view the persistent event store.

To view the persistent event store:

In the left pane, click Domain > Server > Services > Event Repository, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

The Event Repository panel appears as Figure 17-1 shows. Table 17-1 describes the options in this panel.

Figure 17-1 Event Repository Panel

Table 17-1 Event Repository Panel Attributes

Attribute
Description

Provider Name

The name of the persistent event store provider.

Default: default-provider.

Initial Timeout

The data source timeout value.

Data Source Name

Displays the JDBC data source associated with the provider.

17.2 Configuring the Persistent Event Store

You can only view the event store configured for an Oracle CEP server using Oracle CEP Visualizer. To change the configuration, you must manually update the server's config.xml file.

For details, see "Configuring an Event Store for Oracle CEP Server" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

18 Managing Multi-Server Domains

This chapter describes how you can use Oracle CEP Visualizer to manage aspects of a multi-server domain (or cluster), including viewing native and Coherence cluster membership and topology diagrams, as well as cache information.

Section 18.1, "Managing Cluster Groups and Topologies"

Section 18.2, "Managing Oracle Coherence"

Section 18.3, "Managing the Cluster Topology Diagram"

For more information, see:

Section 9.8, "Multi-Server Domain Management"

Section 5.1.2, "How to Deploy an Application in a Multi-Server Domain"

18.1 Managing Cluster Groups and Topologies

This section describes:

Section 18.1.1, "How to View Cluster Group Membership"

Section 18.1.2, "How to View all Cluster Topologies"

Section 18.1.3, "How to View Oracle CEP High Availability Cluster Topologies"

18.1.1 How to View Cluster Group Membership

You can view the default and user-defined cluster groups, what servers belong to those groups, and what applications are deployed to those groups.

By default, there is a group for each server with the same name as the server and a group named AllDomainMembers which represents all the servers in the domain. In addition, you can define custom groups when you configure your cluster.

You may deploy an application to a cluster group or to an individual server. When you deploy to a cluster group, the application belongs to the group, not the individual servers in the group. When you deploy to an individual server, the application belongs to the server's own group.

For more information, see

Section 5.1.2, "How to Deploy an Application in a Multi-Server Domain"

"Groups" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

To view cluster group membership:

In the left pane, click the Domain node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Cluster Groups/Server tab.

The Cluster Groups/Server tab appears as Figure 18-1 shows.

Figure 18-1 Cluster Groups/Server Tab

Use the Cluster Groups/Server tab to examine the server and application contents of various cluster groups.

For example:

Group testgroup contains two servers (WLEvServer-1 and WLEvServer-2) and one application (helloworld) as Figure 18-1 shows.

Group WLEvServer-1 contains one server (WLEvServer-1) and no applications. The helloworld application listed under its Applications node belongs to group testgroup, not to server WLEvServer-1.

Group WLEvServer-2 contains one server (WLEvServer-2) and one application (fx). The fx application was deployed to server WLEvServer-2. The helloworld application listed under its Applications node belongs to group testgroup, not to server WLEvServer-2.

18.1.2 How to View all Cluster Topologies

Using Oracle CEP Visualizer, you can view all cluster topologies regardless of cluster implementation. You can also view cluster group properties and server instance properties.

If you deploy an Oracle CEP high availability application, you can view the Oracle CEP high availability topology. For more information, see Section 18.1.3, "How to View Oracle CEP High Availability Cluster Topologies".

If you are using Oracle Coherence for clustering, you can view Oracle Coherence topology. For more information, see Section 18.2.1, "How to View Oracle Coherence Cluster Topologies".

To view all cluster topologies:

In the left pane, click the Domain node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Cluster tab.

In the right pane, click the Topology tab.

The Topology tab appears as Figure 18-2 shows.

Figure 18-2 Cluster Topology Tab

This tab shows all cluster groups regardless of the cluster implementation.

Within a cluster group, the primary server is identified by the icon that Figure 18-3 shows. In Figure 18-2, the primary server is CEPServer1.

Figure 18-3 Primary Server

For information on the various tools along the top of the topology canvas, see Section 18.3, "Managing the Cluster Topology Diagram".

To view the properties for a given group, click on the group in the Group List.

To view the properties for a given server instance, click on the server instance in the Group List.

To view details on a given server instance, click the Group Member tab and select the server instance as Figure 18-4 shows.

Figure 18-4 Group Member Tab

Use the Group Member tab to customize the group table:

To change the order of columns, click on the column name in the cache chart and drag left or right.

To change the sort order of a column, click the triangle to the right of the column name in the cache chart.

18.1.3 How to View Oracle CEP High Availability Cluster Topologies

Using Oracle CEP Visualizer, you can view an Oracle high availability cluster topology. You can also view cluster group properties and server instance properties.

For more information, see "Understanding High Availability" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse.

To view Oracle CEP high availability cluster topologies:

In the left pane, click the Domain node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Cluster tab.

In the right pane, click the Topology tab.

For an Oracle CEP high availability application, you can use the Topology tab to:

Visualize a high-availability configuration.

See Section 18.1.3.1, "Visualizing an Oracle High Availability Configuration"

Visualizer a high-availability and scalability configuration.

See Section 18.1.3.2, "Visualizing an Oracle High Availability and Scalability Configuration".

For information on the various tools along the top of the topology canvas, see Section 18.3, "Managing the Cluster Topology Diagram".

To view the properties for a given group, click on the group in the Group List.

To view the properties for a given server instance, click on the server instance in the Group List.

To view details on a given server instance, click the Group Member tab and select the group and server instance as Figure 18-5 shows.

Figure 18-5 Group Member Tab

Use the Group Member tab to customize the group table:

To change the order of columns, click on the column name in the cache chart and drag left or right.

To change the sort order of a column, click the triangle to the right of the column name in the cache chart.

18.1.3.1 Visualizing an Oracle High Availability Configuration

For an Oracle CEP high availability application, the Topology tab shows the notification group nested within the deployment group.

In Figure 18-6, the deployment group is MyDeploymentGroup and the notification group is ActiveActiveGroupBean_group1.

Figure 18-6 Cluster Topology Tab: Oracle CEP High Availability

The primary server is identified by the icon that Figure 18-7 shows. In Figure 18-6, the primary server is CEPServer2.

Figure 18-7 Primary Server

The stream data source inputs to both primary and secondary servers but only the primary server outputs events. If CEPServer2 goes down, an Oracle high availability failover occurs and CEPServer1 resumes outputting events as the new primary for ActiveActiveGroupBean_group1. When CEPServer2 is brought back online, it rejoins ActiveActiveGroupBean_group1 as a secondary server.

For information on the various tools along the top of the topology canvas, see Section 18.3, "Managing the Cluster Topology Diagram".

For more information, see:

"Understanding High Availability" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

"Deployment Group and Notification Group" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

18.1.3.2 Visualizing an Oracle High Availability and Scalability Configuration

If your Oracle CEP high availability application combines high availability and scalability, then the Topology tab shows notification groups nested within the deployment group.

In Figure 18-8, the deployment group is MyDeploymentGroup and the notification groups are ActiveActiveGroupBean_group1 and ActiveActiveGroupBean_group2.

Figure 18-8 Cluster Topology Tab: Oracle CEP High Availability and Scalability

The primary server is identified by the icon that Figure 18-9 shows. In Figure 18-8, the primary server of notification group ActiveActiveGroupBean_group1 is CEPServer1 and the primary server of notification group ActiveActiveGroupBean_group2 is CEPServer3.

Figure 18-9 Primary Server

The stream data source inputs to both primary and secondary servers in each notification group but only the primary server in each notification group outputs events. The stream data source is partitioned (by JMS selector) so that each notification group processes a different subset of the input data. The Oracle CEP Visualizer indicates this with a different colored line for each notification group. For example, ActiveActiveGroupBean_group1 may process events with accountID <= 500 and ActiveActiveGroupBean_group2 may process events with accountID > 500. Both CEPServer1 and CEPServer2 process events with accountID <= 500 in parallel and CEPServer3 and CEPServer4 process events with accountID > 500 in parallel. If CEPServer1 goes down, an Oracle high availability failover occurs and CEPServer2 resumes outputting events as the new primary for ActiveActiveGroupBean_group1. When CEPServer1 is brought back online, it rejoins ActiveActiveGroupBean_group1 as a secondary server.

For information on the various tools along the top of the topology canvas, see Section 18.3, "Managing the Cluster Topology Diagram".

For more information, see:

"High Availability and Scalability" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

"Deployment Group and Notification Group" in the Oracle Fusion Middleware Developer's Guide for Oracle Complex Event Processing for Eclipse

18.2 Managing Oracle Coherence

This section includes the following topics:

Section 18.2.1, "How to View Oracle Coherence Cluster Topologies"

Section 18.2.2, "How to Monitor Nodes in an Oracle Coherence Cluster"

Section 18.2.3, "How to Monitor an Oracle Coherence Cache"

Section 18.2.4, "How to Tune Oracle Coherence"

18.2.1 How to View Oracle Coherence Cluster Topologies

Using Oracle CEP Visualizer, if you are using Oracle Coherence clustering, you can view Oracle Coherence cluster topologies, cluster group properties, and server instance properties.

To view all clustering topologies regardless of clustering implementation, see Section 18.1.2, "How to View all Cluster Topologies".

To view Oracle Coherence cluster topologies:

In the left pane, click the Domain node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Coherence tab.

In the right pane, click the Topology tab.

The Topology tab appears as Figure 18-10 shows.

Figure 18-10 Oracle Coherence Cluster Topology Tab

This tab shows all cluster groups that the Oracle Coherence clustering implementation manages.

For information on the various tools along the top of the topology canvas, see Section 18.3, "Managing the Cluster Topology Diagram".

To view the properties for a given group, click on the group in the Group List.

To view the properties for a given server instance, click on the server instance in the Group List.

18.2.2 How to Monitor Nodes in an Oracle Coherence Cluster

Using Oracle CEP Visualizer, you can compare a combination of properties for any and all nodes in an Oracle Coherence cluster. For a selected node in an Oracle Coherence cluster, you can view a select list of properties.

Once you have determined the root cause of a problem, you can tune Oracle Coherence parameters to correct the problem. For more information, see Section 18.2.4, "How to Tune Oracle Coherence".

To monitor nodes in an Oracle Coherence cluster:

In the left pane, click the Domain node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Coherence tab.

In the right pane, click the Multi-Nodes Monitor tab.

The Multi-Nodes Monitor tab appears as Figure 18-1 shows.

Figure 18-11 Multi-Nodes Monitor Tab

Use the Multi-Nodes Monitor tab to customize the group table:

To change the order of columns, click on the column name in the cache chart and drag left or right.

To change the sort order of a column, click the triangle to the right of the column name in the cache chart.

Use the Multi-Nodes Monitor tab to compare any combination of the properties that Table 18-1 lists for any nodes in an Oracle Coherence cluster:

Expand a group and check one or more nodes.

Drag a property from the Drag Property to Watch area to either graph to watch that property or, select a property and click Add to Left or Add to Right.

You may specify at most one property per graph.

A line is drawn for each selected node. The legend below the graph distinguishes graph data for each selected node by color.

To watch a different property, drag a new property and drop it onto the graph or, select a new property and click Add to Left or Add to Right.

To change the scale of a graph, drag the slider next to the vertical axis.

Table 18-1 Properties You Can Watch on the Multi-Nodes Monitor Tab

Property
Description

Memory Available

The total amount of free memory (in MB) for the selected node.

Memory Max

The total amount of memory available (in MB) for the selected node.

Packets Sent

The total number of Oracle Coherence packets sent by the selected node.

Packets Received

The total number of Oracle Coherence packets received by the selected node.

Buffer Receive Size

The total number of Oracle Coherence received packets that the selected node can buffer.

Buffer Publish Size

The total number of Oracle Coherence published packets that the selected node can buffer.

To view more details for a particular node, click the Node Detail View tab.

The Node Detail View tab appears as Figure 18-12 shows.

Figure 18-12 Node Detail View Tab

Use the Node Detail View tab to compare the properties that Table 18-2 lists for a selected node:

Select a node from the Nodes pull-down menu.

The properties for the selected node are shown in the Nodes Properties list.

A line is drawn for the selected node.

To change the scale of a graph, drag the slider next to the vertical axis.

Table 18-2 Properties You Can Watch on the Node Detail View Tab

Property
Description

Memory Available

The total amount of free memory (in MB) for the selected node.

Memory Max

The total amount of memory available (in MB) for the selected node.

Packets Sent

The total number of Oracle Coherence packets sent by the selected node.

Packets Received

The total number of Oracle Coherence packets received by the selected node.

18.2.3 How to Monitor an Oracle Coherence Cache

Using Oracle CEP Visualizer, you can monitor a wide variety of Oracle Coherence cache parameters and graphically compare parameter values to locate and diagnose performance and operational problems.

Once you have determined the root cause of a problem, you can tune Oracle Coherence parameters to correct the problem. For more information, see Section 18.2.4, "How to Tune Oracle Coherence".

To monitor an Oracle Coherence Cache:

In the left pane, click the Domain node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Coherence tab.

In the right pane, click the Cache Chart tab.

The Multi-Nodes Monitor tab appears as Figure 18-1 shows.

Figure 18-13 Cache Chart Tab

Use the Cache Chart tab to view any combination of the columns that Table 18-3 lists for one or more selected caches:

Check one or more caches in the cache chart.

To add a column to the cache chart, check the column in the Columns list.

To remove a column from the cache chart, uncheck the column in the Columns list.

To change the order of columns, click on the column name in the cache chart and drag left or right.

To change the sort order of a column, click the triangle to the right of the column name in the cache chart.

Table 18-3 Columns and Properties for the Cache Chart Tab

Property
Description

Cache Name

The name of the cache.

# of Objects

The total number of objects in the selected cache.

Cache Hits

The total number times an Oracle Coherence cache client has accessed the selected cache.

Cache Misses

The total number times an Oracle Coherence cache client has accessed the selected cache and failed to find the desired object.

Cache Prunes

The total number times Oracle Coherence has reached its maximum size and had to delete some objects to return to a configured smaller size for the selected cache.

Store Writes

The total number of times Oracle Coherence has written to the selected cache's backing store.

Store Reads

The total number of times Oracle Coherence has read from the selected cache's backing store.

Node Id

The node identifier for the selected cache.

Store Failures

The total number of times the selected cache's backing store has failed to service an Oracle Coherence Store Write or Store Read.

Average Hit Millis

The average time (in milliseconds) taken by Oracle Coherence to find an object in the selected cache.

Average Get Millis

The average time (in milliseconds) taken by Oracle Coherence to retrieve an object from the selected cache.

Average Miss Millis

The average time (in milliseconds) taken by Oracle Coherence to determine that an object does not exist in the selected cache.

Average Put Millis

The average time (in milliseconds) taken by Oracle Coherence to add a new object to the selected cache.

Cache Hits Millis

The total time (in milliseconds) taken by Oracle Coherence to find an object in the selected cache.

Cache Misses Millis

The total time (in milliseconds) taken by Oracle Coherence to determine that an object does not exist in the selected cache.

Cache Prunes Millis

The total time (in milliseconds) taken by Oracle Coherence to delete some objects from the selected cache to return to a configured smaller size after having reached its maximum size.

Store Read Millis

The total time (in milliseconds) taken by Oracle Coherence to read from the selected cache's backing store.

Store Write Millis

The total time (in milliseconds) taken by Oracle Coherence to write to the selected cache's backing store.

Total Gets Millis

The total time (in milliseconds) taken by Oracle Coherence to retrieve objects from the selected cache.

Total Puts Millis

The total time (in milliseconds) taken by Oracle Coherence to add new objects to the selected cache.

Use the Cache Chart tab to compare any combination of the properties that Table 18-3 lists for one or more selected caches:

Check one or more caches in the cache chart.

Drag a property from the Drag Property to Watch area to either graph to watch that property or, select the property and click Add to Left or Add to Right.

You may specify at most one property per graph.

A line is drawn for each selected cache. The legend below the graph distinguishes graph data for each selected cache by color.

To watch a different property, drag the new property and drop it onto the graph or, select a different property and click Add to Left or Add to Right.

To change the scale of a graph, drag the slider next to the vertical axis.

18.2.4 How to Tune Oracle Coherence

Using Oracle CEP Visualizer, you can view and modify a variety of Oracle Coherence parameters to fine tune Oracle Coherence performance.

Note:

Not all Oracle Coherence parameters can be modified. For more information, refer to your Oracle Coherence documentation.

To determine the root cause of a problem, you can monitor Oracle Coherence parameters. For more information, see:

Section 18.2.2, "How to Monitor Nodes in an Oracle Coherence Cluster"

Section 18.2.3, "How to Monitor an Oracle Coherence Cache".

To tune Oracle Coherence:

In the left pane, click the Domain node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Coherence tab.

In the right pane, click the Tuning tab.

The Tuning tab appears as Figure 18-14 shows.

Figure 18-14 Tuning Tab: Cache Tuning

To tune parameters and invoke operations for caches, select the Cache Tuning accordion tab and select a cache as Figure 18-14 shows.

Table 18-4 lists the properties you can view and tune for the selected cache. All properties are based on Oracle Coherence http://download.oracle.com/otn_hosted_doc/coherence/340/com/tangosol/net/management/Registry.html.

Table 18-4 Cache Tuning: Properties

Property
Description

Cache Name

The name of the selected cache (read-only).

Service

The service associated with this cache (read-only).

Batch Factor

The BatchFactor attribute is used to calculate the `soft-ripe` time for write-behind queue entries. A queue entry is considered to be `ripe` for a write operation if it has been in the write-behind queue for no less than the QueueDelay interval. The `soft-ripe` time is the point in time prior to the actual `ripe` time after which an entry will be included in a batched asynchronous write operation to the CacheStore (along with all other `ripe` and `soft-ripe` entries). This attribute is only applicable if asynchronous writes are enabled (that is, the value of the QueueDelay attribute is greater than zero) and the CacheStore implements the storeAll() method. The value of the element is expressed as a percentage of the QueueDelay interval.

Valid values are doubles in the interval [0.0, 1.0]..

Queue Delay (Milliseconds)

The number of seconds that an entry added to a write-behind queue will sit in the queue before being stored via a CacheStore. Applicable only for WRITE-BEHIND persistence type.

Expiry Delay (Milliseconds)

The number of milliseconds that the MBeanServer will keep a remote model snapshot before refreshing.

Flush Delay (Milliseconds)

The number of milliseconds between cache flushes. Value of zero indicates that the cache will never flush.

Refresh Factor

The RefreshFactor attribute is used to calculate the `soft-expiration` time for cache entries. Soft-expiration is the point in time prior to the actual expiration after which any access request for an entry will schedule an asynchronous load request for the entry. This attribute is only applicable for a ReadWriteBackingMap which has an internal LocalCache with scheduled automatic expiration. The value of this element is expressed as a percentage of the internal LocalCache expiration interval.

Valid values are doubles in the interval[0.0, 1.0]. If zero, refresh-ahead scheduling will be disabled.

Requeue Threshold

The maximum size of the write-behind queue for which failed CacheStore write operations are requeued. If zero, the write-behind requeueing will be disabled. Applicable only for WRITE-BEHIND persistence type.

High Units

The limit of the cache size measured in units. The cache will prune itself automatically once it reaches its maximum unit level. This is often referred to as the `high water mark` of the cache.

Low Units

The number of units to which the cache will shrink when it prunes. This is often referred to as a `low water mark` of the cache.

To apply changes, click the Save button.

To discard changes, click the Cancel button.

Table 18-5 lists the operations you can invoke for the selected cache.

Table 18-5 Cache Tuning: Operations

Operation
Description

Reset Statistics

Reset the cache statistics.

To tune parameters and invoke operations for cluster nodes, select the Node Tuning accordion tab and select a node as Figure 18-15 shows.

Figure 18-15 Tuning Tab: Node Tuning

Table 18-4 lists the properties you can view and tune for the selected cache. All properties are based on Oracle Coherence http://download.oracle.com/otn_hosted_doc/coherence/340/com/tangosol/net/management/Registry.html.

Table 18-6 Node Tuning: Properties

Property
Description

Node Name

The name of the selected node (read-only).

Buffer Publish Size

The buffer size of the unicast datagram socket used by the Publisher, measured in the number of packets.

Changing this value at runtime is an inherently unsafe operation that will pause all network communications and may result in the termination of all cluster services.

Buffer Receive Size

The buffer size of the unicast datagram socket used by the Receiver, measured in the number of packets.

Changing this value at runtime is an inherently unsafe operation that will pause all network communications and may result in the termination of all cluster services.

Burst Count

The maximum number of packets to send without pausing. Anything less than one (for example, zero) means no limit.

Burst Delay (Milliseconds)

The number of milliseconds to pause between bursts. Anything less than one (for example, zero) is treated as one millisecond.

Logging Level

Specifies which logged messages will be output to the log destination.

Valid values are:

0 only output without a logging severity level specified will be logged

1 all the above plus errors

2 all the above plus warnings

3 all the above plus informational messages

4..9 all the above plus internal debugging messages (the higher the number, the more the messages)

-1 no messages

Logging Format

Specifies how messages will be formatted before being passed to the log destination.

The value of the message-format element is static text with the following replaceable parameters:

{date} the date/time format (to a millisecond) at which the message was logged

{version} the Oracle Coherence exact version and build details

{level} the logging severity level of the message

{thread} the thread name that logged the message

{member} the cluster member id (if the cluster is currently running)

{text} the text of the message

Logging Limit

The maximum number of characters that the logger daemon will process from the message queue before discarding all remaining messages in the queue. Valid values are integers in the range [0...]. Zero implies no limit.

Multicast Threshold

The percentage (0 to 100) of the servers in the cluster that a packet will be sent to, above which the packet will be multicasted and below which it will be unicasted.

Resend Delay (Milliseconds)

The minimum number of milliseconds that a packet will remain queued in the Publisher`s re-send queue before it is resent to the recipient(s) if the packet has not been acknowledged. Setting this value too low can overflow the network with unnecessary repetitions. Setting the value too high can increase the overall latency by delaying the re-sends of dropped packets. Additionally, change of this value may need to be accompanied by a change in SendAckDelay value.

Send Ack Delay (Milliseconds)

The minimum number of milliseconds between the queueing of an Ack packet and the sending of the same. This value should be not more then a half of the ResendDelay value.

Traffic Jam Count

The maximum total number of packets in the send and resend queues that forces the publisher to pause client threads. Zero means no limit.

Traffic Jam Delay (Milliseconds)

The number of milliseconds to pause client threads when a traffic jam condition has been reached. Anything less than one (for example, zero) is treated as one millisecond.

To apply changes, click the Save button.

To discard changes, click the Cancel button.

Table 18-5 lists the operations you can invoke for the selected node.

Table 18-7 Node Tuning: Operations

Operation
Description

Reset Statistics

Reset the cluster node statistics.

To tune parameters and invoke operations for nodes, select the Node Tuning accordion tab and select a node as Figure 18-15 shows.

Figure 18-16 Tuning Tab: Service Tuning

Table 18-4 the properties you can view and tune for the selected cache. All properties are based on Oracle Coherence http://download.oracle.com/otn_hosted_doc/coherence/340/com/tangosol/net/management/Registry.html.

Table 18-8 Service Tuning: Properties

Property
Description

Service Name

The name of the selected service (read-only).

Request Timeout (Millis)

The default timeout value in milliseconds for requests that can be timed-out (for example, implement the com.tangosol.net.PriorityTask interface), but do not explicitly specify the request timeout value.

Task Hung Threshold (Millis)

The amount of time in milliseconds that a task can execute before it is considered hung. Note that a posted task that has not yet started is never considered as hung.

Task Timeout (Millis)

The default timeout value in milliseconds for tasks that can be timed-out (for example, implement the com.tangosol.net.PriorityTask interface), but do not explicitly specify the task execution timeout value.

Thread Count

The number of threads in the service thread pool.

To apply changes, click the Save button.

To discard changes, click the Cancel button.

Table 18-5 lists the operations you can invoke for the selected service.

Table 18-9 Service Tuning: Operations

Operation
Description

resetStatistics

Reset the service statistics.

18.3 Managing the Cluster Topology Diagram

This section describes the various tools along the top of the Topology canvas as Figure 18-17 shows.

Figure 18-17 Cluster Topology Tools

You use these tools to manage the topology diagram of your cluster topology.

18.3.1 Choose Layout

Use the Choose Layout pull-down menu to select alternate ways of distributing cluster groups. You can choose any of:

top-down

organic

hierarchic

orthogonal

18.3.2 Show All Groups

Check the Show All Groups option to show all the cluster topology groups listed on the Cluster Groups/Server tab including the AllDomainMembers group and the per-server groups.

This option is unchecked by default to reduce clutter on the Cluster Topology tab and to allow you to focus on the most important groups.

18.3.3 Zoom

Use the Zoom slider to increase or decrease the zoom level. This is an alternative to using the Zoom In and Zoom Out buttons (see Section 18.3.5, "Zoom In and Zoom Out").

18.3.4 Fit Content

Click the Fit Content button to adjust the zoom level automatically to make all of the diagram visible in the current browser window.

18.3.5 Zoom In and Zoom Out

Click the Zoom In and Zoom Out buttons to change the zoom level. This is an alternative to using the Zoom slider (see Section 18.3.3, "Zoom").

18.3.6 Toggle Properties

Click the Toggle Properties button to alternately hide and show the properties table on the right.

19 Managing Oracle CEP Server Logs

This chapter describes how you can use Oracle CEP Visualizer to view and configure the Oracle CEP server logging service and component loggers.

Section 19.1, "Configuring Logs"

Section 19.2, "Viewing Logs"

For more information, see Section 9.11, "Log Management".

19.1 Configuring Logs

This section describes:

Section 19.1.1, "How to Configure the Oracle CEP Server Logging Service"

Section 19.1.2, "How to Configure a Component Logger"

19.1.1 How to Configure the Oracle CEP Server Logging Service

Using the Oracle CEP Visualizer, you can configure the logging system of a selected Oracle CEP server. By default, this logging configuration applies to all components.

To configure component-specific logging options, see Section 19.1.2, "How to Configure a Component Logger".

To configure the Oracle CEP server logging service:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the Logging tab.

Click the Logging Services tab.

The Logging Services tab appears as Figure 19-1 shows.

Figure 19-1 Logging Services Tab

Click Edit.

Edit the dialog as Table 19-1 describes.

Table 19-1 Logging Services Options

Attribute
Description

Logging Service Name

Specify the name of the logging service as the Oracle CEP server config.xml file specifies.

Logger Severity

Specify the default log severity at which Oracle CEP server logs messages.

Limited By Number Of Files

Specify whether or not to keep old log files indefinitely:

true: keep only the last 7 log files.

false: keep all log files.

Rotation Type

Specify when Oracle CEP server should close the existing log file and open a new one:

Size: Oracle CEP server closes the existing log file when it reaches the size (in KB) you enter in the Rotation Size field.

Time: Oracle CEP server closes the existing log file at the time you enter in the numeric entry field below the Rotation Type pull-down menu in k:mm format, where k is the hour specified in 24 hour notation and mm is the minutes. Default-Value: 00:00.

None: Oracle CEP server never closes the existing log file and allows it to grow to an unlimited size.

Rotation Size

When you specify Rotation Type as Size, enter the maximum log file size in KB.

Base Log File Name

The name of the base log file.

Default: server.log.

Rotate Log On Startup

Specify whether or not Oracle CEP server closes the existing log file and creates a new one each time the Oracle CEP server starts up:

true: Oracle CEP server closes the existing log file and creates a new one each time the Oracle CEP server starts up.

false: Oracle CEP server does not close the existing log file each time the Oracle CEP server starts up.

Log File Severity

Specify the default log file severity. Oracle CEP server (and, by default, all components), log messages at this severity:

Emergency

Alert

Critical

Error

Warning

Notice

Info

Debug

Trace

Click the Save button to commit your changes.

19.1.2 How to Configure a Component Logger

Using the Oracle CEP Visualizer, you can configure the logging properties of a selected component. Table 19-2 lists the components that are configured to log at the Notice log level, by default.

This section describes how:

"To add a component logger:"

"To change the logging level of a component:"

"To delete a component logger:"

To configure logging properties that apply to all components, see Section 19.1.1, "How to Configure the Oracle CEP Server Logging Service".

To add a component logger:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the Logging tab.

Click the Component Log Setting tab.

The Component Log Setting tab appears as Figure 19-2 show.

Figure 19-2 Component Log Setting Tab

Click Add.

Enter the name of the component in the Name field.

You can choose any of the following:

Component name: a component name constant exactly as Table 19-2 lists.

Table 19-2 Logging Component Name Constants

Component Name
Description

Adapters

Applies to log messages from adapter instances running on the Oracle CEP server.

Cache

Applies to log messages from caching systems and cache instances running on the Oracle CEP server.

Channel

Applies to log messages from channels running on the Oracle CEP server.

CQLProcessor

Applies to log messages from Oracle CQL processors running on the Oracle CEP server.

CQLServer

Applies to log messages from the CQLEngine, which is at the core of each CQLProcessor.

CQLServerTrace

Applies to log messages from the CQLEngine, which is at the core of each CQLProcessor

EplProcessor

Applies to log messages from EPL processors running on the Oracle CEP server.

Ede

Applies to log messages from the Event-Driven Environment, the Oracle CEP server event-dispatching infrastructure.

EventTrace

When set to Info or Debug, allows you to trace events as they flow through the EPN for all applications. You can dynamically change the severity of this log key using Oracle CEP Visualizer.

At the Info severity, you see log messages like this (although likely displayed on one line):

<May 26, 2009 5:53:49 PM PDT> <Info> <EventTrace> <BEA-000000>
    <Application [helloworld], Stage [helloworldOutputChannel]
    received insert event>

At the Debug severity, the log messages include details of the event:

<May 26, 2009 6:02:34 PM PDT> <Debug> <EventTrace> <BEA-000000>
    <Application [helloworld], Stage [helloworldOutputChannel]
    received insert event [HelloWorldEvent: HelloWorld - the
    current time is: 6:02:34 PM]>

Lifecycle

Applies to log messages from Oracle CEP server and application lifecycle operations.

Management

Applies to log messages from Oracle CEP server general JMX-related management API operations.

Monitor

Applies to log messages from the Oracle CEP server monitoring service.

Recplay

Applies to log messages from Oracle CEP server event recording and playback operations.

Spring

Applies to log messages from Spring container operations.

Stream

Applies to log messages from stream instances running on the Oracle CEP server.

Application name: the module name of any Oracle CEP server or user-defined application. For example: sample.HelloWorld.

Package name: the name of any Oracle CEP server or user-supplied Java package. For example: com.bea.wlevs.ede.

For more information on Oracle CEP server packages, see the Oracle Fusion Middleware Java API Reference for Oracle Complex Event Processing.

Class name: the fully qualified name of any Oracle CEP server or user-defined class. For example: com.bea.wlevs.cep.core.EPRuntimeImpl.

For more information on Oracle CEP server classes, see the Oracle Fusion Middleware Java API Reference for Oracle Complex Event Processing.

Select the severity level from the Level drop-down menu:

Emergency

Alert

Critical

Error

Warning

Notice

Info

Debug

Trace

Click Save.

The component and the severity level is displayed in the table.

To change the logging level of a component:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the Logging tab.

Click the Component Log Setting tab.

The Component Log Setting tab appears as Figure 19-3 show.

Figure 19-3 Component Log Setting Tab

Select the component entry in the table.

Click Edit.

Select the severity level from the Level drop-down menu:

Emergency

Alert

Critical

Error

Warning

Notice

Info

Debug

Trace

Click Save.

The new severity level is displayed in the table.

To delete a component logger:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the Logging tab.

Click the Component Log Setting tab.

The Component Log Setting tab appears as Figure 19-4 show.

Figure 19-4 Component Log Setting Tab

Select the component entry in the table.

Click Delete.

A confirmation dialog appears as Figure 19-5 shows.

Figure 19-5 Component Log Configuration Delete Confirmation

Click Yes.

The component logger is removed from the table.

19.2 Viewing Logs

This section describes:

Section 19.2.1, "How to Query Logs"

Section 19.2.2, "How to View Console Output"

19.2.1 How to Query Logs

Using the Oracle CEP Visualizer, you can run queries on the logs of a selected Oracle CEP server. The Query Logs feature allows you to view the information in the selected log files.

To query logs:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

Click Services and then click Log Query.

The Log Query screen is displayed, as shown in Figure 19-6.

Figure 19-6 Log Query Screen

Select the following options in the Log Query screen:

LogFile: Select the log file you want to query from the drop-down.

Severity: Select the severity of the log file that you selected in the LogFile drop-down.

MaxCount: Enter the maximum count of rows of log you wish to view for the selected log file.

StartTime: Select the time when the query should start running.

EndTime: Select the time when the query should stop.

Click Start Query.

All the log messages that match your query criteria for the selected log file of the selected Oracle CEP Server are displayed in the Logs pane, as shown in Figure 19-7.

Figure 19-7 Log Query Screen - Logs Displayed

If more messages are returned than can be displayed in the Logs pane, the Previous and Next buttons activate. Click the Previous and Next buttons to page through the messages.

19.2.2 How to View Console Output

Using the Oracle CEP Visualizer, you can view the console output of a selected Oracle CEP server.

To view console output:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

Click Services and then click Console Output.

The Console Output screen is displayed, as shown in Figure 19-8.

Figure 19-8 Sample Console Output for HelloWorld Application

Click the Clean Text button to clear the text in the Console Output window.

Click the Pause button to pause the output of console messages.

Click the Resume button to resume the output of console messages.

Part IV

Security Tasks

Part IV contains the following chapters:

Chapter 20, "Overview of Security Tasks"

Chapter 21, "Managing Users"

Chapter 22, "Managing Groups"

Chapter 23, "Managing Roles"

Chapter 24, "Managing HTTP Publish-Subscribe Server Security"

Chapter 25, "Managing SSL"

20 Overview of Security Tasks

This chapter introduces security tasks you can perform with Oracle CEP Visualizer, including managing users, groups, and roles, as well as managing HTTP publish-subscribe server channel security and SSL.

Section 20.1, "User, Group, and Role Management"

Section 20.2, "HTTP Publish-Subscribe Server Channel Security Management"

Section 20.3, "SSL Management"

For more information, see "Configuring Security for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

20.1 User, Group, and Role Management

Oracle CEP uses role-based authorization control to secure the Oracle CEP Visualizer and the wlevs.Admin command-line utility. There are a variety of default out-of-the-box security groups. You can add users to different groups to give them the different roles.

Administrators who use Oracle CEP Visualizer, wlevs.Admin, or any custom administration application that uses JMX to connect to an Oracle CEP instance use role-based authorization to gain access.

You can also use role-based authorization to control access to the HTTP publish-subscribe server.

There are two types of role:

Application roles: application roles grant users the permission to access various Oracle CQL applications deployed to the Oracle CEP server. You can create application roles and associate them with the task roles that Oracle CEP provides.

By default, administrator users can access any application and non-administration users cannot access any applications. Before a none-administration user can access an application, an administration user must grant the user the associated application role.

Task roles: task roles grant users the permission to perform various tasks with the applications their application role authorizes them to access. Oracle CEP provides the default task roles that Table 20-1 describes.

Users that successfully authenticate themselves when using Oracle CEP Visualizer or wlevs.Admin are assigned roles based on their group membership, and then subsequent access to administrative functions is restricted according to the roles held by the user. Anonymous users (non-authenticated users) will not have any access to the Oracle CEP Visualizer or wlevs.Admin.

When an administrator uses the Configuration Wizard to create a new domain, they enter an administrator user that will be part of the wlevsAdministrators group. By default, this information is stored in a file-based provider filestore. The password is hashed using the SHA-256 algorithm. The default administrator user is named wlevs with password wlevs.

Table 20-1 describes the default Oracle CEP task roles available right after the creation of a new domain, as well as the name of the groups that are assigned to these roles.

Table 20-1 Default Oracle CEP Task Roles and Groups

Task Role
Group
Privileges

Admin

wlevsAdministrators

Has all privileges of all the preceding roles, as well as permission to:

Create users and groups

Configure HTTP publish-subscribe security

Change the system configuration, such as Jetty, work manager, and so on.

ApplicationAdmin

wlevsApplicationAdmins

Has all Operator privileges as well as permission to update the configuration of any deployed application.

BusinessUser

wlevsBusinessUsers

Has all Operator privileges as well as permission to update the Oracle CQL and EPL rules associated with the processor of a deployed application.

Deployer

wlevsDeployers

Has all Operator privileges as well as permission to deploy, undeploy, update, suspend, and resume any deployed application.

Monitor

wlevsMonitors

Has all Operator privileges as well as permission to enable/disable diagnostic functions, such as creating a diagnostic profile and recording events (then playing them back.)

Operator

wlevsOperators

Has read-only access to all server resources, services, and deployed applications.

Once the domain has been created, the administrator can use Oracle CEP Visualizer to create a group and associate it with one or more roles: each role grants access to an application. When you assign a user to a group, the roles you associate with the group give the user the privileges to access those applications.

Using Oracle CEP Visualizer, you can:

Chapter 21, "Managing Users"

Chapter 22, "Managing Groups"

Chapter 23, "Managing Roles"

20.2 HTTP Publish-Subscribe Server Channel Security Management

Oracle CEP provides an HTTP Publish-Subscribe Server (HTTP pub-sub server): a mechanism whereby Web clients subscribe to channels (similar to a topic in JMS) and then publish messages to these channels using asynchronous messages over HTTP and subscribe to these channels to receive messages as they become available.

Using Oracle CEP Visualizer, you can specify which users can access HTTP publish-subscribe server channels.

For more information, see:

Chapter 24, "Managing HTTP Publish-Subscribe Server Security"

"Configuring HTTP Publish-Subscribe for Oracle CEP" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

20.3 SSL Management

Oracle CEP provides one-way Secure Sockets Layer (SSL) to secure network traffic between Oracle CEP Visualizer and Oracle CEP server instances, between the Oracle CEP server instances of a multi-server domain, and between the wlevs.Admin command-line utility and Oracle CEP server instances.

You configure SSL in the Oracle CEP server config.xml file. By default, the Configuration Wizard creates the config.xml file in the ORACLE_CEP_HOME/user_projects/domains/DOMAIN_DIR/servername/config directory, where ORACLE_CEP_HOME refers to the Oracle CEP installation directory (such as d:/oracle_cep), DOMAIN_DIR refers to the domain directory (such as my_domain), and servername refers to the server instance directory (such as server1).

For more information, see:

Chapter 25, "Managing SSL"

"SSL" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing

21 Managing Users

This chapter describes how you can use Oracle CEP Visualizer to create, edit, and delete user accounts, including user passwords.

Section 21.1, "Creating and Editing a User"

Section 21.2, "Deleting a User"

For more information, see Section 20.1, "User, Group, and Role Management".

21.1 Creating and Editing a User

This section describes:

Section 21.1.1, "How to Create a User"

Section 21.1.2, "How to Edit a User"

Section 21.1.3, "How to Change the Password of a User"

21.1.1 How to Create a User

Using the Oracle CEP Visualizer, you can create a user.

To create a user:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Security node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the User tab.

The User tab appears as Figure 21-1 shows.

Figure 21-1 User Tab

Click the New User button at the bottom of the right pane.

The Add a User panel appears as Figure 21-2 shows.

Figure 21-2 Add a User Panel

Configure the Add a User panel as Table 21-1 describes.

Table 21-1 Add a User Panel Attributes

Attribute
Description

Username

Enter the name of the user.

Password

Enter the password for this user.

Passwords must be at least 6 characters in length.

Confirm Password

Re-enter the password for this user.

Description

An optional description for this user.

Belong to groups

Check one or more groups to which the user belongs. The user inherits the privileges of the roles you assign to the groups.

You must assign a user to at least one group. For more information, see Chapter 22, "Managing Groups".

Click OK.

When the account has been successfully created, a confirmation message appears momentarily.

21.1.2 How to Edit a User

You can edit the configuration of existing users.

To edit user passwords, see Section 21.1.3, "How to Change the Password of a User".

To edit a user:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Security node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the User tab.

In the Users table, check the box to the left of the name of the user that you want to modify.

Click the Modify User button at the bottom of the right pane.

The Change User panel appears as Figure 21-3 shows.

Figure 21-3 Change User Panel

Configure the Change User panel as Table 21-2 describes.

Table 21-2 Change User Panel Attributes

Attribute
Description

Username

The name of the user. This is a read-only field.

Password

This field is blank and read-only. To modify the password, see Section 21.1.3, "How to Change the Password of a User".

Confirm Password

This field is blank and read-only. To modify the password, see Section 21.1.3, "How to Change the Password of a User".

Description

Modify the optional description for this user.

Belong to groups

Modify the groups to which the user belongs by checking or unchecking one or more of the groups displayed. Check one or more groups to which the user belongs. The user inherits the privileges of the roles you assign to the groups

You must assign a user to at least one group. For more information, see Chapter 22, "Managing Groups".

Click OK.

21.1.3 How to Change the Password of a User

You can change the password for existing users.

To change other user configuration options, see Section 21.1.2, "How to Edit a User".

To change the password of a user:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Security node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the User tab.

In the Users table, check the boxes to the left of the name of the users that you want to delete as Figure 21-6 shows.

Figure 21-4 Selecting a User

Click the Change Password button at the bottom of the right pane.

The Change Password panel appears as Figure 21-5 shows.

Figure 21-5 Change Password Panel

Configure the Change Password panel as Table 21-2 describes.

Table 21-3 Change User Panel Attributes

Attribute
Description

Username

The name of the user. This is a read-only field.

Password

This field is blank. To modify the password, see Section 21.1.3, "How to Change the Password of a User".

Confirm Password

This field is blank. To modify the password, see Section 21.1.3, "How to Change the Password of a User".

Click OK.

When the password has been successfully changed, a confirmation message appears momentarily.

21.2 Deleting a User

You can delete an existing user using the Oracle CEP Visualizer.

21.2.1 How to Delete a User

You can delete existing users. However, you cannot delete the default administrator user, which is the administrator user originally configured for the domain when it was created with the Configuration Wizard.

To delete a user:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Security node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the User tab.

In the Users table, check the boxes to the left of the name of the users that you want to delete as Figure 21-6 shows.

Figure 21-6 Selecting a User

Click the Delete User button at the bottom of the right pane.

A confirmation dialog appears as Figure 21-7 shows.

Figure 21-7 Delete User Dialog

Click Yes.

When the account has been successfully deleted, a confirmation message appears momentarily.

22 Managing Groups

This chapter describes how you can use Oracle CEP Visualizer to create, edit, and delete user groups, including editing group membership and mapping groups to roles.

Section 22.1, "Creating and Editing a Group"

Section 22.2, "Deleting a Group"

For more information, see Section 20.1, "User, Group, and Role Management".

22.1 Creating and Editing a Group

This section describes:

Section 22.1.1, "How to Create a Group"

Section 22.1.2, "How to Change the Roles to Which a Group Maps"

Section 22.1.3, "How to Change the Groups to Which a User is Assigned"

22.1.1 How to Create a Group

Oracle CEP is configured by default with a set of groups that are in turn mapped to roles. See Section 20.1, "User, Group, and Role Management" for details.

This section describes how to create a new group.

To create a group:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Security node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Group tab.

The Group tab appears as Figure 22-1 shows.

Figure 22-1 Group Tab

Click the New Group button at the bottom of the right pane.

The Add a Group panel appears as Figure 22-2 shows.

Figure 22-2 Add a Group Panel

Configure the Add a Group panel as Table 22-1 describes.

Table 22-1 Add a Group Panel Attributes

Attribute
Description

Group Name

Enter the name of the group.

Description

An optional description for this user.

Has roles

Check one or more roles to which the group maps. Each role grants access to an application.

You must select at least one role. For more information, see Chapter 23, "Managing Roles".

Click OK.

When the group has been successfully created, a confirmation message appears momentarily.

22.1.2 How to Change the Roles to Which a Group Maps

You can change existing groups, including the default groups, to change the roles they map to.

To change the roles to which a group maps:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Security node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Group tab.

In the Group table, check the boxes to the left of the name of the groups that you want to modify as Figure 22-3 shows.

Figure 22-3 Selecting a Group

Click the Modify Group button at the bottom of the right pane.

The Change Group panel appears as Figure 22-2 shows.

Figure 22-4 Change Group Panel

Configure the Change Group panel as Table 22-1 describes.

Table 22-2 Change Group Panel Attributes

Attribute
Description

Group Name

The name of the group. This is a read-only field..

Description

An optional description for this user.

Has roles

Check one or more roles to which the group maps. Each role grants access to an application.

You must select at least one role. For more information, see Chapter 23, "Managing Roles".

Click OK.

When the group has been successfully modified, a confirmation message appears momentarily.

Optionally modify the description of the group.

Click OK.

22.1.3 How to Change the Groups to Which a User is Assigned

To change the groups to which a user is assigned, see Section 21.1.2, "How to Edit a User".

22.2 Deleting a Group

You can delete an existing group using the Oracle CEP Visualizer.

22.2.1 How to Delete a Group

Oracle CEP is configured by default with a set of groups that are in turn mapped to roles: you cannot delete the default groups. See Section 20.1, "User, Group, and Role Management" for details.

This section describes how to delete a group that you created.

To delete a group:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Security node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Group tab.

In the Group table, check the boxes to the left of the name of the groups that you want to delete as Figure 22-5 shows.

Figure 22-5 Selecting a Group

Click the Delete Group button at the bottom of the right pane.

A confirmation dialog appears as Figure 22-6 shows.

Figure 22-6 Delete Group Dialog

Click Yes.

When the group has been successfully deleted, a confirmation message appears momentarily.

23 Managing Roles

This chapter describes how you can use Oracle CEP Visualizer to create and delete roles that associate permissions with user groups.

Section 23.1, "Creating an Application Role"

Section 23.2, "Deleting a Role"

For more information, see Section 20.1, "User, Group, and Role Management".

23.1 Creating an Application Role

You can create an application role using the Oracle CEP Visualizer.

23.1.1 How to Create an Application Role

Oracle CEP is configured by default with a set of task roles that are in turn mapped to groups. See Section 20.1, "User, Group, and Role Management" for details.

This section describes how to create a new application role.

To create an application role:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Security node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Role tab.

The Role tab appears as Figure 23-1 shows.

Figure 23-1 Role Tab

Click the New Role button at the bottom of the right pane.

The Add Application Role panel appears as Figure 23-2 shows.

Figure 23-2 Add Application Role

Configure the Add Application Role panel as Table 23-1 describes.

Table 23-1 Add Application Role Panel Attributes

Attribute
Description

Role Name

Enter the name of the role.

Application Name

Select the radio button of the application you want to associate with this role from the list of all the currently running applications.

Click OK.

When the application role has been successfully created, a confirmation message appears momentarily.

23.2 Deleting a Role

You can delete an existing role using the Oracle CEP Visualizer.

23.2.1 How to Delete a Role

Oracle CEP is configured by default with a set of roles that are in turn mapped to groups: you cannot delete these default roles. See Section 20.1, "User, Group, and Role Management" for details.

This section describes how to delete a role that you created.

To delete a role:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Security node, where Domain refers to the name of your Oracle CEP domain.

In the right pane, click the Role tab.

In the Role table, select the radio button to the left of the name of the role that you want to delete as Figure 23-3 shows.

Figure 23-3 Selecting a Role

Click the Delete Role button at the bottom of the right pane.

A confirmation dialog appears as Figure 23-4 shows.

Figure 23-4 Delete Role Dialog

Click Yes.

When the role has been successfully deleted, a confirmation message appears momentarily.

24 Managing HTTP Publish-Subscribe Server Security

This chapter describes how you can use Oracle CEP Visualizer to configure security for an HTTP publish-subscribe channel for use with event processing networks (EPNs).

Section 24.1, "Configuring Security for an HTTP Publish-Subscribe Channel"

For more information, see Section 20.2, "HTTP Publish-Subscribe Server Channel Security Management".

24.1 Configuring Security for an HTTP Publish-Subscribe Channel

You can configure security for an HTTP publish-subscribe channel using the Oracle CEP Visualizer.

24.1.1 How to Configure Security for an HTTP Publish-Subscribe Channel

Using Oracle CEP Visualizer, you can specify the roles that are allowed to publish to the HTTP publish-subscribe channels that are configured for the HTTP pub-sub server included in Oracle CEP.

To configure security for an HTTP publish-subscribe channel:

Log on to Oracle CEP Visualizer as a user with the Admin role.

In the left pane, click the Domain > Server > Services > Http Pub/Sub Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

A table appears in the right pane with the list of HTTP pub-sub servers configured for Oracle CEP.

In the right pane, click the name of the HTTP pub-sub server in the table. The default server is called pubsub.

In the Channels table, click the name of the channel for which you want to configure security.

In the Publish Roles table, select the roles that are allowed to publish messages to this channel.

If you want to select more than one role, use the Ctrl key.

Click Modify Channel at the bottom of the pane.

25 Managing SSL

This chapter describes how you can use Oracle CEP Visualizer to view and edit SSL configuration for an Oracle CEP server.

Section 25.1, "Viewing SSL Configuration"

Section 25.2, "Editing SSL Configuration"

For more information, see Section 20.3, "SSL Management".

25.1 Viewing SSL Configuration

You can view Oracle CEP server SSL configuration using the Oracle CEP Visualizer.

25.1.1 How to View the SSL Configuration for an Oracle CEP Server

Using Oracle CEP Visualizer, you can view the SSL configuration for an Oracle CEP server.

To view the SSL configuration for an Oracle CEP server:

In the left pane, click the Domain > Server node, where Domain refers to the name of your Oracle CEP domain and Server refers to the name of the server instance.

In the right pane, click the SSL tab.

In the left table, click the SSL configuration you want to view as Figure 25-1 shows.

Figure 25-1 SSL Tab

The default configuration name is sslConfig.

View the SSL configuration options the right table displays.

Table 25-1 lists the SSL configuration options.

Table 25-1 SSL Options

Option
Description

Name

The name of the selected SSL configuration.

Key Store

The file path and name of the key store certificate file contains a self-signed certificate.

The file path is relative to the ORACLE_CEP_HOME/user_projects/domains/DOMAIN_DIR/servername directory, where ORACLE_CEP_HOME refers to the Oracle CEP installation directory (such as d:/oracle_cep), DOMAIN_DIR refers to the domain directory (such as my_domain), and servername refers to the server instance directory (such as server1).

Key Store Pass

The key store password.

Key Store Alias

The key store alias.

Key Store Type

The key store type.

Key Manager Algorithm

The key manager algorithm.

SSL Protocol

The SSL protocol.

Trust Store

The file path and name of the key store certificate file contains a self-signed certificate.

The file path is relative to the ORACLE_CEP_HOME/user_projects/domains/DOMAIN_DIR/servername directory, where ORACLE_CEP_HOME refers to the Oracle CEP installation directory (such as d:/oracle_cep), DOMAIN_DIR refers to the domain directory (such as my_domain), and servername refers to the server instance directory (such as server1).

Trust Store Pass

The trust store password.

Trust Store Alias

The trust store alias.

Trust Store Type

The trust store type.

Trust Manager Algorithm

The trust store algorithm.

Enforce Fips

Whether or not Oracle CEP server uses a Federal Information Processing Standards (FIPS)-certified pseudo-random number generator for SSL.

For more information, see "FIPS" in Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

Need Client Auth

Whether or not Oracle CEP server uses client authentication.

Secure Random Algorithm

The FIPS secure random algorithm, such as FIPS186PRNG.

Secure Random Provider

The FIPS secure random provider, such as com.rsa.jsafe.provider.JsafeJCE.

Cipher

The SSL ciphers.

25.2 Editing SSL Configuration

You can only view the SSL configuration of your Oracle CEP server using Oracle CEP Visualizer. To change the configuration, you must manually update the server's config.xml file.

For more information, see "Configuring SSL to Secure Network Traffic" in the Oracle Fusion Middleware Administrator's Guide for Oracle Complex Event Processing.

A Oracle CQL Query Wizard Template Schema Reference

This appendix includes the XSD for the schema behind Oracle Continuous Query Language (CQL) query templates.

Example A-1 lists the XML schema document (XSD) you use when creating a template for use in the Oracle CQL Query Wizard.

For more information on creating a template, see Section 6.1.10, "How to Create an Oracle CQL Template for the Query Wizard".

Example A-1 wlevs_queryconstructor_config.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns="http://www.bea.com/ns/wlevs/config/queryconstructor"
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
    targetNamespace="http://www.bea.com/ns/wlevs/config/queryconstructor">

    <!-- This is the first draft for the xsd used
        by the query constructor feature of the visualizer. -->

    <!-- The types of Operators supported by the query constructor-->
    <xs:simpleType name="operatorTypes">
        <xs:restriction base="xs:string">
            <xs:enumeration value="DStream" />
            <xs:enumeration value="Filter" />
            <xs:enumeration value="Intersect" />
            <xs:enumeration value="IStream" />
            <xs:enumeration value="Join" />
            <xs:enumeration value="Minus" />
            <xs:enumeration value="Output" />
            <xs:enumeration value="Pattern" />
            <xs:enumeration value="RStream" />
            <xs:enumeration value="Select" />
            <xs:enumeration value="Source" />
            <xs:enumeration value="Union" />
            <xs:enumeration value="Window" />
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="timeUnitTypes">
        <xs:restriction base="xs:string">
            <xs:enumeration value="" />
            <xs:enumeration value="nanoseconds" />
            <xs:enumeration value="milliseconds" />
            <xs:enumeration value="microseconds" />
            <xs:enumeration value="seconds" />
            <xs:enumeration value="minutes" />
            <xs:enumeration value="hours" />
            <xs:enumeration value="days" />
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="windowTypes">
        <xs:restriction base="xs:string">
            <xs:enumeration value="now" />
            <xs:enumeration value="range-time" />
            <xs:enumeration value="range-unbounded" />
            <xs:enumeration value="row-time" />
            <xs:enumeration value="rows" />
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="viewOutputTypes">
        <xs:restriction base="xs:string">
            <xs:enumeration value="Stream" />
            <xs:enumeration value="Relation" />
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="sourceTypes">
        <xs:restriction base="xs:string">
            <xs:enumeration value="ExtRelation" />
            <xs:enumeration value="Stream" />
            <xs:enumeration value="Relation" />
            <xs:enumeration value="View" />
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="outputTypes">
        <xs:restriction base="xs:string">
            <xs:enumeration value="View" />
            <xs:enumeration value="Query" />
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="patternSkipTypes">
        <xs:restriction base="xs:string">
            <xs:enumeration value="DEFAULT" />
            <xs:enumeration value="ALL MATCHES" />
        </xs:restriction>
    </xs:simpleType>

    <!-- Outer element for all querys/views, root attribute points to the
        Output operator's ID for this query-->
    <xs:element name="Rule">
        <xs:complexType>
            <xs:sequence>
                <xs:element name="Operator" type="operatorType"
                    minOccurs="1" maxOccurs="unbounded" />
            </xs:sequence>
            <xs:attribute name="root" type="xs:integer" />
        </xs:complexType>
    </xs:element>

    <!-- Each "box" in the query constructor GUI is an Operator element -->
    <xs:complexType name="operatorType">
        <xs:sequence>

            <!-- Every operator has an associated CQL DDL -->
            <xs:element name="cql-property" type="xs:string"
                minOccurs="1" maxOccurs="1" />

            <!-- The inputs to this operator. A source operator has 0 inputs,
                all other operators have one or more inputs -->
            <xs:element name="inputs" type="inputsType" minOccurs="0"
                maxOccurs="1" />

            <!-- Some operators might have an alias, e.g. source, pattern -->
            <xs:element name="alias" type="xs:string" minOccurs="0"
                maxOccurs="1" />

            <!-- An operator may be any one of those defined in the operatorTypes enumeration -->
            <xs:choice minOccurs="1" maxOccurs="1">
                <xs:group ref="DStreamOperatorType" />
                <xs:group ref="FilterOperatorType" />
                <xs:group ref="IntersectOperatorType" />
                <xs:group ref="IStreamOperatorType" />
                <xs:group ref="JoinOperatorType" />
                <xs:group ref="MinusOperatorType" />
                <xs:group ref="OutputOperatorType" />
                <xs:group ref="PatternOperatorType" />
                <xs:group ref="RStreamOperatorType" />
                <xs:group ref="SelectOperatorType" />
                <xs:group ref="SourceOperatorType" />
                <xs:group ref="UnionOperatorType" />
                <xs:group ref="WindowOperatorType" />
            </xs:choice>
        </xs:sequence>

        <!-- What type of operator is this -->
        <xs:attribute name="type" type="operatorTypes" use="required" />

        <!-- This xml document is a tree of operators, the ID is used as a unique
            identifier to point to an operator.
            The input tag holds an ID of an operator which is an input to 'this' operator.
        -->
        <xs:attribute name="ID" type="xs:integer" use="required" />

    </xs:complexType>

    <!-- The inputs to an operator. Only a source operator has 0 inputs -->
    <xs:complexType name="inputsType">
        <xs:sequence>
            <xs:element name="input" type="xs:integer" minOccurs="1"
                maxOccurs="unbounded" />
        </xs:sequence>
    </xs:complexType>

    <!-- DStream operator structure -->
    <xs:group name="DStreamOperatorType">
        <xs:sequence>
            <!-- there are no elements as of now in the DStream operator structure -->
        </xs:sequence>
    </xs:group>

    <!-- Filter operator structure -->
    <xs:group name="FilterOperatorType">
        <xs:sequence>
            <xs:element name="predicates" type="filterPredicatesType"
                minOccurs="1" maxOccurs="1" />
        </xs:sequence>
    </xs:group>

    <xs:complexType name="filterPredicatesType">
        <xs:sequence>
            <xs:element name="predicate" type="xs:string" minOccurs="1"
                maxOccurs="1" />
        </xs:sequence>
    </xs:complexType>

    <!-- Intersect Operator structure -->
    <xs:group name="IntersectOperatorType">
        <xs:sequence>
            <!-- there are no elements as of now in the Intersect operator structure -->
        </xs:sequence>
    </xs:group>

    <!-- IStream operator structure -->
    <xs:group name="IStreamOperatorType">
        <xs:sequence>
            <!-- there are no elements as of now in the IStream operator structure -->
        </xs:sequence>
    </xs:group>

    <xs:group name="JoinOperatorType">
        <xs:sequence>
            <xs:element name="predicates" type="joinPredicatesType"
                minOccurs="1" maxOccurs="1" />
        </xs:sequence>
    </xs:group>

    <xs:complexType name="joinPredicatesType">
        <xs:sequence>
            <xs:element name="predicate" type="xs:string" minOccurs="1"
                maxOccurs="1" />
        </xs:sequence>
    </xs:complexType>

    <!-- Intersect Operator structure -->
    <xs:group name="MinusOperatorType">
        <xs:sequence>
            <!-- there are no elements as of now in the Minus operator structure -->
        </xs:sequence>
    </xs:group>

    <!-- Output operator structure -->
    <xs:group name="OutputOperatorType">
        <xs:sequence>
            <xs:element name="output-type" type="outputTypes" />
            <xs:element name="output-name" type="xs:string" />
            <xs:element name="view-schema-list" minOccurs="0"
                maxOccurs="1" />
        </xs:sequence>
    </xs:group>

    <xs:complexType name="viewSchemaList">
        <xs:sequence minOccurs="1" maxOccurs="unbounded">
            <xs:element name="view-attr">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="name" type="xs:string" />
                        <xs:element name="type" type="xs:string" />
                    </xs:sequence>
                </xs:complexType>
            </xs:element>
        </xs:sequence>
    </xs:complexType>

    <!-- Pattern operator structure -->
    <xs:group name="PatternOperatorType">
        <xs:sequence>
            <xs:element name="pattern-skip" type="patternSkipTypes"
                minOccurs="1" maxOccurs="1" />

            <xs:element name="partition-by" minOccurs="0"
                maxOccurs="1">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="partition-attr"
                            type="xs:string" minOccurs="1" maxOccurs="unbounded" />
                    </xs:sequence>
                </xs:complexType>
            </xs:element>

            <xs:element name="define-list" minOccurs="1"
                maxOccurs="1">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="define-attr" type="xs:string"
                            minOccurs="1" maxOccurs="unbounded" />
                    </xs:sequence>
                </xs:complexType>
            </xs:element>

            <xs:element name="measures-list" minOccurs="1"
                maxOccurs="1">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="measure-attr" type="xs:string"
                            minOccurs="1" maxOccurs="unbounded" />
                    </xs:sequence>
                </xs:complexType>
            </xs:element>

            <xs:element name="pattern-list" minOccurs="1"
                maxOccurs="1">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="pattern-attr" type="xs:string"
                            minOccurs="1" maxOccurs="unbounded" />
                    </xs:sequence>
                </xs:complexType>
            </xs:element>

            <xs:element name="subsets" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="subset" type="subsetType"
                            minOccurs="1" maxOccurs="unbounded" />
                    </xs:sequence>
                </xs:complexType>
            </xs:element>

            <xs:element name="timer-event" minOccurs="0"
                maxOccurs="1">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="duration" type="xs:string" />
                        <xs:element name="multiple-duration"
                            type="xs:boolean" />
                    </xs:sequence>
                </xs:complexType>
            </xs:element>
        </xs:sequence>
    </xs:group>

    <xs:complexType name="subsetType">
        <xs:sequence>
            <xs:element name="subset-name" type="xs:string" />
            <xs:element name="corr-attr-name" type="xs:string" />
        </xs:sequence>
    </xs:complexType>

    <!-- Rstream operator structure -->
    <xs:group name="RStreamOperatorType">
        <xs:sequence>
            <!-- there are no elements as of now in the RStream operator structure -->
        </xs:sequence>
    </xs:group>

    <!-- Select operator structure -->
    <xs:group name="SelectOperatorType">
        <xs:sequence>
            <xs:element name="select-list" type="selectListType"
                minOccurs="1" maxOccurs="1" />

            <xs:element name="group-list" type="groupListType"
                minOccurs="0" maxOccurs="1" />

            <xs:element name="having-clause" type="xs:string"
                minOccurs="0" maxOccurs="1" />

            <xs:element name="order-by-list" minOccurs="0"
                maxOccurs="1" />
        </xs:sequence>
    </xs:group>

    <xs:complexType name="groupListType">
        <xs:sequence>
            <xs:element name="group-by" type="xs:string" minOccurs="1"
                maxOccurs="unbounded" />
        </xs:sequence>
    </xs:complexType>

    <xs:complexType name="orderByListType">
        <xs:sequence>
            <xs:element name="order-by-attr" type="orderByAttrType"
                minOccurs="1" maxOccurs="unbounded" />
        </xs:sequence>
    </xs:complexType>

    <xs:complexType name="orderByAttrType">
        <xs:sequence>
            <xs:element name="order-by-symbol" type="xs:string" />
            <xs:element name="ascending" type="xs:boolean" />
            <xs:element name="nulls-first" type="xs:boolean" />
        </xs:sequence>
    </xs:complexType>

    <xs:complexType name="selectListType">
        <xs:sequence>
            <xs:element name="select-attr" type="selectAttrType"
                minOccurs="1" maxOccurs="unbounded">

            </xs:element>
        </xs:sequence>
    </xs:complexType>

    <xs:complexType name="selectAttrType">
        <xs:sequence>
            <xs:element name="select-expression" type="xs:string" />
            <xs:element name="alias" type="xs:string" />
        </xs:sequence>
    </xs:complexType>

    <!-- Source operator structure -->
    <xs:group name="SourceOperatorType">
        <xs:sequence>
            <!-- The name of this source in the CQL engine -->
            <xs:element name="source-name" type="xs:string" />

            <!-- Is this a 'View' / 'Stream' / 'Relation' -->
            <xs:element name="source-type" type="sourceTypes" />

            <!-- If this is a view, does it produce a 'Stream' or a 'Relation' -->
            <xs:element name="view-output-type" type="viewOutputTypes"
                minOccurs="0" maxOccurs="1" />
        </xs:sequence>
    </xs:group>

    <!-- Intersect Operator structure -->
    <xs:group name="UnionOperatorType">
        <xs:sequence>
            <!-- Is this a union all statement? true/false -->
            <xs:element name="union-all" type="xs:boolean" />
        </xs:sequence>
    </xs:group>

    <!-- Window operator structure -->
    <xs:group name="WindowOperatorType">
        <xs:sequence>
            <!-- what type of window is this -->
            <xs:element name="type" type="windowTypes" />

            <!-- only for partition windows -->
            <xs:element name="partition-by" type="xs:string"
                minOccurs="0" maxOccurs="1" />

            <!-- required for all windows except "now" -->
            <xs:element name="range-params" type="windowRangeParamsType"
                minOccurs="0" maxOccurs="1" />
        </xs:sequence>
    </xs:group>

    <xs:complexType name="windowRangeParamsType">
        <xs:sequence>
            <xs:element name="timeSpecType" minOccurs="0" maxOccurs="1" />
            <xs:element name="slideSpecType" minOccurs="0"
                maxOccurs="1" />
            <xs:element name="rows" type="xs:integer" minOccurs="0"
                maxOccurs="1" />
        </xs:sequence>
    </xs:complexType>

    <xs:complexType name="slideSpecType">
        <xs:sequence>
            <xs:element name="slidevalue" type="xs:integer" />
            <xs:element name="slideunit" type="timeUnitTypes" />
        </xs:sequence>
    </xs:complexType>

    <xs:complexType name="timeSpecType">
        <xs:sequence>
            <xs:element name="timevalue" type="xs:decimal" />
            <xs:element name="timeunit" type="timeUnitTypes" />
        </xs:sequence>
    </xs:complexType>
</xs:schema>

Index

A  C  D  E  F  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  V  W 

Symbols

*

maximal pattern quantifier (0 or more times), 6.1.9.4

*?

minimal pattern quantifier (0 or more times), 6.1.9.4

+

maximal pattern quantifier (1 or more times), 6.1.9.4

+?

minimal pattern quantifier (1 or more times), 6.1.9.4

?

maximal pattern quantifier (0 or 1 time), 6.1.9.4

??

minimal pattern quantifier (0 or 1 time), 6.1.9.4

A

accessibility, 2.3

adapter stage configuration, 4.2.1.7

administration tasks

about, 1.3

managing applications, 1.3.1

managing security, 1.3.3

managing servers, 1.3.2

updating configuration information, 1.3.4

aliases

columns, 6.1.9.4

stream elements, 6.1.9.4

ALL MATCHES clause, 6.1.9.4

application roles, 20.1

application timestamped, 4.2.1.1

applications

com.bea.wlevs.dataservices, 1.3.1.1

EPL rules, 3.3

creating, 7.1

dataservices application, 7.4

deleting, 7.2

replacing, 7.3

Event Processing Network, 3.1

adapter stage configuration, 4.2.1.7

channel stage configuration, 4.2.1.1

EPL processor stage configuration, 4.2.1.6

event bean stage configuration, 4.2.1.13

Event Inspector service, 4.4

event record and playback, 4.3

event trace and inject, 4.4

HA broadcast adapter stage configuration, 4.2.1.11

HA buffering adapter stage configuration, 4.2.1.10

HA input adapter stage configuration, 4.2.1.9

HA output adapter stage configuration, 4.2.1.12

JMS adapter stage configuration, 4.2.1.8

monitoring channel size, 4.5

monitoring throughput and latency, 4.6

Oracle CEP local cache stage configuration, 4.2.1.16

Oracle Coherence cache stage configuration, 4.2.1.15

Oracle CQL processor stage configuration, 4.2.1.5

outbound channel stage configuration, 4.2.1.2

POJO stage configuration, 4.2.1.14

stage configuration, 4.2

stream stage configuration, 4.2.1.4

viewing, 4.1

lifecycle, 3.2

deploying in standalone-server domain, 5.1

resuming, 5.2

suspending, 5.2

uninstalling, 5.4

updating, 5.3

managing, 1.3.1

Oracle CQL rules, 3.3

configuring Cache-Table CQL constructs, 6.1.9.3

configuring CQL constructs, 6.1.9

configuring DStream CQL constructs, 6.1.9.14

configuring Filter CQL constructs, 6.1.9.9

configuring Intersect CQL constructs, 6.1.9.11

configuring IStream CQL constructs, 6.1.9.13

configuring Join CQL constructs, 6.1.9.6, 6.1.9.7

configuring Minus CQL constructs, 6.1.9.12

configuring Output CQL constructs, 6.1.9.16

configuring Pattern CQL constructs, 6.1.9.4

configuring RSource CQL constructs, 6.1.9.1

configuring RStream CQL constructs, 6.1.9.15

configuring Select CQL constructs, 6.1.9.5

configuring SSource CQL constructs, 6.1.9.2

configuring Union CQL constructs, 6.1.9.10

configuring Window CQL constructs, 6.1.9.8

creating parameterized queries, 6.1.3

creating using Query Wizard, 6.1.1

deleting using Query Wizard, 6.1.6

Expression Builder, 6.1.9.17

modifying parameterized queries, 6.1.4

modifying using Query Wizard, 6.1.2

query plan, 6.2, 6.2.2

Query Wizard tools, 6.1.11

replacing using Query Wizard, 6.1.7

templates, 6.1.10

viewing using Query Wizard, 6.1.8

application-timestamped, 4.2.1.1

as operator, 6.1.9.4

C

cache

about, 9.10

cache system

about, 9.10

Oracle CEP local cache, 9.10

Oracle Coherence, 9.10

third-party, 9.10

properties

Eviction Policy, 4.2.1.16

Max Size, 4.2.1.16

Max Threads, 4.2.1.16

Time To Live, 4.2.1.16

Write Policy, 4.2.1.16

stage configuration, 4.2.1.5, 4.2.1.16

cache system

about, 9.10

Oracle CEP local cache, 9.10

Oracle Coherence, 9.10

third-party, 9.10

Cache-Table CQL construct, 6.1.9.3

channel

properties

HeartBeat TimeOut, 4.2.1.1

Max Size, 4.2.1.1, 4.2.1.2, 4.2.1.4

Max Threads, 4.2.1.1, 4.2.1.2, 4.2.1.4

Selectors, 4.2.1.3

Timestamp Type, 4.2.1.1

security, 24.1.1

stage configuration, 4.2.1.1

cluster topology tools, 18.3

column aliases, 6.1.9.4

com.bea.wlevs.dataservices, 1.3.1.1, 7.4

component logging, 19.1.2

conditions, 6.1.9.4

configuration, 1.3.4

configuration file UTF-8 encoding, 1.5.1

configuration history management

about, 3.4

application changes, 8.2

application deployment, 5.1

application uninstall, 5.4

application update, 5.3

applications, 3.4.3

high availability adapter changes, 8.1

multi-server domains, 3.4.5

Oracle CQL rule changes, 8.1

resource changes, 8.1

resources, 3.4.2

config.xml, 20.3, 25.2

console output, 19.2.2

D

Dashboard, 1.2.1

data sources

about, 9.4

adding, 13.2.1

editing, 13.1.2

viewing configuration, 13.1.1

DEFINE clause, 6.1.9.4, 6.1.9.5

deploying

stand-alone server domain, 5.1

viewing deployments, 10.1.1

distinct, 6.1.9.5

double-byte characters, 1.5

DStream CQL construct, 6.1.9.14

DStream relation-to-stream operator, 6.1.9.14

DURATION clause, 6.1.9.4

DURATION MULTIPLES OF clause, 6.1.9.4

E

EPL processor stage configuration, 4.2.1.6

EPL rules

creating, 7.1

dataservices application, 7.4

deleting, 7.2

managing, 3.3

replacing, 7.3

event bean stage configuration, 4.2.1.13

event inject, 4.4

Event Inspector service, 4.4

about, 9.9

event inject

JSON string, 4.4.3

simple, 4.4.2

HTTP pub-sub

channel, 4.4.1, 4.4.2, 4.4.3

HTTP pub-sub server, 15.1.1

Event Processing Network

about, 3.1

adapter stage configuration, 4.2.1.7

channel stage configuration, 4.2.1.1

EPL processor stage configuration, 4.2.1.6

event bean stage configuration, 4.2.1.13

Event Inspector service, 4.4

event record and playback, 4.3

event trace and inject, 4.4

HA broadcast adapter stage configuration, 4.2.1.11

HA buffering adapter stage configuration, 4.2.1.10

HA input adapter stage configuration, 4.2.1.9

HA output adapter stage configuration, 4.2.1.12

JMS adapter stage configuration, 4.2.1.8

monitoring channel size, 4.5

monitoring throughput and latency, 4.6

Oracle CEP local cache stage configuration, 4.2.1.16

Oracle Coherence cache stage configuration, 4.2.1.15

Oracle CQL processor stage configuration, 4.2.1.5

outbound channel stage configuration, 4.2.1.2

POJO stage configuration, 4.2.1.14

stage configuration, 4.2

stream stage configuration, 4.2.1.4

viewing, 4.1

event record and playback, 4.3

event trace and inject, 4.4

event type repository

about, 9.6

configuring, 16.2

viewing, 16.1.1

Eviction Policy, 4.2.1.16

Expression Builder, 6.1.9.17

extension libraries, 10.1.2

F

Filter CQL construct, 6.1.9.9

foreign stages, 14.1.1

Full Screen, 1.2.1

G

group by, 6.1.9.4

groups

about, 20.1

assigning to user, 22.1.3

creating, 22.1.1

deleting, 22.2.1

mapping roles to, 22.1.2

H

HA adapters

broadcast adapter stage configuration, 4.2.1.11

buffering adapter stage configuration, 4.2.1.10

input adapter stage configuration, 4.2.1.9

output adapter stage configuration, 4.2.1.12

HA cluster topologies

viewing multi-server domains, 18.1.3

HAVING clause, 6.1.9.5

heartbeat, 4.2.1.1

system timestamped relations, 4.2.1.1

system timestamped streams, 4.2.1.1

HeartBeat TimeOut, 4.2.1.1

Help, 1.2.1

Home, 1.2.1

HTTP pub-sub server, 9.5

securing channels, 24.1.1

security, 20.2

HTTP pub-sub server channels

adding, 14.2.1

deleting, 14.2.2

viewing, 14.1.1

viewing messages, 4.4.1

viewing messages, troubleshooting, 4.4.1

I

IDE, 2.1.3

Intersect CQL construct, 6.1.9.11

IStream CQL construct, 6.1.9.13

IStream relation-to-stream operator, 6.1.9.13

J

JAWS screen reader, 2.3

Jetty

about, 9.2

changing configuration, 11.1.2

creating work managers, 11.2.2

deleting work managers, 11.2.3

viewing configuration, 11.1.1

viewing work manager configuration, 11.2.1

work managers, 9.2

JMS adapter stage configuration, 4.2.1.8

JMX

about, 9.3

changing configuration, 12.2

management

JRMP, 12.1.1

MSA, 12.1.1

viewing configuration, 12.1.1

Join CQL construct, 6.1.9.6, 6.1.9.7

JRMP protocol, 12.1.1

L

libraries, 10.1.2

logs

about, 9.11

configuring component log, 19.1.2

configuring log service, 19.1.1

querying, 19.2.1

viewing console output, 19.2.2

M

Management Events, 1.2.4

MATCH_RECOGNIZE

about, 6.1.9.4

ALL MATCHES clause, 6.1.9.4

DEFINE clause, 6.1.9.4, 6.1.9.5

DURATION clause, 6.1.9.4

DURATION MULTIPLES OF clause, 6.1.9.4

MEASURES clause, 6.1.9.4, 6.1.9.5

PARTITION BY clause, 6.1.9.4

PATTERN clause, 6.1.9.4, 6.1.9.4, 6.1.9.5

pattern-matching conditions, 6.1.9.4

SUBSET clause, 6.1.9.4

Max Size, 4.2.1.1, 4.2.1.2, 4.2.1.4, 4.2.1.16

Max Threads, 4.2.1.1, 4.2.1.2, 4.2.1.4, 4.2.1.16

MEASURES clause, 6.1.9.4, 6.1.9.5

Minus CQL construct, 6.1.9.12

monitoring channel size, 4.5

monitoring throughput and latency, 4.6

MSA protocol, 12.1.1

multi-server domains

about, 9.8, 9.8

evs4j, 9.8

monitoring nodes in Oracle Coherence cluster, 18.2.2

Oracle Coherence, 9.8

primary server, 18.1.2, 18.1.3.1, 18.1.3.2

tuning Oracle Coherence, 18.2.4

viewing, 18.1.1

viewing all cluster topologies, 18.1.2

viewing HA cluster topologies, 18.1.3

viewing Oracle Coherence cluster topologies, 18.2.1

N

national language support

about, 1.5

double-byte characters, 1.5

UTF-8 encoding, 1.5.1

O

Open Items, 1.2.2

operators

relation-to-stream

DStream, 6.1.9.14

IStream, 6.1.9.13

RStream, 6.1.9.15

Oracle CEP IDE for Eclipse, 2.1.3

Oracle CEP instance, 1.4.1

Oracle CEP local cache stage configuration, 4.2.1.16

Oracle CEP Visualizer, 1.4.1

about, 1.1

administration tasks

about, 1.3

managing applications, 1.3.1

managing security, 1.3.3

managing servers, 1.3.2

updating configuration information, 1.3.4

Oracle Complex Event Processing Server, 1.1

Preferences, 2.2.1

starting

about, 2.1

browser, 2.1.2

multi-server domain, 2.1.4

Oracle CEP IDE for Eclipse, 2.1.3

prerequisites, 2.1.1

user interface

context menu, 1.2.6.1

Dashboard, 1.2.1, 1.2.4

Event Processing Network, 1.2.6

Full Screen, 1.2.1

Help, 1.2.1

Home, 1.2.1

Left Pane, 1.2.2

Management Events, 1.2.4

Open Items, 1.2.2

Performance Monitoring, 1.2.4

Preferences, 1.2.1

refresh, 1.2.7

Right Pane, 1.2.3

Security, 1.2.1

Top pane, 1.2.1

ViewStream, 1.2.1, 1.2.5

using, 1.1

Oracle Coherence

cache, 9.10

monitoring cache, 18.2.3

monitoring nodes, 18.2.2

multi-server domains, 9.8

tuning, 18.2.4

viewing cluster topologies, 18.2.1

Oracle Coherence cache stage configuration, 4.2.1.15

Oracle CQL constructs

Cache-Table, 6.1.9.3

configuring, 6.1.9

DStream, 6.1.9.14

Filter, 6.1.9.9

Intersect, 6.1.9.11

IStream, 6.1.9.13

Join, 6.1.9.6, 6.1.9.7

Minus, 6.1.9.12

Output, 6.1.9.16

Pattern, 6.1.9.4

RSource, 6.1.9.1

RStream, 6.1.9.15

Select, 6.1.9.5

SSource, 6.1.9.2

Union, 6.1.9.10

Window, 6.1.9.8

Oracle CQL processor stage configuration, 4.2.1.5

Oracle CQL rules

configuring Cache-Table CQL constructs, 6.1.9.3

configuring CQL constructs, 6.1.9

configuring DStream CQL constructs, 6.1.9.14

configuring Filter CQL constructs, 6.1.9.9

configuring Intersect CQL constructs, 6.1.9.11

configuring IStream CQL constructs, 6.1.9.13

configuring Join CQL constructs, 6.1.9.6, 6.1.9.7

configuring Minus CQL constructs, 6.1.9.12

configuring Output CQL constructs, 6.1.9.16

configuring Pattern CQL constructs, 6.1.9.4

configuring RSource CQL constructs, 6.1.9.1

configuring RStream CQL constructs, 6.1.9.15

configuring Select CQL constructs, 6.1.9.5

configuring SSource CQL constructs, 6.1.9.2

configuring Union CQL constructs, 6.1.9.10

configuring Window CQL constructs, 6.1.9.8

creating parameterized queries, 6.1.3

creating using Query Wizard, 6.1.1

deleting using Query Wizard, 6.1.6

Expression Builder, 6.1.9.17

managing, 3.3

modifying parameterized queries, 6.1.4

modifying using Query Wizard, 6.1.2

replacing using Query Wizard, 6.1.7

templates, 6.1.10

viewing using Query Wizard, 6.1.8

outbound channel stage configuration, 4.2.1.2

Output CQL construct, 6.1.9.16

P

PARTITION BY clause, 6.1.9.4

PATTERN clause, 6.1.9.4, 6.1.9.4, 6.1.9.5

Pattern CQL construct, 6.1.9.4

pattern-matching conditions, 6.1.9.4

Performance Monitoring, 1.2.4

persistent event store

about, 9.7

configuring, 17.2

viewing, 17.1.1

POJO stage configuration, 4.2.1.14

Preferences, 1.2.1, 2.2.1

programming model, 2.1.3

Q

query plan

creating, 6.2

tools, 6.2.2

Query Wizard, 6.1.1

tools, 6.1.11

querying logs, 19.2.1

R

refresh, 1.2.7

relations

heartbeat, 4.2.1.1

relation-to-stream operators

DStream, 6.1.9.14

IStream, 6.1.9.13

RStream, 6.1.9.15

resuming, 5.2

roles

about, 20.1

application, 20.1

creating, 23.1.1

deleting, 23.2.1

task, 20.1

RSource CQL construct, 6.1.9.1

RStream CQL construct, 6.1.9.15

RStream relation-to-stream operator, 6.1.9.15

S

screen readers, 2.3

Secure Sockets Layer. See SSL

security

groups

about, 20.1

assigning to user, 22.1.3

creating, 22.1.1

deleting, 22.2.1

mapping roles to, 22.1.2

HTTP pub-sub server

about, 20.2

securing channels, 24.1.1

managing, 1.3.3

roles

about, 20.1

application, 20.1

creating, 23.1.1

deleting, 23.2.1

task, 20.1

SSL

about, 20.3

changing configuration, 25.2

viewing configuration, 25.1.1

users

about, 20.1

creating, 21.1.1

deleting, 21.2.1

modifying, 21.1.2

password changing, 21.1.3

Select CQL construct, 6.1.9.5

Selectors, 4.2.1.3

servers

cache

about, 9.10

monitoring Oracle Coherence cache, 18.2.3

tuning Oracle Coherence, 18.2.4

configuration history management

about, 3.4

application changes, 8.2

applications, 3.4.3

high availability adapter changes, 8.1

multi-server domains, 3.4.5

Oracle CQL rule changes, 8.1

resource changes, 8.1

resources, 3.4.2

data sources

about, 9.4

adding, 13.2.1

editing, 13.1.2

viewing configuration, 13.1.1

deployments

about, 9.1

viewing, 10.1.1

Event Inspector service

HTTP pub-sub server, 15.1.1

event type repository

about, 9.6

configuring, 16.2

viewing, 16.1.1

extension libraries

viewing, 10.1.2

HTTP pub-sub server

about, 9.5

HTTP pub-sub server channels

adding, 14.2.1

deleting, 14.2.2

viewing, 14.1.1

viewing messages, 4.4.1

viewing messages, troubleshooting, 4.4.1

Jetty

about, 9.2

changing configuration, 11.1.2

creating work managers, 11.2.2

deleting work managers, 11.2.3

viewing configuration, 11.1.1

viewing work manager configuration, 11.2.1

JMX

about, 9.3

changing configuration, 12.2

viewing configuration, 12.1.1

libraries

about, 9.1

viewing, 10.1.2

logs

about, 9.11

configuring component log, 19.1.2

configuring log service, 19.1.1

querying, 19.2.1

viewing console output, 19.2.2

managing, 1.3.2

multi-server domains

about, 9.8

cluster topology tools, 18.3

monitoring nodes in Oracle Coherence cluster, 18.2.2

primary server, 18.1.2, 18.1.3.1, 18.1.3.2

tuning Oracle Coherence, 18.2.4

viewing, 18.1.1

viewing all cluster topologies, 18.1.2

viewing HA cluster topologies, 18.1.3

viewing Oracle Coherence cluster topologies, 18.2.1

persistent event store

about, 9.7

configuring, 17.2

viewing, 17.1.1

SSL

about, 20.3

changing configuration, 25.2

config.xml, 20.3, 25.2

viewing configuration, 25.1.1

SSource CQL construct, 6.1.9.2

stage configuration, 4.2

adapter, 4.2.1.7

channel, 4.2.1.1

EPL processor, 4.2.1.6

event bean, 4.2.1.13

HA broadcast adapter, 4.2.1.11

HA buffering adapter, 4.2.1.10

HA input adapter, 4.2.1.9

HA output adapter, 4.2.1.12

JMS adapter, 4.2.1.8

Oracle CEP local cache, 4.2.1.16

Oracle Coherence cache, 4.2.1.15

Oracle CQL processor, 4.2.1.5

outbound channel, 4.2.1.2

POJO, 4.2.1.14

stream, 4.2.1.4

starting

about, 2.1

browser, 2.1.2

from Oracle CEP IDE for Eclipse, 2.1.3

in multi-server domain, 2.1.4

prerequisites, 2.1.1

stream

heartbeat, 4.2.1.1

stage configuration, 4.2.1.4

Stream Visualizer. See ViewStream

subset clause, 6.1.9.4

suspending, 5.2

system timestamped, 4.2.1.1

T

task roles, 20.1

templates, 6.1.10

Time To Live, 4.2.1.16

Timestamp Type, 4.2.1.1

timestamps

application, 4.2.1.1

system, 4.2.1.1

U

uninstalling, 5.4

Union CQL construct, 6.1.9.10

updating, 5.3

updating configuration information, 1.3.4

user-interface

context menu, 1.2.6.1

Dashboard, 1.2.1, 1.2.4

Event Processing Network, 1.2.6

Full Screen, 1.2.1

Help, 1.2.1

Home, 1.2.1

Left Pane, 1.2.2

Management Events, 1.2.4

Open Items, 1.2.2

Performance Monitoring, 1.2.4

Prefernces, 1.2.1

refresh, 1.2.7

Right Pane, 1.2.3

Security, 1.2.1

Top Pane, 1.2.1

ViewStream, 1.2.1, 1.2.5

users

about, 20.1

creating, 21.1.1

deleting, 21.2.1

modifying, 21.1.2

password changing, 21.1.3

UTF-8 encoding, 1.5.1

V

ViewStream

button, 1.2.1

overview, 1.2.5

tracing events

injecting JSON events, 4.4.3

injecting simple events, 4.4.2

publish, 4.4.2, 4.4.3

subscribe, 4.4.1

W

Window CQL construct, 6.1.9.8

work managers, 9.2

creating, 11.2.2

deleting, 11.2.3

viewing configuration, 11.2.1

Write Policy, 4.2.1.16

This figure shows the Work Manager tab. It contains a Work Manager table with columns Name, Min Threads, Fair Share, and Max Threads. There is Name field with value JettyWorkManager, Min Threads field with value 5, Max Threads field with value 10, and Fair Share field with value -1. There are buttons: Edit, Save, and Cancel. The Edit and Cancel buttons are greyed out.

This figure shows the Data Source tab. It contains a Name field with value myDatasource2, a JNDI Name field with value myds2, and a Global Tx Protocol pull-down menu with value OnePhaseCommit selected.

This figure shows the Coherence > Topology tab. It contains four areas: Overview, Group List, Layout, and Properties Table. The Group List contains a list of all cluster groups: WLEvServer-1 (containing WLEvServer-1), WLEvServer-2 (containing WLEvServer-2), testgroup (containing WLEvServer-1 and WLEvServer-2), and AllDomainMembers (containing WLEvServer-1 and WLEvServer-2). The Layout contains a graphical depiction of each the groups in the Group List. The Properties Table contains two columns: Property and Value. It lists the properties of the selected group or server instance..

This figure shows the General tab for a stream stage. It contains fields Max Size with value 1024 and Max Threads with value 1. There are buttons: Create Diagnostics, Edit, Save, and Cancel. The Save and Cancel buttons are greyed out

This figure shows an Oracle CQL outer join in the query constructor. It is composed of Source 3 connected to Window 4 connected to OuterJoin 5 and Source 1 connected to Window 2 connected to OuterJoin 5. Source 6 is connected to Window 7. Window 7 and OuterJoin 5 are connected to OuterJoin 8 which is connected to Select 9 which is connected to Output 10.

This figure shows the Install Application Screen. It contains an Upload Files table with columns Application Name and Size (k). There is a row with Application Name value com.bea.wlevs.example.helloworld_3.0.0.0.jar and Size (k) value 8. This row is selected. There is a Deployed File field with value com.bea.wlevs.example.helloworld_3.0.0.0.jar and an Application Name field with value helloworld. There is a Select Target Group to Deploy field with value testgroup and next to it a Clear Group button. There is a table at the bottom of this screen with columns Group, Server, Host Name, Listen Port, and Secure Listen Port. There are four rows. Row 1 with Group value AllDomainMembers, and all other columns blank. Row 2 with Group value WLEvServer-1 and all other columns blank. Row 3 with WLEvServer-2 and all other columns blank. Row 4 with Group value testgroup. The testgroup item is expanded to reveal two more rows. Sub-row 1 with Server value WLEServer-1, Host Name value localhost, Listen Port value 8003, and Secure Listen Port value 8004. Sub-row 2 with Server value WLEServer-2, Host Name value localhost, Listen Port value 9002, and Secure Listen Port value 9003.

This figure shows the Event Processing tab for application myHelloWorld after the application has been undeployed and redeployed. The EPN is greyed out and reads "This panel is disabled due to the application is not available now". The title of the panel has a red X next to it. In the Open Items list, each affected panel that is currently open has a red X next to it.

This figure shows the Query Wizard tab. The User-defined templates accordion tab is selected to show the example user-defined template.

This figure shows the General tab for a channel stage (with upstream Oracle CQL processor) after clicking Edit. The Channel Parameter accordion tab is selected. It contains fields Channel Type with value Stream, Max Size with value 1024, Max Threads with value 1, and Event Type Name with value AlertEvent. There are buttons: Create Diagnostics, Edit, Save, Cancel, and Help. The Save and Cancel buttons are greyed out.

This figure shows the Topology tab divided into three vertical sections. The left section shows a deployment group member hierarchy. The middle section displays a graphical representation of the selected deployment group member. The right section displays the properties of the selected group member.

This figure shows the Query Wizard Pattern editor dialog. It contains tabs: Pattern, Define, Subset, and Measure. The Measure tab is selected. It contains an Object Name text entry field and next to it an AS text entry field. There are buttons Expression Builder, Add, and Delete. There is a Properties list and a Generated Pattern Match Statement text entry field.

This figure shows the Log Query screen. It contains LogFile pull-down menu with server.log selected, Severity pull-down menu with Warning selected, MaxCount numeric entry field with value 20, StartTime date entry field with a Calendar button and a time entry field for hour, minute, and second, and an EndTime date entry field with a Calendar button and a time entry field for hour, minute, and second. There is a table with columns Time, Severity, Module, and Message. There are buttons: Start Query, Previous, and Next. The Previous and Next buttons are greyed out.

This figure shows the console output window. It contains a text area where console messages scroll by. There ar buttons: Clean Text, Pause, and Resume. The Resume button is greyed out.

This figure shows the Query Wizard Select editor dialog. It contains tabs: Project, Group, Condition, and Order. The Project tab is selected. It contains a Distinct check box (which is unchecked) and a Target event type pull-down menu. There are three areas: Source, Project Predicates, and Project Expression. The Source area contains a pull-down menu and a Properties list. The Project Predicates area contains a Delete button and a Select List. The Project Expression area contains a Project expression text entry field and next to it an Expression Builder button and an AS pull-down menu and next to that, an Add button. There is a Generated CQL Statement text entry field.

This figure shows the Event Processing Network tab of a deployed application. It contains an EPN diagram. Above the EPN diagram, it contains a miniature view of the EPN, a Layout pull-down menu with default selection hierarchic, a Zoom slider, a Fit Content button, an Actual Size button, a Zoom Out button, and a Zoom In button. The FXQuoteStream channel has been right-clicked to show the context menu that contains the following options: Open Panel, Record Event, Playback Event, Trace Event, Inject Event, Settings, and About Adobe Flash Player.

This figure shows the Cluster Groups/Server tab. It contains three areas: Groups, Servers of group, and Applications of group. The Groups area is a list of the following groups: WLEvServer-1, WLEvServer-2, testgroup, AllDomainMembers. The testgroup Group is selected. The Servers of group area is titled Servers of group - testgroup. It contains a list of servers: WLEvServer-1 and WLEvServer-2. The Applications of group area is titled Applications of group - testgroup and is a table with columns Name, State, and Target. It contains one row with Name value helloworld, State value RUNNING, and Target value [testgroup, AllDomainMembers]. On the left there are two server nodes: WLEvServer-1 and WLEvServer-2. The WLEvServer-1 node is expanded to show Applications com.bea.wlevs.dataservices and helloworld. The WLEvServer-2 node is expanded to show com.bea.wlevs.dataservices, fx, and helloworld.

This figure shows the Change User panel. It contains fields Username, Password, Confirm Password, and Description. It also contains a list of groups, each with a check box. The Username, Password, and Confirm Password fields are read-only. The Password and Confirm Password fields are blank.

This figure shows the Role tab. It contains a Roles table with columns Role, Type, and Application. It contains a Resources table with columns ID and Policy. There are buttons: New Role and Delete Role.

This figure shows the tools along the top of the Query Plan tab, including Choose layout pull-down menu, Collapse All button, Expand All button, Get Statistics button, Refresh button, Show Legend check box, Preferences button, Fit Content button, and a Zoom slider.

This figure shows the Query Plan tab. It contains an Overview diagram. Below that there is a table with columns Data, ID, numOutMessages, and NumInMessages. Below that is a table with columns Property and Value. In the middle is the query plan diagram. Next to that is a legend of CQL Constructs.

This figure shows the Deployment tab. It is a table with the following columns: Name, State, and Target. There are three rows. Row 1 has Name value helloworld, State value RUNNING, and Target value [testgroup, AllDomainMembers]. Row 2 has Name Value com.bea.evs.dataservices, State value RUNNING, and Target value [AllDomainMembers]. Row 3 has Name value fx, State value RUNNING, and Target value [WLEvServer-2].

This figure shows the Add New Binding Dialog. It reads: You are about to add new binding maxcount. There is an OK and Cancel button.

This figure shows the Query Wizard Pattern editor dialog. It contains tabs: Pattern, Define, Subset, and Measure. The Subset tab is selected. It contains a Subset name text entry field and next to an AS text entry field. There are buttons Add and Delete. There is a Subset List and a Generated Pattern Match Statement text entry field.

This figure shows the event record schedule confirmation dialog. It reads You are about to change the recording schedule. It contains buttons: OK and Cancel.

This figure shows a confirmation dialog. The title of the dialog is Delete Role. The dialog reads: Are you sure to delete role: fxRole? There is a Yes and No button.

This figure shows an Oracle CQL statement on the Query Wizard canvas. The mouse pointer is hovering over the Source operator to display the Oracle CQL statement "* from Merged AS a".

This figure shows the Query Wizard Union editor dialog. It contains two areas: Source 1, Source 2, and Union Type. The Source 1 area contains a TotalFailedByNonZeroType pull-down menu and a Properties list. The Source 2 area contains a Dummy9 pull-down menu and a Properties list. There is a Generated CQL Statement text entry field

This figure shows the Working Area at the bottom of a CQL Rules tab with a parameterized query selected. There is a table with columns Binding Name, 1, and 2. There is one row with values: avgcount, avg(internalPrice), count(*) > 0. There is a Binding Name field with value maxcount and a Binding Values field with value max(internalPrice), count(*) > 0. Both fields are editable. There are buttons Delete Query, Edit Query, Add Parameter, Replace Parameter, Delete Parameter, Stop, Save, and Cancel. Only Save and Cancel are active.

This figure shows the General tab for a channel stage before clicking Modify. It contains fields Channel Type with value Stream, Max Size with value 1024, Max Threads with value 1, Event Type Name with value StockTick, TimeStamp Type with value SYSTEM-TIME, and Silent which is a pull-down menu with value false selected. There are buttons: Create Diagnostics, Edit, Save, and Cancel. The Save and Cancel buttons are greyed out.

This figure shows the Delete Binding Dialog. It reads: You are about to remove binding maxcount. There is an OK and Cancel button.

This figure shows the CQL Rules tab with a non-parameterized query selected. There is a radio button group composed of buttons View, Query, and All Rules. The Query button is selected. There is a table with columns Rule ID, Rule, Type, and Running. Below the table there is a Query ID text field, a Query text field, and an Enable radio button group composed of buttons true and false; true is selected. There are buttons Add Query, Delete All Queries, Delete Query, Edit Query, Stop, Query Wizard, Save, and Cancel. Delete All Queries, Save, and Cancel are inactive.

This figure shows the Oracle CEP Visualizer Stream Visualizer. It contains pull down menu CEP Server Name with value NonClusteredServer selected, text entry field Pub/Sub Server URL with value http://localhost:9002/pubsub, button Initialize Client, and button Disconnect (greyed-out). There are two tabs: Publish and Subscribe. The Subscribe tab is selected. This tab contains a table with two columns: Column one contains a radio button group with one radio button per row; Column two is named Channel Name. There are three rows: Row one has radio button unchecked and Channel Name value /evsmonitor; Row two has radio button unchecked and Channel Name value /evsalert; and Row three has radio button unchecked and Channel Name value /evsdomainchange. Below the tab is pull down menu Event Type with CrossRateEvent selected. Below that is radio button group Input Method with radio buttons Jason String (selected) and Form Based Event. Below that is a text display area (which is empty). Below that is button Publish.

This figure shows the Coherence > Cache Chart tab. It contains four areas: Cache Chart, Columns, Drag Property to Watch, and two graphs. The Cache Chart area is a table with a variety of user-selectable columns such as Cache Name # of Objects, Cache Hits, Cache Misses, and Cache Prunes. The Drag Property to Watch area is a list of properties that matches the list of available Cache Chart columns. Below the Drag Property to Watch list are buttons Add to Left and Add to Right. There are two graphs. Property Store Reads Millis has been dragged from the Drag Property to Watch area list and dropped onto the left-hand graph. Property Store Writes Millis has been dragged from the Drag Property to Watch area list and dropped onto the left-hand graph. Below each graph is a legend that distinguishes each selected node by color in the graph.

This figure shows an invalid connection between a Source CQL construct and another Source CQL construct. The target construct is not highlighted.

This figure shows the SSL tab. There are two areas: a list of SSL configurations and a list of SSL configuration properties.

This figure shows the Change Group panel. It contains fields Group Name and Description. It also contains a list of roles, each with a check box. The Group Name field is read-only and contains the value samplesGroup. The Description field is blank. The list of roles includes ApplicationAdmin, Admin, Operator, BusinessUser, Deployer, and Monitor. The check box for role ApplicationAdmin is checked.

This figure shows the Log Query screen. It contains LogFile pull-down menu with server.log selected, Severity pull-down menu with Warning selected, MaxCount numeric entry field with value 20, StartTime date entry field with a Calendar button and a time entry field for hour, minute, and second, and an EndTime date entry field with a Calendar button and a time entry field for hour, minute, and second. There is a table with columns Time, Severity, Module, and Message. There are buttons: Start Query, Previous, and Next. The Previous and Next buttons are greyed out.

This figure shows the Changes tab. It contains a table with columns: Change Record, Action, User, Date, and Description. The Change Record column contains rows of change record folders, each containing information about that individual change described in the table. Below the table are date fields Start Date and End Date. There is a date chooser button next to each field. Below this are buttons Refresh, Undo, Delete, and Help.

This figure shows the Query Wizard Join editor dialog. It contains three areas: Source 1, Source 2, and Join Type. The Source 1 and Source 2 area contains a Select an source pull-down menu and a Properties list. The properties list is empty. The Join Type area contains a radio button group with buttons: Left outer join and Right outer join. The Left outer join button is selected. There is a plus sign button next to the Join Type radio buttons. There is a Join Predicate text entry field with an Expression Builder button. The Join Predicate text entry field contains a.message = b.message. There is a Generated Join Statement text entry field. that contains SELECT * FROM helloworldInputChannel[now] as a LEFT OUTER JOIN helloworldInputChannel [now] as b ON a.message = b.message. There are buttons Help, Change Join, Undo Join, Validate, Save, and Cancel. The dialog is greyed out except for the Help and Cancel buttons.

This figure shows the Processor panel for an Oracle CQL processor. It contains the following tabs: General, Record, Playback, Query Wizard, CQL Rules, Query Plan, Trace Event, and Inject Event. The General tab is selected. It contains a Processor Type field with read-only value CQL Processor. It also contains a Create Diagnostics button.

This figure shows a confirmation dialog. The title of the dialog is Delete Group. The dialog reads: Are you sure to delete group: samplesGroup? There is a Yes and No button.

This figure shows the CQL Rules tab with rule FindCrossRatesRule selected.

This figure shows the General tab for a channel stage (with upstream Oracle CQL processor) after clicking Edit. The Selectors accordion tab is selected. It contains Processor pull-down menu with value orderProcessor selected, a list of rules for that processor, and a Selected Queries list which is empty. There is a right and left-pointing arrow button between the list of available rules and the Selected Queries list. There are buttons: Create Diagnostics, Edit, Save, Cancel, and Help. The Create Diagnostics and Edit buttons are greyed out.

This figure shows the Global Tx Protocol tab. It contains a Database Type pull-down menu with value Derby selected, a URL text entry field with value jdbc:derby:dbtest1;create=true, a Driver Name field with value org.apache.derby.jdbc.EmbeddedDriver, a User Name text entry field with value blank, a Password text entry field with value blank, and a Use XA pull-down menu with value true selected.

This figure shows the Trace Event tab. It contains a read-only Status field that reads ON and a read-only Channel Name field that reads /NonClusteredServer/cql/orderCSVAdapter/output. It contains a Start button (greyed out) and a Stop button.

This figure shows the Connection Pool tab. It contains an Initial Capacity numeric entry field with value 1, a Max Capacity numeric entry field with value 15, a Capacity Increment numeric entry field with value 1, and a Test entry field with no value.

This figure shows the Query Wizard Output editor dialog. It contains a Type area that contains a radio-button group of buttons Query and View. The Query radio-button is associated with Query Name text entry field and an Enable radio-button group of buttons true and false; the true button is selected. The View button is associated with a View Name text entry field, a View Schema text entry field, and a Project List. There is a Generated CQL Statement text entry field. There are buttons Help, Inject Rule, Replace Rule, Validate, Save, and Cancel.

This figure shows the Applications tab. It contains a table with columns Name, State, and Target. There are two rows. Row one contains Name value com.bea.wlevs.dataservices, State value Running, and Target value [AllDomainMembers]. Row two contains Name cql, State value Running, and Target value [AllDomainMembers]. Row two is selected.

This figure shows the Query Wizard tab with an existing query on the canvas. It contains pull down menu choose layout, buttons Clear Canvas, Save Query, Open Query, Zoom In, Zoom Out, Fit Content, and Toggle Constructs. It also contains a zoom slider and a Hover check box which is checked. There is an accordion menu that contains tabs: CQL Constructs, Templates, and User-defined templates. The CQL Constructs tab is selected to show the following items: Source, Pattern, Output, Select, Join, Window, Filter, Union, Intersect, Minus, IStream, DStream, and RStream. The query diagram has two Source operators 1:SSource and 3:SSource connected to Join operator 5:Join which is connected to Select operator 6:Select which is connected to Output operator 7:Output. All operators have a green check mark indicating that they are fully configured.

This figure shows the Add a Group panel. It contains fields Group Name and Description. It also contains a list of roles, each with a check box.

This figure shows the Query Wizard RSource editor dialog. It contains a Type radio button group with buttons Relation and View; the Relation button is selected. It contains pull down menu Select a source and next to it an AS text entry field. There is a Source Properties table with one column: Properties. There is a Generated CQL Statement field.

This figure shows a confirmation dialog. The title of the dialog is Alert. The dialog reads: You are about to add myRule. There is an OK and Cancel button.

This figure shows a valid connection between a Source CQL construct and a Pattern CQL construct. The target construct is highlighted by anchors at its corners and a white box in its center.

This figure shows the Coherence > Tuning tab. It contains three accordion tabs: Cache Tuning, Node Tuning, and Service Tuning. The Cache Tuning tab is selected. It contains a list of caches. The com.bea.wlevs.cluster.coherence.BroadcastDomainCache.WLEvServer-1 cache is selected. Next to the cache list are two areas: Parameters Tuning and Operations. The Parameters Tuning area contains a variety of read-only and read and writable parameters. There is a Save and Cancel button below the list of parameters. The Operations area contains one button: Reset Statistics.

This figure shows the Query Wizard Select editor dialog. It contains tabs: Project, Group, Condition, and Order. The Condition tab is selected. It contains an Expression Builder button and a Having Predicate text entry field with value lastPrice > 500. There are buttons Add and Delete. There is a Generated CQL Statement text entry field.

This figure shows the Topology tab divided into three vertical sections. The left section shows a deployment group member hierarchy. The middle section displays a graphical representation of the selected deployment group member. The right section displays the properties of the selected group member.

This figure shows the Oracle CEP Visualizer dashboard.

This figure shows the Trace Event tab. It contains a read-only Status field that reads OFF and a read-only Channel Name field that is blank. It contains a Start button and Stop button (greyed out).

This figure shows the User tab. It contains a Users table with columns Name and Description. There is a check box next to each row. It contains a Groups list and a Roles list. There are buttons: New User, Modify User, Delete User, and Change Password.

This figure shows the Channel Monitor tab. It contains list All Channels which contains FilterEuroStream, FxQuoteStream, FilterAmerStream, CrossRateStram, FilterAsiaStream, and SummaryResultsStream. It contains table Monitored Channels which has two columns: Channel and Operation. There are two rows: row one contains Channel value FilterAmerStream and the Operation column contains button Remove; row one contains Channel value CrossRateStream and the Operation column contains button Remove. There are four graphs with Time on the horizontal axis and Size on the vertical axis. The top left graph has a line for FilterAmerStream and the top right graph has a line for CrossRateStream. Below each graph is a color-coded legend that lists the name of the channel being graphed. The color next to the channel name in the legend matches the color of the graphed line.

This figure shows the Query Plan preferences dialog. It contains a Draw store/states check box. It contains a Displayed Operator Statistics Fields group of check boxes composed of: In Messages Stats, Out Messages Stats, Executions Stats, Latest In Messages Stats, and Latest Out Messages Stats. There is a In Graph pull-down menu with value Out Messages selected. There is a Threshold numeric entry field with value 500. There is an Alert Color field with a color pull-down menu with the color red selected. There is a Statistics Refresh Interval (Seconds) numeric entry field with value 5.

This figure shows the Change Password panel. It contains fields Username, Password, Confirm Password. The Username field is read-only. The Password and Confirm Password fields are blank.

This figure shows the general tab for an Oracle CEP high availability buffering output adapter stage. Fields include Name, NotificationInfo, ObjectName, Provider, RecordPlayback, and WindowLength.

This figure shows the Query Wizard Union editor dialog. It contains two areas: Source 1, Source 2, and Union Type. The Source 1 area contains a TotalFailedByNonZeroType pull-down menu and a Properties list. The Source 2 area contains a Dummy9 pull-down menu and a Properties list. There is a Generated CQL Statement text entry field.

This figure shows the properties for an Oracle Coherence cache stage. It contains a Cache Name and Type field.

This figure shows the event record schedule confirmation dialog. It reads You are about to change the playback schedule. It contains buttons: OK and Cancel.

This figure shows the Oracle CEP Visualizer Preferences panel. It contains pull-down menu Select Language, Client Idle Timeout: (Minutes) field with value 20, Max Opened Panels field with value 8, Expand All Tree Nodes at Start check box, which is unchecked, and Enable Fullscreen check box, which is checked. There is a Save and Cancel button.

This figure shows the Working Area at the bottom of a CQL Rules tab with a parameterized query selected. There is a table with columns Binding Name, 1, and 2. There are two rows. Row 1: Binding Name column value avgcount, 1 column value avg(internalPrice), and 2 column value count(*) > 0. Row 2: Binding Name column value maxcount, 1 column value max(internalPrice), and 2 column value count(*) > 0. There are buttons Delete Query, Edit Query, Add Parameter, Replace Parameter, Delete Parameter, Stop, Save, and Cancel Help. Only Add Parameter and Stop are active.

This figure shows the Query Wizard Pattern editor dialog. It contains tabs: Pattern, Define, Subset, and Measure. The Define tab is selected. It contains Object name text entry field and next to it an AS text entry field. There are buttons Expression Builder, Add, and Delete. There is an Object List and a Generated Pattern Match Statement text entry field.

This figure shows the Event Inspector tab. It contains a radio button group consisting of radio buttons Pubsub Server Name (selected) and Pubsub Server URL. There is a pull-down menu next to the Pubsub Server Name radio button with value pubsub selected.

This figure shows the Update Binding Dialog. It reads: You are about to update binding maxcount. There is an OK and Cancel button.

This figure shows the Inject Event tab. It contains a read-only Status field that reads OFF and a read-only Channel Name field that is blank. It contains a Start button and Stop button (greyed out).

This figure shows the General tab for an Oracle CQL processor stage. It contains a Processor Type field with value CQLProcessor and a Create Diagnostics button.

This figure shows the Coherence > Multi-Nodes Monitor tab. It contains four areas: Groups, Drag Property to Watch, and two graphs. The Groups area is a table with columns Node, Id, Machine Name, Process Name, Multicast Address, Multicast Port, Unicast Address, and Unicast Port. It contains one group: ocep_domain, which is expanded to show two sub-rows. Sub-row 1 has Node value Node-1, Id value 1, Machine Name value ppurich-pc, Process Name value 3720, Multicast Address value /224.3.4.1, Multicase Port value 34407, Unicast Address ppurich-pc/141.144.97.201, and Unicast Port value 8088. Sub-row 1 has Node value Node-2, Id value 2, Machine Name value ppurich-pc, Process Name value 3720, Multicast Address value /224.3.4.1, Multicase Port value 34407, Unicast Address ppruich-pc/141.144.97.201, and Unicast Port value 8088. The Drag Property to Watch area is a list of properties: Memory Available, Memory Max, Packets Sent, Packets Received, Buffer Receive Size, and Buffer Publish Size. Below the Drag Property to Watch list are buttons Add to Left and Add to Right. There are two graphs. The property Packets Received has been dragged from the Drag Property to Watch area list onto the left-hand graph. The property Packets Sent has been dragged from the Drag Property to Watch area list onto the right-hand graph. Below each graph is a legend that distinguishes each selected node by color in the graph.

This figure shows the Query Plan tab with stages that have exceeded their configured threshold marked in red.

This figure shows the Data Source tab. It contains a Name field with value myDatasource, a JNDI Name field with value myds, and a Global Tx Protocol pull-down menu with value TwoPhaseCommit selected

This figure shows the Add a User panel. It contains fields Username, Password, Confirm Password, and Description. It also contains a list of groups, each with a check box.

This figure shows the Group tab. It contains a table with columns Group and Description. There is a check box next to each row in the table. There is a list of Roles. There are buttons: New Group, Modify Group, and Delete Group.

This figure shows a confirmation dialog. The title of the dialog is Alert. The dialog reads: You are about to replace myRule. There is an OK and Cancel button.

This figure shows the Role tab. It contains a Roles table and a Resources table. The Role table contains columns Role, Type, Application. There is a radio button to the left of each row that you are allowed to delete. The Roles table contains one such row: Role value fxRole, Type value Application Role, and Application value fx. The radio button for this row is selected. The Resources table contains two columns: ID and Policy. The Resources table contains one row: ID value 0 and Policy value type=<application>, action=access, server=, app=fx.

This figure shows the Query Wizard Cache-Table editor dialog. It contains pull down menu Select a source and next to it an AS text entry field. There is a Source Properties table with one column: Properties. There is a Generated CQL Statement field.

This figure shows the Review Deployment Information screen. It contains a Deployed File field with value com.bea.wlevs.example.helloworld_3.0.0.0.jar, an Application Name field with value helloworld, and a Target Group to Deploy field with value testgroup. There is an OK, Back, and Cancel button.

This figure shows the Global Tx Protocol tab. It contains a Database Type pull-down menu with value Derby selected, a URL text entry field with value jdbc:derby:dbtest1;create=true, a Driver Name field with value org.apache.derby.jdbc.EmbeddedDriver, a User Name text entry field with value blank, a Password text entry field with value blank, and a Use XA pull-down menu with value true selected

This figure shows the Review Deployment Information screen. It contains a Deployed File field with value com.bea.wlevs.example.recplay_3.0.0.0.jar, an Application Name field with value recplay, and a Target Group to Deploy field with default value (No group is specified, will deploy to NonClusteredServer). There is an OK, Back, and Cancel button.

This figure shows the Query Wizard Expression Builder dialog. It contains an Expression Builder text entry field with a Redo, Undo, and Delete button. There are four areas: Variables, Functions, Operands, and Function Description. The Variables area contains a pull-down menu and a Properties list. The Functions area contains a pull-down menu and Functions list. The Operands area contains a list of operands. The Function Description area contains a text entry field that provides the available signatures for the currently selected function.

This figure shows the Coherence > Tuning tab. It contains three accordion tabs: Cache Tuning, Node Tuning, and Service Tuning. The Node Tuning tab is selected. It contains a list of nodes. The Node-1 node is selected. Next to the cache list are two areas: Parameters Tuning and Operations. The Parameters Tuning area contains a variety of read-only and read and writable parameters. There is a Save and Cancel button below the list of parameters. The Operations area contains a button for each available operation: ResetStatistics, Shutdown, EnsureCacheService, EnsureInvocationService. The EnsureCacheService and EnsureInvocationService each have a text field.

This figure shows the Query Wizard Window editor dialog. It contains a list of properties and a Partition List text entry field. There are two areas: Type and Slide. The Type area contains a radio-button group of buttons Now, Time, Row Partition, and Unbounded; the Time button is selected. Below that is a Row Based check box and a text entry field and a Time Based check box and a text entry field. The Row Based check box and text entry field is greyed out. Below the Time Based check box and a text entry field is a radio-button group of buttons ns, micros, ms, sec, min, hour, and day; the sec button is selected. This radio-button group is greyed out. The Slide area contains a Row Based check box and text entry field and a Time Based check box and text entry field. Both are unchecked and greyed out. Below the Time Based check box and text entry field is a radio-button group of buttons ns, micros, ms, sec, min, hour, and day; the sec button is selected. There is a Generated CQL Statement text entry field.

This figure shows the General tab for an Oracle CEP high availability input adapter stage. Fields are Batch Size, Heartbeat, HeartbeatUnits, Name, NotificationInfo, ObjectName, Provider, and RecordPlayback.

This figure shows the Coherence > Node Detail View tab. It contains a Nodes pull-down menu with Node-2 selected. The Nodes Properties area is a table with columns Property and Value: the properties for Node-2 are shown. There are four graphs, one for each of the properties: Memory Available, Memory Max, Packets Sent, and Packets Received.

This figure shows the General tab for an EPL processor stage. It contains a Processor Type field with value EPLProcessor, a Database Reference table with columns Database Name and Data Source, and a Create Diagnostics button.

This figure shows the trace event stop confirmation dialog. It reads You are about to stop event tracing immediately. It contains buttons: OK and Cancel.

This figure shows the Playback tab. It contains the following sections: Playback Current Status, Playback Parameters, Event Type List, Playback Filter Entry, Playback Schedule Entry, Change Playback Filter Parameters, and Change Playback Schedule Parameters. The Playback Parameters area contains a DataSet Name text entry field and a Provider Name pull-down menu. The Event Type List contains a Selected event list and an Available event list and a left-pointing arrow and right-point arrow button between the two lists. The Playback Filter Entry area contains a table with columns Filter Start Time and Filter End Time. The Playback Schedule Entry area contains a table with columns Schedule Start Time, Schedule End Time, Speed, and Repeat. The Change Playback Filter Parameters area contains text entry fields Start Recording and Stop Recording. Next to each field is a Calendar button and a time entry menu with hour, minute, and seconds fields. This area also contains a Clear Schedule button. The Change Playback Schedule Parameters area contains text entry fields Start Recording and Stop Recording. Next to each field is a Calendar button and a time entry menu with hour, minute, and seconds fields. This area also contains a a Speed numeric entry field and a Repeat pull-down menu (with value false selected) and a Clear Schedule button. At the bottom of the tab are buttons: Add, Edit, Start, Stop, Save, and Cancel. Only the Start, Save, and Cancel buttons are active.

This figure shows a confirmation dialog. The title of the dialog is Information. The dialog reads: The query has been saved successfully! There is an OK button.

This figure shows the Event Repository panel. It contains a table with columns Provider Name, Initial Timeout, and Data Source Name.

This figure shows the EPL rules tab. It contains a table with columns RuleID and rule. There are two rows: row one with RuleID value defaultRule and rule value select * from DSMonitorEvent retain 1 event where metric > 10000 and row tow with RuleID value myRule and rule value select * from DSMonitorEvent retain 2 event where metric > 5000. Row two is selected. There is a RuleID field with value myRule, a Rule field with value select * from DSMonitorEvent retain 2 event where metric > 5000 and a Parameters table with one column: Name. There are no rows in the Parameters table. There are Create Rule, Delete All Rules, Delete Rule, Replace Rule, and Cancel buttons. The Create Rule and Delete All Rules are greyed out.

This figure shows the Query Wizard IStream editor dialog. There is a Generated CQL Statement text entry field.

This figure shows the Oracle CEP Visualizer logon screen. It contains a User Id field and Password Field and a Logon button.

This figure shows the Oracle CEP Visualizer Stream Visualizer. It contains pull down menu CEP Server Name with value NonClusteredServer selected, text entry field Pub/Sub Server URL with value http://localhost:9002/pubsub, button Initialize Client, and button Disconnect (greyed-out). There are two tabs: Publish and Subscribe. The Publish tab is selected. This tab contains a table with two columns: Column one contains a radio button group with one radio button per row; Column two is named Channel Name. There are three rows: Row one has radio button unchecked and Channel Name value /evsmonitor; Row two has radio button unchecked and Channel Name value /evsalert; and Row three has radio button unchecked and Channel Name value /evsdomainchange. Below the tab is pull down menu Event Type with CrossRateEvent selected. Below that is radio button group Input Method with radio buttons Jason String (selected) and Form Based Event. Below that is a text display area (which is empty). Below that is button Publish.

This figure shows the Revisions tab. It contains a table with columns: Rule, Action, User, Date, Change Record, and Description. The Rule column contains rows with values summarizeResults and FindCrossRates. The FindCrossRates entry is expanded to show the number of revisions, the type of last action made, the user, the date of the last action, the change record number of the last action, and a system-generated description of the last action. Below the table are date fields Start Date and End Date. There is a date chooser button next to each field. Below this are buttons Refresh, Undo (greyed out), Delete, and Help.

This figure shows the Query Wizard Pattern editor dialog. It contains tabs: Pattern, Define, Subset, and Measure. The Pattern tab is selected. It contains a Pattern Expression text entry field with value (A B* C). It contains a Duration text entry field that contains MULTIPLES OF 10. It contains a Partition By list that contains value symbol, lastPrice. It contains a lastPrice pull-down menu and next to an Add button and an Undo button. There is a Pattern Alias text entry field and an All Matches check box (which is unchecked). There is a Generated Pattern Match Statement text entry field.

This figure shows the New Latency Profile dialog Throughput tab. It contains check box Average Throughput Metric, which is checked. It contains pull-down menu Stage Name and next to it a radio button group of Entry and Exit; the Exit button is selected. It contains numeric entry field Throughput Interval and next to it a radio button group of Second, Millisecond, and Microsecond; the Second button is selected. It contains numeric entry field Average Interval and next to it a radio button group of Second, Millisecond, and Microsecond; the Millisecond button is selected. There are Save and Cancel buttons.

This figure shows the Libraries tab. It contains a table with columns Name and State. This table is empty.

This figure shows the inject event confirmation dialog. It reads You are about to start event injection immediately. It contains buttons: OK and Cancel.

This figure shows the properties for an Oracle CEP local cache stage. It contains a Cache Name with value symbolsCache, a Type field with value CacheStage, a Max Size field with value 64 an Idle Time field with value 0, a Write Policy pull-down menu with item WriteNone selected, an Eviction Policy pull-down menu with value LFU selected, and a Time To Live field with value 0. There are buttons: Create Diagnostics, Edit, Save, and Cancel. The Create Diagnostics and Edit buttons are greyed out.

This figure shows the Working Area at the bottom of a CQL Rules tab with a parameterized query selected. There is a table with columns Binding Name, 1, and 2. There are two rows. Row 1: Binding Name column value avgcount, 1 column value avg(internalPrice), and 2 column value count(*) > 0. Row 2: Binding Name column value maxcount, 1 column value max(internalPrice), and 2 column value count(*) > 0. There is a Binding Name field with value maxcount and a Binding Values field with value max(internalPrice), count(*) > 0. Only the Binding Values field is editable. There are buttons Delete Query, Edit Query, Add Parameter, Replace Parameter, Delete Parameter, Stop, Save, and Cancel. Only Save and Cancel are active.

This figure shows the Record tab. It contains the following sections: Recording Current Status, Recording Parameters, Event Type List, Record Schedule Entry, and Change Recording Schedule. The Recording Parameters area contains a DataSet Name text entry field and a Provider Name pull-down menu. The Event Type List contains a Selected event list and an Available event list and a left-pointing arrow and right-point arrow button between the two lists. The Recording Schedule Entry area contains a table with columns Start Time and End Time. The Change Recording Schedule contains text entry fields Start Recording and Stop Recording. Next to each field is a Calendar button and a time entry menu with hour, minute, and seconds fields. This area also contains a Clear Schedule button. At the bottom of the tab are buttons: Add, Edit, Start, Stop, Save, and Cancel. Only the Save and Cancel buttons are active.

This figure shows the Query Wizard Join editor dialog. It contains three areas: Source 1, Source 2, and Join Type. The Source 1 area contains an S1 pull-down menu and a Properties list. The Source 2 area contains a stockCache pull-down menu and a Properties list. The Join Type area contains a radio button group with buttons: No outer join, Left outer join, and Right outer join. The No outer join button is selected. There is a plus sign button next to the Join Type radio buttons. There is a Join Predicate text entry field with an Expression Builder button. The Join Predicate text entry field contains S1.symbol = stockCache.symbol. There is a Generated Join Statement text entry field. that contains select * from S1 [now], stockCache WHERE S1.symbol = stockCache.symbol. There are buttons Help, Change Join, Undo Join, Validate, Save, and Cancel. The Undo Join button is greyed out.

This figure shows the tools along the top of the Query Wizard canvas. From left to right they are: Choose Layout pull-down menu, Clear Canvas, Save Query, Load Query, Hover check box, Zoom In, Zoom Out, Fit Content, Toggle Constructs, and Zoom.

This figure shows the Cluster > Topology tab. It contains four areas: Overview, Group List, Layout, and Properties Table. The Group List contains a list of all cluster groups: WLEvServer-1 (containing WLEvServer-1), WLEvServer-2 (containing WLEvServer-2), testgroup (containing WLEvServer-1 and WLEvServer-2), and AllDomainMembers (containing WLEvServer-1 and WLEvServer-2). The Layout contains a graphical depiction of each the groups in the Group List. The Properties Table contains two columns: Property and Value. It lists the properties of the selected group or server instance.

This figure shows the Query Wizard Select editor dialog. It contains tabs: Project, Group, Condition, and Order. The Order tab is selected. It contains a FxQuoteStream pull-down menu and an Add button. Below that is a Properties list. It contains an Ordering properties area that contains a Delete button and a Select List. There is a Generated CQL Statement text entry field. There are buttons Add and Delete. There is a Generated CQL Statement text entry field.

This figure shows the EPL rules tab. It contains a table with columns RuleID and rule. There is one row with RuleID value defaultRule and rule value select * from DSMonitorEvent retain 1 event where metric > 10000. There is a RuleID field with value blank, a Rule field with value blank and a Parameters table with one column: Name. There are no rows in the Parameters table. There are Create Rule, Delete All Rules, Delete Rule, Replace Rule, and Cancel buttons. The Delete Rule and Replace Rule buttons are greyed out.

This figure shows the HTTP publish-subscribe server properties dialog. It contains fields: Server Name, Server Path, Transport, TimeOut, Client Offline TimeOut, Publish Without Connect Allowed, Channel Pattern, Message count, and Subscriber count. There is a table with columns Channels and Status. It contains three rows: row1 has Channels value /evsmonitor and Status value static; row2 has Channels value /evsalert and Status value static; and row3 has Channels value /evsdomainchange and Status value static. There is a Publish Roles list and a Subscribe Roles list.

This figure shows the Oracle CEP Visualizer dashboard with two diagnostic profiles in the table at the bottom of the dashboard. The first row has Profile Name value Mydiagprofile, Application value fx, Stage value FxQuoteStream, Throughput value NaN, Average Latency value Nan, and Max Latency value NaN. The Operation column value is a Remove button. The second row has Profile Name value MonEventDiag, Application value com.bea.welvs.dataservices, Stage value MonitorEventStream, Throughput value NaN, Average Latency value Nan, and Max Latency value NaN. The Operation column value is a Remove button

This figure shows a confirmation dialog. The title of the dialog is Delete User. The dialog reads: Are you sure to delete user: scott? There is a Yes and No button.

This figure shows the DataSource tab. It contains a list of datasources and the following buttons: Add, Edit, Delete, and Refresh.

This figure shows the Extension Libraries tab. It contains a table with columns Name and State. This table is empty.

This figure shows the Query Wizard RStream editor dialog. There is a Generated CQL Statement text entry field

This figure shows the Query Wizard Union editor dialog. It contains three areas: Source 1, Source 2, and Union Type. The Source 1 area contains a TotalFailedByNonZeroType pull-down menu and a Properties list. The Source 2 area contains a Dummy9 pull-down menu and a Properties list. The Union Type area contains a radio-button group with buttons Union and Union All; the Union All button is selected. There is a Generated CQL Statement text entry field.

This figure shows the Query Wizard DStream editor dialog. There is a Generated CQL Statement text entry field

This figure shows the Working Area at the bottom of a CQL Rules tab with a parameterized query selected. There is a table with columns Binding Name, 1, and 2. There are two rows. Row 1: Binding Name column value avgcount, 1 column value avg(internalPrice), and 2 column value count(*) > 0. Row 2: Binding Name column value maxcount, 1 column value max(internalPrice), and 2 column value count(*) > 0. The maxcount row is selected. There are buttons Delete Query, Edit Query, Add Parameter, Replace Parameter, Delete Parameter, Stop, Save, and Cancel. Add Parameter, Replace Parameter, Delete Parameter, and Stop are active.

This figure shows the Group Member tab, which lists group information in a table. Column names are Group, Server, Host Name, Listen Port, and Source Listen Port.

This figure shows the All Saved Queries dialog. It contains a Query Id field and a Query String field. The insertion bar is in the Query Id field and myQuery has been entered. The Query String reads SELECT * FROM FxQuoteStream.

This figure shows the Query Plan tab with an Output selected in the Data table. All the stages that depend on the selected Output are selected in the Query Plan diagram.

This figure shows the General tab for a POJO stage. It contains a Name field.

This figure shows the Add Application Role panel. It contains fields Role Name and Application Name. The Application Name field is a radio button groups made up of all the currently running applications. This figure shows two applications: fx and com.bea.wlevs.dataservices. The fx radio button is selected.

This figure shows a diagnostic profile named MydDiagprofile in the left domain tree. The following nodes are expanded: NonClusteredServer, Applications, fx, Stages, fxMarketAmer. The MydDiagprofile file appears under fxMarketAmer.

This figure shows the General tab for a JMS adapter. There is a Create Diagnostic button.

This figure shows the General tab for a channel stage after clicking Edit. It contains fields Channel Type with value Stream, Max Size with value 1024, Max Threads with value 1, Event Type Name with value DataStockTick, TimeStamp Type with value System Timestamp, and Automatic Heartbeat Interval with a null value. There are buttons: Create Diagnostics, Edit, Save, Cancel, and Help. The Create Diagnostics and Edit buttons are greyed out.

This figure shows the Install Application Screen. It contains an Upload Files table with columns Application Name and Size (k). There is a Remove file after deploy check box which is unchecked. There is a row with Application Name value com.bea.wlevs.example.recplay_3.0.0.0.jar and Size (k) value 8. This row is selected. There is a Deployed File field with value com.bea.wlevs.example.recplay_3.0.0.0.jar and an Application Name field with value recplay. There is a Select Target Group to Deploy field and next to it a Clear Group button. There is a table at the bottom of this screen with columns Group, Server, Host Name, Listen Port, and Secure Listen Port. There is one row in this table with Group value AllDomainMembers.

This figure shows a confirmation dialog. The title of the dialog is Alert. The dialog reads: You are about to remove all rules for processor MonitorProcessor - com.bea.wlevs.dataservices@NonClusteredServer. There is an OK and Cancel button.

This figure shows the General tab for an Oracle CEP high availability broadcast output adapter stage. Fields include Name, NotificationInfo, ObjectName, Provider, RecordPlayback, TrimmingInterval, KeyProperties, and Monotonic.

This figure shows a confirmation dialog. The title of the dialog is Information. The dialog reads: You are about to add query myQuery. There is an OK button.

This figure shows the Coherence > Tuning tab. It contains three accordion tabs: Cache Tuning, Node Tuning, and Service Tuning. The Service Tuning tab is selected. It contains a list of services. The com.bea.wlevs.cluster.coherence.LifecycleInvocationService service is selected. Next to the cache list are two areas: Parameters Tuning and Operations. The Parameters Tuning area contains a variety of read-only and read and writable parameters. There is a Save and Cancel button below the list of parameters. The Operations area contains a button for each available operation: Start, Stop, Shutdown, resetStatistics.

This figure shows the Query Wizard Select editor dialog. It contains tabs: Project, Group, Condition, and Order. The Group tab is selected. It contains a FxQuoteStream pull-down menu and an Add button. Below that is a Properties list. It contains a Grouping properties area that contains a Delete button and a Select List. There is a Generated CQL Statement text entry field.

This figure shows the Group tab. It contains a Groups and Roles table. The Groups table contains columns Group and Description. There is a check box to the left of each row. The Groups table contains a row with Group value samplesGroups and Description value blank. The check box for this row is checked. The Roles table contains one column: Roles. The Roles table contains one row with Role value ApplicationAdmin.

This figure shows the JMX tab. It contains a JMX table with columns Name and Value.

This figure shows the Logging Services tab. It contains a Logging Service Name text entry field with value myLogService, Logger Severity pull-down menu with value Notice selected, Limited By Number Of Files pull-down menu with value False selected, Rotation Type pull-down menu with value None selected, Rotation Size numeric entry field with value 5000, a Base Log File Name text entry field with value server.log, a Rotate Log On Startup pull-down menu with value True selected, and a Log File Severity pull-down menu with value Trace selected.

This figure shows the trace event confirmation dialog. It reads You are about to start event tracing immediately. It contains buttons: OK and Cancel.

This figure shows a confirmation dialog. The title of the dialog is Alert. The dialog reads: You are about to remove myRule. There is an OK and Cancel button.

This figure shows the CQL Rules tab filtered by View. It contains a table with columns Rule ID, Rule, Type, and Running. The selected row has Rule ID value UsdToEur, Rule value select lastPrice, symbol from FxQuoteStream [range 1] where symbol="USDEUR", Type value VIEW, and Running value true. There is a read-only View ID field with value UsdToEur, an editable View Schema field with value blank, an editable View field with value select lastPrice, symbol from FxQuoteStream [range 1] where symbol="USDEUR". There is an Enable radio button group with buttons true and false. This radio button group is greyed out. There are buttons Create View, Delete All Views, Delete View, Replace View, Start Rule, Cancel, and Query Wizard. The Create View, Delate All Views, and Start Rule buttons are greyed out.

This figure shows the General tab for a high availability correlating output adapter stage. The fields are FailOverDelay, Name, NotificationInfo, ObjectName, Provider, RecordPlayback, FailOverDelay, and CorrelatedSource.

This figure shows the Connection Pool tab. It contains an Initial Capacity numeric entry field with value 1, a Max Capacity numeric entry field with value 15, a Capacity Increment numeric entry field with value 1, and a Test entry field with no value.

This figure shows the Query Wizard SSource editor dialog. It contains a Type radio button group with buttons Stream and View; the Relation button is selected. It contains pull down menu Select a source and next to it an AS text entry field. There is a Source Properties table with one column: Properties. There is a Generated CQL Statement field.

This figure shows the Oracle CEP Visualizer main window. It includes a top pane, left pane, and right pane. The top pane includes buttons for: Home, Security, Dashboard, ViewStream, Logout, Full Screen, Preferences, and Help. The left pane lists the items that the WLEventServerDomain contains and lists currently open items. The right pane contains a list of Management Events, two performance monitoring graphs, and a table of diagnostic profiles.

This figure shows the toolbar along the top of the cluster Topology canvas. From left to right, it contains: Layout pull-down menu, Zoom slider, Fit Content button, Zoom In and Zoom Out buttons, Toggle Overview, and Toggle Overview.

This figure shows the Oracle CEP Visualizer Stream Visualizer. It contains pull down menu CEP Server Name with value NonClusteredServer selected, pull down menu PubSub Server Name with value pubsub, text entry field Pub/Sub Server URL with value http://localhost:9002/pubsub, button Initialize Client, and button Disconnect (greyed-out). There are two tabs: Publish and Subscribe. The Subscribe tab is selected. This tab contains a table with two columns: Column one contains a radio button group with one radio button per row; Column two is named Channel Name. There are three rows: Row one has radio button unchecked and Channel Name value /evsmonitor; Row two has radio button unchecked and Channel Name value /evsalert; and Row three has radio button unchecked and Channel Name value /evsdomainchange. Below that is text display area Output messages from subscription (which is empty). Below that are buttons Subscribe and Clean Text.

This figure shows the General tab for a an event bean stage. It contains a Class Name field with value com.bea.wlevs.example.recplay.RecplayEventSink and a Create Diagnostics button.

This figure shows the Oracle CQL Query Wizard tab. It contains pull down menu choose layout, buttons Clear Canvas, Save Query, Open Query, Zoom In, Zoom Out, Fit Content, and Toggle Constructs. It also contains a zoom slider and a Hover check box which is unchecked. There is an accordion menu that contains the following tabs: CQL Constructs, Templates, and User-defined templates. The CQL Constructs tab is selected to show the following items: SSource, RSource, Pattern, Output, Select, Join, Window, Filter, Union, Intersect, Minus, IStream, DStream, and RStream.

This figure shows the General tab for a channel stage after clicking Edit. It contains fields Max Size with value 1024, Max Threads with value 1, Event Type Name with value OrderTracking, TimeStamp Type with value System Timestamp, and Automatic Heartbeat Interval with a null value. There are buttons: Create Diagnostics, Edit, Save, Cancel, and Help. The Create Diagnostics and Edit buttons are greyed out.

This figure shows the CQL Rules tab filtered by View. It contains a table with columns Rule ID, Rule, Type, and Running. The selected row has Rule ID value EurToGbpPre, Rule value select avg(lastPrice) as price, "EUR" as fromRate, "GBP" as toRate from EurToGbp where lastPrice < 1.5 and lastPrice > 0.5, Type value VIEW, and Running value true. There is a read-only View ID field with value EurToGbpPre, an editable View Schema field with value fromRate, price, toRate, an editable View field with value select avg(lastPrice) as price, "EUR" as fromRate, "GBP" as toRate from EurToGbp where lastPrice < 1.5 and lastPrice > 0.5. There is an Enable radio button group with buttons true and false. This radio button group is greyed out. There are buttons Add View, Delete All Views, Delete View, Edit View, Start, Query Wizard, Save, Cancel, Help. The Add View, Delete All Views, Delete View, Edit View, Start, and Query Wizard buttons are greyed out.

This figure shows the CQL Rules tab with a parameterized query selected. There is a radio button group composed of buttons View, Query, and All Rules. The Query button is selected. There is a table with columns Rule ID, Rule, Type, and Running. Below the table there is a Query ID text field, a Query text field, and an Enable radio button group composed of buttons true and false; true is selected. There are buttons Add Parameter, Replace Parameter, Delete Parameter, Stop, Save, and Cancel. Only Add Parameter and Stop are active.

This figure shows the history tab. It contains two tabs: Revisions and Changes.

This figure shows the General tab for an adapter stage. It contains the following fields: Channel, EventType, Name, Notification Info, ObjectName, Provider, RecordPlayback, ServerContextPath, and ServerURL. There is a Create Diagnostic button.

This figure shows the All Saved Queries dialog. It contains a table with columns QueryId and QueryString. There is one row with QueryId value myQuery and QueryString value SELECT * FROM FxQuoteStream. There is a Query Id field and a Query String field. The Query Id field contains value myQuery. The Query String reads SELECT * FROM FxQuoteStream.

This figure shows the New Latency Profile dialog Latency tab. It contains two areas: Diagnostic Information and Path Information. The Diagnostic Information area contains check boxes Max Latency Metric, and Average Latency Metric; both are checked. There is an Average Collection Interval numeric entry field and next to it, a radio button group of Second and Millisecond; the Second button is selected. There is a Threshold numeric entry field and next to it, a radio button group of Second, Millisecond, and Microsecond; the Millisecond button is selected. The Path Information area contains pull-down menu Start Stage Name and next to it, a radio button group of Entry and Exit; the Entry button is selected. It also contains pull-down menu End Stage Name and next to it, a radio button group of Entry and Exit; the Exit button is selected. There are Save and Cancel buttons.

This figure shows the Processor panel for an EPL processor. It contains the following tabs: General, Record, Playback, and Rules. The General tab is selected. It contains a Processor Type field with read-only value EPL Processor. It also contains a Database References table with columns Database Name and Data Source. Below the Database References table is a Create Diagnostics button.

This figure shows the inject event confirmation dialog. It reads You are about to stop event injection immediately. It contains buttons: OK and Cancel.

This figure shows the Event Processing Network tab of a deployed application. It contains an EPN diagram. Above the EPN diagram, it contains a miniature view of the EPN, a Layout pull-down menu with default selection hierarchic, a Zoom slider, a Fit Content button, an Actual Size button, a Zoom Out button, and a Zoom In button.

This figure shows the Cluster > Group Member tab. It contains a table with columns Group, Server, Host Name, Listen Port, and Secure Listen Port. The Group entry for testgroup is expanded to show two sub-rows. Sub-row 1 with Server value WLEServer-1, Host Name value localhost, Listen Port value 8003, and Secure Listen Port value 8004. Sub-row 2 with Server value WLEServer-2, Host Name value localhost, Listen Port value 9002, and Secure Listen Port value 9003

This figure shows the New Latency Profile dialog Profile Information tab. It contains a Profile Name text field and a State radio button group with radio buttons On and Off. The On button is selected. There are Save and Cancel buttons.

This figure shows the Inject Event tab. It contains a read-only Status field that reads ON and a read-only Channel Name field that reads TBD. It contains a Start button (greyed out) and Stop button.

This figure shows the Query Wizard Filter editor dialog. It contains a Filter Predicate text entry field and an Expression Builder button. There is a Generated Filter Statement text entry field.

This figure shows the Confirmation dialog for deleting a component log configuration. It reads: Are you sure you want to remove the log setting for testComponent? It contains a Yes and No button.

This figure shows the Component Log Setting tab. It contains a table with columns Component and Level. There are multiple rows with listed components, such as Spring, Recplay, Stream, and Channel, all with the Level value of Notice. There is a Name text entry field and a Level pull-down menu. There are Add, Edit, Delete, Save, and Cancel buttons.

This figure shows the User tab. It contains a Users table, Groups table, and Role table. The Users table contains columns Name and Description. There is a check box to the left of each row. The Users table contains two rows: row one contains Name value scott and Description value "A new deployment user"; row two contains Name value wlevs and Description value blank. The check box for the first row is checked. The Groups table contains one column: Group. The Groups table contains one row with Group value wlevsDeployer. The Roles table contains one column: Roles. The Roles table contains one row with Roles value Deployer.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2010, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

Hazardous Applications Notice

This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Trademark Notice

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Third-Party Content, Products, and Services Disclaimer

This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.