Filter
Top Products
Situation Explanation/Resolution
While running Oracle
11g in non-RAC or
RAC environment,
you might encounter
index hot spots,
which may cause
performance
degradation.
It is recommended that you create the following indexes in a
global partition to improve system performance:
Note: If you have not deployed Sterling File Gateway in your
environment, you can ignore the indexes starting with the name
FG.
v PERF_IDX_1 : WORKFLOW_CONTEXT (BASIC_STATUS,
START_TIME, WORKFLOW_ID, WFD_ID)
v PERF_IDX_2 : WORKFLOW_CONTEXT (START_TIME,
WORKFLOW_ID, STEP_ID, ACTIVITYINFO_ID, WFD_ID)
v PERF_IDX_3 : WORKFLOW_CONTEXT (WFD_ID,
START_TIME, WORKFLOW_ID, STEP_ID, ACTIVITYINFO_ID)
v SCI_IDX_125 : WORKFLOW_CONTEXT (WFD_ID,
WFD_VERSION)
v SCI_IDX_195 : WORKFLOW_CONTEXT (END_TIME, WFD_ID,
WFD_VERSION, STEP_ID)
v SCI_IDX_3 : WORKFLOW_CONTEXT (WORKFLOW_ID)
v PERF_IDX_4 : WORKFLOW_CONTEXT (WORKFLOW_ID,
START_TIME, STEP_ID, ACTIVITYINFO_ID, WFD_ID)
v SCI_IDX_120 : WORKFLOW_CONTEXT (WORKFLOW_ID,
BASIC_STATUS, NEXT_AI_ID, ACTIVITYINFO_ID,
ARCHIVE_FLAG)
v SCI_IDX_109 : WORKFLOW_CONTEXT" (WORKFLOW_ID,
BRANCH_ID)PERF_IDX_5 : EVENT (EXPIRES_AT)
v SCI_IDX_56_2 : TRANS_DATA (WF_ID)
v SCI_IDX_DMI17 : ACT_SESSION (CON_END_TIME,
PROTOCOL, SESSION_ID, ADAPTER_NAME)
v FG_RTE_MODTS_IDX : FG_ROUTE_EVENT (MODIFYTS)
v FG_TEA_EVTKEY_IDX : FG_EVENTATTR (EVENT_KEY)
v FG_RE_DF_IDX : FG_ROUTE_EVENT (DATA_FLOW_ID)
Note: If there are any changes in a patch for the partitioned
indexes, the patch installation will drop the index and create a
non-partitioned index, treating it as a normal index. You should
analyze the indexdrop SQL's and recreate the partitioned indexes
again if they have changed.
The following example explains the procedure to drop an index
and create the same in a global partition:
1. To drop index PERF_IDX_1, run the following sql command:
drop index PERF_IDX_1 ;
2. Create the PERF_IDX_1 in global partitions by running the
following command:
create index PERF_IDX_1 on WORKFLOW_CONTEXT
(BASIC_STATUS,START_TIME,WORKFLOW_ID,WFD_ID) global
partition by hash
(BASIC_STATUS,START_TIME,WORKFLOW_ID,WFD_ID) partitions
16 store in (SI);
240 Sterling B2B Integrator: Performance Management