Cisco Cisco Process Orchestrator 3.1 User Guide

Use the following process to monitor and manage Oracle database instances. 

Create an Oracle database target (see 

Define an Oracle database activity. 

In the Process Editor Toolbox, choose Database > Oracle > [Oracle Database Activity], then drag 
and drop the activity onto the Workflow pane.

Click the General tab and enter the required information.

Click the [Activity-Specific] tabs to define the properties specific to the activity. 

Enter the information in the remaining tabs as necessary, then click Save to complete the activity 
definition.

For details about a specific activity, see 

.

View the activity results (see 

).

List Oracle Running SQL 
Queries

Use this activity to query the running SQL queries performed in the Oracle 
database.

Specify the information that describes the query results, including:

Row Limit—The appropriate number rows to limit for the query and 
returned data (default=50).

Oracle Database Lock

Use this activity to query the locks performed in the Oracle database.

For more information, see 

Oracle Table Space

Use this activity to query the amount of table space for an Oracle database.

For more information, see 

.

Select from Oracle

Use this activity to query data from the Oracle database using SQL 
command lines. 

For more information, see 

.

Select from Oracle 
Reporting Database

Use this activity to query data from a report database.

For more information, see 

.

Update Oracle

Use this activity to update column information in the Oracle database 
using SQL command lines.

Enter the command text for the selected database. For example, this query 
updates columns in a table:

Update mytable set column1 = 'newvalue' where column2 = 'zzz'