A Wetpaint Site

HOW TO improve performance of workflow by partitioning

Platform:

Oracle

App:

Tool:

Oracle Workflow

DB Ver:

9.2

App Ver:

Tool Ver:

2.6.2

Revision Date:

17-Feb-2006

Keywords:

HOWTO, PERFORMANCE, WORKFLOW

Goal

To improve performance of workflow by partitioning

Facts

Solution

Run the scriptwfupart.sql(orwfupartb.sqlfor Oracle Applications) to automatically partition the following tables:

Table Index
WF_ITEM_ACTIVITY_STATUSES WF_ITEM_ACTIVITY_STATUSES_PK
WF_ITEM_ACTIVITY_STATUSES_N1
WF_ITEM_ACTIVITY_STATUSES_N2
WF_ITEM_ACTIVITY_STATUSES_H WF_ITEM_ACTIVITY_STATUSES_H_N1
WF_ITEM_ACTIVITY_STATUSES_H_N2
WF_ITEM_ATTRIBUTE_VALUES WF_ITEM_ATTRIBUTE_VALUES_PK
WF_ITEMS WF_ITEMS_PK WF_ITEMS_N1
WF_ITEMS_N2
WF_ITEMS_N3

This script is located in $FND_TOP/admin/sql

consultium	Latest page update: made by consultium , Oct 7 2009, 4:13 AM EDT (about this update About This Update Edited by consultium view changes - complete history)
	Keyword tags: HOWTO PERFORMANCE WORKFLOW More Info: links to this page

Threads for this page

Post a new thread

There are no threads for this page. Be the first to start a new thread.

Related Content

(what's this?)

OLAP option - DBA Sample Scripts	HOW TO format a number in to words	HOW TO find if any predicates are being added to your SQL via VPD
HOW TO prevent TO NUMBER erroring a query	HOW TO fix Autotrace to work correctly in SQL*Plus	HOW TO set up AUTOTRACE
HOW TO format the output of DBMS_OUTPUT	HOW TO preserve leading whitespace in DBMS OUTPUT	HOW TO change the default path for SQL*Plus
HOW TO trace a 3rd party session	Installing Oracle 10gR2 on RHEL AS4 update 4	Major Steps for installing OWB 10gR2 & workflow in Window environment

JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then try again.

Home