Impact of Reducing the Column Size for XREF_DATA Table
Last updated on NOVEMBER 03, 2016
Applies to:Oracle SOA Suite - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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
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