Impact of Reducing the Column Size for XREF_DATA Table (Doc ID 1930039.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Goal


Impact of reducing the column size for XREF_DATA table

We are seeing high number of transactions related to Xref_Data table queries and these queries are taking most of the DB execution time.

We have both SOA tables and xref_data table on the same DB.

We have a large number of records in this table and for some of the columns the size has been defined as 2000 characters and we will not have such a big values.

Can we decrease the size of these columns and what will be the impact on the xref_data table lookup function.


CREATE TABLE XREF_DATA
(
  XREF_TABLE_NAME VARCHAR2(2000) NOT NULL,
  XREF_COLUMN_NAME VARCHAR2(2000) NOT NULL,
  ROW_NUMBER VARCHAR2(48) NOT NULL,
  VALUE VARCHAR2(2000) NOT NULL,
  IS_DELETED VARCHAR2(1) NOT NULL,
  LAST_MODIFIED TIMESTAMP(6) NOT NULL
)
 

Solution

Sign In with your My Oracle Support account

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

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