MAX_STRING_SIZE – stretching the dictionary

Posted by

This post cycles back too some other historical posts of mine related to max_string_size and the fact that the data dictionary uses LONG data type columns because of historical reasons related to backward compatibility. Most of us probably have existing databases that have gone through the standard upgrade through various versions of the Oracle Database, and as such, all of our existing database have a max_string_size of STANDARD. Thus to convert to the larger string size, we start by setting max_string_size to EXTENDED, run the appropriate scripts after shutting out database down and re-opening it in upgrade mode, setting the appropriate initialization parameters for the instance in our SPFILE. But what if you are creating a new database? Do we follow the same steps – namely create the database and then apply the maximum string size changes in order to get all of that varchar2(32767) goodness?

I am going to suggest a different way. If you need to create a new database then there are benefits if you create that database from scratch with the maximum string size set to extended at the very start of the exercise.

That does imply a slightly slower creation time the first time you do this using the database creation assistant. To see why this is the case, let’s see what happens if you try to create a database with the standard preconfigured templates and also set the maximum string size to extended as part of the creation



C:\oracle\product\19\bin>dbca -silent -createDatabase  
       -templateName General_Purpose.dbc  -gdbname db19m -sid db19m 
       -responseFile NO_VALUE  -characterSet AL32UTF8  
       -sysPassword admin  -systemPassword admin  
       -createAsContainerDatabase false  -numberOfPDBs 0  
       -databaseType MULTIPURPOSE  -automaticMemoryManagement false  
       -storageType FS  -datafileDestination X:\oracle\oradata\  
       -ignorePreReqs -totalMemory 1536  -emConfiguration NONE  
       -initParams max_string_size=EXTENDED
       
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
[WARNING] ORA-25153: Temporary Tablespace is Empty
ORA-06512: at line 3

43% complete
[WARNING] ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-14695: MAX_STRING_SIZE migration is incomplete

[FATAL] ORA-03114: not connected to ORACLE

60% complete
100% complete
[FATAL] ORA-03114: not connected to ORACLE

40% complete
10% complete
0% complete
Look at the log file "C:\oracle\cfgtoollogs\dbca\db19m\db19m1.log" for further details.

It looks to me like the creation assistant does not have the smarts out of the box to realise that the max_string_size of EXTENDED requires some post creation operations if you start with datafiles in the template that were built with the default setting of STANDARD. You can probably work around this using the post creation scripts option, but I did not pursue that any further. Using the “New_Database” template, which does not have any preconfigured data files, means the database dictionary is created from scripts and thus I can happily set max_string_size to extended and the database will create just fine.


C:\oracle\product\19\bin>dbca -silent -createDatabase  
       -templateName New_Database.dbt -gdbname db19m -sid db19m 
       -responseFile NO_VALUE  -characterSet AL32UTF8  
       -sysPassword admin  -systemPassword admin  
       -createAsContainerDatabase false  -numberOfPDBs 0  
       -databaseType MULTIPURPOSE  -automaticMemoryManagement false  
       -storageType FS  -datafileDestination X:\oracle\oradata\  
       -ignorePreReqs -totalMemory 1536  -emConfiguration NONE  
       -initParams max_string_size=EXTENDED

Prepare for db operation
4% complete
Creating and starting Oracle instance
6% complete
9% complete
Creating database files
13% complete
Creating data dictionary views
14% complete
17% complete
18% complete
21% complete
22% complete
24% complete
26% complete
Oracle JVM
33% complete
39% complete
46% complete
48% complete
Oracle Text
49% complete
51% complete
52% complete
Oracle Multimedia
65% complete
Oracle OLAP
66% complete
67% complete
68% complete
70% complete
Oracle Spatial
78% complete
Oracle Database Extensions for .NET
83% complete
Completing Database Creation
85% complete
87% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 C:\oracle\cfgtoollogs\dbca\db19m.
Database Information:
Global Database Name:db19m
System Identifier(SID):db19m
Look at the log file "C:\oracle\cfgtoollogs\dbca\db19m\db19m2.log" for further details.

But why did I go to all of this bother? Because if the database knows during the creation phase that you will be adopting a greater string size then that can also be reflected in the data dictionary. If you refer back to my post about those annoying LONG columns in the database, you can see from the description of the DBA_VIEWS dictionary view that we have tried to assist customers by including string based equivalents of those long columns. In my existing 19c database, where I did the usual “after the fact” conversion from max_string_size to EXTENDED, this is too late so to speak and as such the DBA_VIEWS columns are still capped at 4000 characters.


SQL> desc DBA_VIEWS
 Name                                Null?    Type
 ----------------------------------- -------- ----------------------
 OWNER                               NOT NULL VARCHAR2(128)
 VIEW_NAME                           NOT NULL VARCHAR2(128)
 TEXT_LENGTH                                  NUMBER
 TEXT                                         LONG
 TEXT_VC                                      VARCHAR2(4000)
 TYPE_TEXT_LENGTH                             NUMBER
 TYPE_TEXT                                    VARCHAR2(4000)
 OID_TEXT_LENGTH                              NUMBER
 OID_TEXT                                     VARCHAR2(4000)
 VIEW_TYPE_OWNER                              VARCHAR2(128)
 VIEW_TYPE                                    VARCHAR2(128)
 SUPERVIEW_NAME                               VARCHAR2(128)
 EDITIONING_VIEW                              VARCHAR2(1)
 READ_ONLY                                    VARCHAR2(1)
 CONTAINER_DATA                               VARCHAR2(1)
 BEQUEATH                                     VARCHAR2(12)
 ORIGIN_CON_ID                                NUMBER
 DEFAULT_COLLATION                            VARCHAR2(100)
 CONTAINERS_DEFAULT                           VARCHAR2(3)
 CONTAINER_MAP                                VARCHAR2(3)
 EXTENDED_DATA_LINK                           VARCHAR2(3)
 EXTENDED_DATA_LINK_MAP                       VARCHAR2(3)
 HAS_SENSITIVE_COLUMN                         VARCHAR2(3)
 ADMIT_NULL                                   VARCHAR2(3)
 PDB_LOCAL_ONLY                               VARCHAR2(3)

However with my freshly created database where I set max_string_size to EXTENDED at the very commencement of the creation, now take a look at my DBA_VIEWS dictionary view!


SQL> desc DBA_VIEWS
 Name                                Null?    Type
 ----------------------------------- -------- ------------------
 OWNER                               NOT NULL VARCHAR2(128)
 VIEW_NAME                           NOT NULL VARCHAR2(128)
 TEXT_LENGTH                                  NUMBER
 TEXT                                         LONG
 TEXT_VC                                      VARCHAR2(32767)
 TYPE_TEXT_LENGTH                             NUMBER
 TYPE_TEXT                                    VARCHAR2(4000)
 OID_TEXT_LENGTH                              NUMBER
 OID_TEXT                                     VARCHAR2(4000)
 VIEW_TYPE_OWNER                              VARCHAR2(128)
 VIEW_TYPE                                    VARCHAR2(128)
 SUPERVIEW_NAME                               VARCHAR2(128)
 EDITIONING_VIEW                              VARCHAR2(1)
 READ_ONLY                                    VARCHAR2(1)
 CONTAINER_DATA                               VARCHAR2(1)
 BEQUEATH                                     VARCHAR2(12)
 ORIGIN_CON_ID                                NUMBER
 DEFAULT_COLLATION                            VARCHAR2(100)
 CONTAINERS_DEFAULT                           VARCHAR2(3)
 CONTAINER_MAP                                VARCHAR2(3)
 EXTENDED_DATA_LINK                           VARCHAR2(3)
 EXTENDED_DATA_LINK_MAP                       VARCHAR2(3)
 HAS_SENSITIVE_COLUMN                         VARCHAR2(3)
 ADMIT_NULL                                   VARCHAR2(3)
 PDB_LOCAL_ONLY                               VARCHAR2(3)

Very cool indeed! It would be rare for many views to be more than 32,767 byte long.

But the benefits are far more wide ranging than just the DBA_VIEWS dictionary view . If I look at the definition of columns in the dictionary that now are at a larger size, we can see that many of the dictionary objects now contain a much larger capacity for holding those big strings


SQL> select table_name, column_name
  2  from   dba_tab_columns
  3  where  data_length = 32767
  4  order by 1,2;

TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------
ALL_APPLY_ENQUEUE              DESTINATION_QUEUE_NAME
ALL_ATTRIBUTE_DIM_JOIN_PATHS   ON_CONDITION
ALL_AW_PROP                    PROPERTY_TYPE
ALL_AW_PROP                    PROPERTY_VALUE
ALL_COL_PENDING_STATS          HIGH_VALUE
ALL_COL_PENDING_STATS          LOW_VALUE
ALL_CONSTRAINTS                SEARCH_CONDITION_VC
ALL_GG_INBOUND_PROGRESS        APPLIED_HIGH_POSITION
ALL_GG_INBOUND_PROGRESS        APPLIED_LOW_POSITION
ALL_GG_INBOUND_PROGRESS        LOGBSN
ALL_GG_INBOUND_PROGRESS        OLDEST_POSITION
ALL_GG_INBOUND_PROGRESS        PROCESSED_LOW_POSITION
ALL_GG_INBOUND_PROGRESS        SPILL_POSITION
ALL_JAVA_COMPILER_OPTIONS      VALUE
ALL_NESTED_TABLE_COLS          HIGH_VALUE
ALL_NESTED_TABLE_COLS          LOW_VALUE
ALL_PART_COL_STATISTICS        HIGH_VALUE
ALL_PART_COL_STATISTICS        LOW_VALUE
ALL_PART_HISTOGRAMS            ENDPOINT_ACTUAL_VALUE
ALL_PART_HISTOGRAMS            ENDPOINT_ACTUAL_VALUE_RAW
ALL_SCHEDULER_CHAIN_RULES      ACTION
ALL_SCHEDULER_CHAIN_RULES      CONDITION
ALL_SCHEDULER_JOBS             RAISE_EVENTS
ALL_SCHEDULER_JOB_ARGS         VALUE
ALL_SCHEDULER_JOB_RUN_DETAILS  ERRORS
ALL_SCHEDULER_JOB_RUN_DETAILS  OUTPUT
ALL_SCHEDULER_PROGRAM_ARGS     DEFAULT_VALUE
ALL_STREAMS_TRANSFORMATIONS    COLUMN_TYPE
ALL_STREAMS_TRANSFORMATIONS    USER_FUNCTION_NAME
ALL_STREAMS_TRANSFORM_FUNCTION TRANSFORM_FUNCTION_NAME
ALL_STREAMS_TRANSFORM_FUNCTION VALUE_TYPE
ALL_SUBPART_COL_STATISTICS     HIGH_VALUE
ALL_SUBPART_COL_STATISTICS     LOW_VALUE
ALL_SUBPART_HISTOGRAMS         ENDPOINT_ACTUAL_VALUE
ALL_SUBPART_HISTOGRAMS         ENDPOINT_ACTUAL_VALUE_RAW
ALL_TAB_COLS                   HIGH_VALUE
ALL_TAB_COLS                   LOW_VALUE
ALL_TAB_COLS_V$                HIGH_VALUE
ALL_TAB_COLS_V$                LOW_VALUE
ALL_TAB_COLUMNS                HIGH_VALUE
ALL_TAB_COLUMNS                LOW_VALUE
ALL_TAB_COL_STATISTICS         HIGH_VALUE
ALL_TAB_COL_STATISTICS         LOW_VALUE
ALL_TAB_HISTGRM_PENDING_STATS  ENDPOINT_ACTUAL_VALUE
ALL_TAB_HISTGRM_PENDING_STATS  ENDPOINT_ACTUAL_VALUE_RAW
ALL_TAB_HISTOGRAMS             ENDPOINT_ACTUAL_VALUE
ALL_TAB_HISTOGRAMS             ENDPOINT_ACTUAL_VALUE_RAW
ALL_VIEWS                      TEXT_VC
ALL_VIEWS_AE                   TEXT_VC
ALL_WM_LOCKED_TABLES           LOCKING_STATE
ALL_WM_LOCKED_TABLES           LOCK_OWNER
ALL_WM_TAB_TRIGGERS            TRIGGER_TYPE
ALL_WM_VERSIONED_TABLES        CONFLICT
ALL_WM_VERSIONED_TABLES        DIFF
ALL_WM_VT_ERRORS               SQL_STR
ALL_XML_SCHEMAS                INT_OBJNAME
ALL_XML_SCHEMAS2               INT_OBJNAME
ALL_XML_TABLES                 TOKENSETS
ALL_XML_TAB_COLS               TOKENSETS
ALL_XSTREAM_TRANSFORMATIONS    COLUMN_TYPE
ALL_XSTREAM_TRANSFORMATIONS    USER_FUNCTION_NAME
AWR_CDB_CELL_DISKTYPE          CELL_NAME
AWR_CDB_CELL_DISKTYPE          FLASH_DISK_TYPE
AWR_CDB_CELL_DISKTYPE          HARD_DISK_TYPE
AWR_CDB_CELL_DISK_NAME         DISK
AWR_CDB_CELL_DISK_NAME         DISK_NAME
AWR_CDB_CELL_NAME              CELL_NAME
AWR_PDB_CELL_DISKTYPE          CELL_NAME
AWR_PDB_CELL_DISKTYPE          FLASH_DISK_TYPE
AWR_PDB_CELL_DISKTYPE          HARD_DISK_TYPE
AWR_PDB_CELL_DISK_NAME         DISK
AWR_PDB_CELL_DISK_NAME         DISK_NAME
AWR_PDB_CELL_NAME              CELL_NAME
AWR_ROOT_CELL_DISKTYPE         CELL_NAME
AWR_ROOT_CELL_DISKTYPE         FLASH_DISK_TYPE
AWR_ROOT_CELL_DISKTYPE         HARD_DISK_TYPE
AWR_ROOT_CELL_DISK_NAME        DISK
AWR_ROOT_CELL_DISK_NAME        DISK_NAME
AWR_ROOT_CELL_NAME             CELL_NAME
CDB_ADDM_FINDINGS              FINDING_NAME
CDB_ADDM_FINDINGS              IMPACT_TYPE
CDB_ADDM_FINDINGS              MESSAGE
CDB_ADDM_FINDINGS              MORE_INFO
CDB_ADDM_SYSTEM_DIRECTIVES     DESCRIPTION
CDB_ADDM_TASKS                 ERROR_MESSAGE
CDB_ADDM_TASKS                 STATUS_MESSAGE
CDB_ADDM_TASK_DIRECTIVES       DESCRIPTION
CDB_ADVISOR_ACTIONS            MESSAGE
CDB_ADVISOR_ACTIONS            RESULT_MESSAGE
CDB_ADVISOR_DEF_PARAMETERS     DESCRIPTION
CDB_ADVISOR_EXECUTIONS         ERROR_MESSAGE
CDB_ADVISOR_EXECUTIONS         STATUS_MESSAGE
CDB_ADVISOR_EXECUTION_TYPES    EXECUTION_DESCRIPTION
CDB_ADVISOR_EXEC_PARAMETERS    DESCRIPTION
CDB_ADVISOR_FINDINGS           FINDING_NAME
CDB_ADVISOR_FINDINGS           IMPACT_TYPE
CDB_ADVISOR_FINDINGS           MESSAGE
CDB_ADVISOR_FINDINGS           MORE_INFO
CDB_ADVISOR_FINDING_NAMES      FINDING_NAME
CDB_ADVISOR_JOURNAL            JOURNAL_ENTRY
CDB_ADVISOR_LOG                ERROR_MESSAGE
CDB_ADVISOR_LOG                STATUS_MESSAGE
CDB_ADVISOR_PARAMETERS         DESCRIPTION
CDB_ADVISOR_PARAMETERS_PROJ    DESCRIPTION
CDB_ADVISOR_RATIONALE          IMPACT_TYPE
CDB_ADVISOR_RATIONALE          MESSAGE
CDB_ADVISOR_RECOMMENDATIONS    BENEFIT_TYPE
CDB_ADVISOR_SQLW_JOURNAL       JOURNAL_ENTRY
CDB_ADVISOR_SQLW_PARAMETERS    DESCRIPTION
CDB_ADVISOR_TASKS              ERROR_MESSAGE
CDB_ADVISOR_TASKS              STATUS_MESSAGE
CDB_ALERT_HISTORY              REASON
CDB_ALERT_HISTORY              SUGGESTED_ACTION
CDB_ALERT_HISTORY_DETAIL       REASON
CDB_ALERT_HISTORY_DETAIL       SUGGESTED_ACTION
CDB_APPLY_ENQUEUE              DESTINATION_QUEUE_NAME
CDB_ATTRIBUTE_DIM_JOIN_PATHS   ON_CONDITION
CDB_AUTOTASK_CLIENT            ATTRIBUTES
CDB_AUTOTASK_OPERATION         ATTRIBUTES
CDB_AUTOTASK_TASK              ATTRIBUTES
CDB_AUTO_INDEX_CONFIG          PARAMETER_VALUE
CDB_AUTO_INDEX_EXECUTIONS      ERROR_MESSAGE
CDB_AW_PROP                    PROPERTY_TYPE
CDB_AW_PROP                    PROPERTY_VALUE
CDB_COL_PENDING_STATS          HIGH_VALUE
CDB_COL_PENDING_STATS          LOW_VALUE
CDB_CONNECT_ROLE_GRANTEES      PATH_OF_CONNECT_ROLE_GRANT
CDB_CONSTRAINTS                SEARCH_CONDITION_VC
CDB_GG_INBOUND_PROGRESS        APPLIED_HIGH_POSITION
CDB_GG_INBOUND_PROGRESS        APPLIED_LOW_POSITION
CDB_GG_INBOUND_PROGRESS        LOGBSN
CDB_GG_INBOUND_PROGRESS        OLDEST_POSITION
CDB_GG_INBOUND_PROGRESS        PROCESSED_LOW_POSITION
CDB_GG_INBOUND_PROGRESS        SPILL_POSITION
CDB_HIST_CELL_DISKTYPE         CELL_NAME
CDB_HIST_CELL_DISKTYPE         FLASH_DISK_TYPE
CDB_HIST_CELL_DISKTYPE         HARD_DISK_TYPE
CDB_HIST_CELL_DISK_NAME        DISK
CDB_HIST_CELL_DISK_NAME        DISK_NAME
CDB_HIST_CELL_NAME             CELL_NAME
CDB_JAVA_COMPILER_OPTIONS      VALUE
CDB_NESTED_TABLE_COLS          HIGH_VALUE
CDB_NESTED_TABLE_COLS          LOW_VALUE
CDB_OUTSTANDING_ALERTS         REASON
CDB_OUTSTANDING_ALERTS         SUGGESTED_ACTION
CDB_PART_COL_STATISTICS        HIGH_VALUE
CDB_PART_COL_STATISTICS        LOW_VALUE
CDB_PART_HISTOGRAMS            ENDPOINT_ACTUAL_VALUE
CDB_PART_HISTOGRAMS            ENDPOINT_ACTUAL_VALUE_RAW
CDB_REGISTRY                   OTHER_SCHEMAS
CDB_REGISTRY_HIERARCHY         COMP_ID
CDB_SCHEDULER_CHAIN_RULES      ACTION
CDB_SCHEDULER_CHAIN_RULES      CONDITION
CDB_SCHEDULER_JOBS             RAISE_EVENTS
CDB_SCHEDULER_JOB_ARGS         VALUE
CDB_SCHEDULER_JOB_RUN_DETAILS  ERRORS
CDB_SCHEDULER_JOB_RUN_DETAILS  OUTPUT
CDB_SCHEDULER_PROGRAM_ARGS     DEFAULT_VALUE
CDB_SERVER_REGISTRY            OTHER_SCHEMAS
CDB_SQL_MANAGEMENT_CONFIG      PARAMETER_VALUE
CDB_SQL_PLAN_DIR_OBJECTS       OBJECT_NAME
CDB_SQL_QUARANTINE             CPU_TIME
CDB_SQL_QUARANTINE             ELAPSED_TIME
CDB_SQL_QUARANTINE             IO_LOGICAL
CDB_SQL_QUARANTINE             IO_MEGABYTES
CDB_SQL_QUARANTINE             IO_REQUESTS
CDB_STREAMS_ADD_COLUMN         COLUMN_TYPE
CDB_STREAMS_TRANSFORMATIONS    COLUMN_TYPE
CDB_STREAMS_TRANSFORMATIONS    USER_FUNCTION_NAME
CDB_STREAMS_TRANSFORM_FUNCTION TRANSFORM_FUNCTION_NAME
CDB_STREAMS_TRANSFORM_FUNCTION VALUE_TYPE
CDB_SUBPART_COL_STATISTICS     HIGH_VALUE
CDB_SUBPART_COL_STATISTICS     LOW_VALUE
CDB_SUBPART_HISTOGRAMS         ENDPOINT_ACTUAL_VALUE
CDB_SUBPART_HISTOGRAMS         ENDPOINT_ACTUAL_VALUE_RAW
CDB_TAB_COLS                   HIGH_VALUE
CDB_TAB_COLS                   LOW_VALUE
CDB_TAB_COLS_V$                HIGH_VALUE
CDB_TAB_COLS_V$                LOW_VALUE
CDB_TAB_COLUMNS                HIGH_VALUE
CDB_TAB_COLUMNS                LOW_VALUE
CDB_TAB_COL_STATISTICS         HIGH_VALUE
CDB_TAB_COL_STATISTICS         LOW_VALUE
CDB_TAB_HISTGRM_PENDING_STATS  ENDPOINT_ACTUAL_VALUE
CDB_TAB_HISTGRM_PENDING_STATS  ENDPOINT_ACTUAL_VALUE_RAW
CDB_TAB_HISTOGRAMS             ENDPOINT_ACTUAL_VALUE
CDB_TAB_HISTOGRAMS             ENDPOINT_ACTUAL_VALUE_RAW
CDB_VIEWS                      TEXT_VC
CDB_VIEWS_AE                   TEXT_VC
CDB_WM_VERSIONED_TABLES        CONFLICT
CDB_WM_VERSIONED_TABLES        DIFF
CDB_WM_VT_ERRORS               SQL_STR
CDB_WORKLOAD_DIV_SUMMARY       EXPECTED_ERROR_MESSAGE
CDB_WORKLOAD_DIV_SUMMARY       OBSERVED_ERROR_MESSAGE
CDB_WORKLOAD_REPLAY_DIVERGENCE EXPECTED_ERROR_MESSAGE
CDB_WORKLOAD_REPLAY_DIVERGENCE OBSERVED_ERROR_MESSAGE
CDB_XML_SCHEMAS                INT_OBJNAME
CDB_XML_TABLES                 TOKENSETS
CDB_XML_TAB_COLS               TOKENSETS
CDB_XSTREAM_TRANSFORMATIONS    COLUMN_TYPE
CDB_XSTREAM_TRANSFORMATIONS    USER_FUNCTION_NAME
DBA_ADDM_FINDINGS              FINDING_NAME
DBA_ADDM_FINDINGS              IMPACT_TYPE
DBA_ADDM_FINDINGS              MESSAGE
DBA_ADDM_FINDINGS              MORE_INFO
DBA_ADDM_SYSTEM_DIRECTIVES     DESCRIPTION
DBA_ADDM_TASKS                 ERROR_MESSAGE
DBA_ADDM_TASKS                 STATUS_MESSAGE
DBA_ADDM_TASK_DIRECTIVES       DESCRIPTION
DBA_ADVISOR_ACTIONS            MESSAGE
DBA_ADVISOR_ACTIONS            RESULT_MESSAGE
DBA_ADVISOR_DEF_PARAMETERS     DESCRIPTION
DBA_ADVISOR_EXECUTIONS         ERROR_MESSAGE
DBA_ADVISOR_EXECUTIONS         STATUS_MESSAGE
DBA_ADVISOR_EXECUTION_TYPES    EXECUTION_DESCRIPTION
DBA_ADVISOR_EXEC_PARAMETERS    DESCRIPTION
DBA_ADVISOR_FINDINGS           FINDING_NAME
DBA_ADVISOR_FINDINGS           IMPACT_TYPE
DBA_ADVISOR_FINDINGS           MESSAGE
DBA_ADVISOR_FINDINGS           MORE_INFO
DBA_ADVISOR_FINDING_NAMES      FINDING_NAME
DBA_ADVISOR_JOURNAL            JOURNAL_ENTRY
DBA_ADVISOR_LOG                ERROR_MESSAGE
DBA_ADVISOR_LOG                STATUS_MESSAGE
DBA_ADVISOR_PARAMETERS         DESCRIPTION
DBA_ADVISOR_PARAMETERS_PROJ    DESCRIPTION
DBA_ADVISOR_RATIONALE          IMPACT_TYPE
DBA_ADVISOR_RATIONALE          MESSAGE
DBA_ADVISOR_RECOMMENDATIONS    BENEFIT_TYPE
DBA_ADVISOR_SQLW_JOURNAL       JOURNAL_ENTRY
DBA_ADVISOR_SQLW_PARAMETERS    DESCRIPTION
DBA_ADVISOR_TASKS              ERROR_MESSAGE
DBA_ADVISOR_TASKS              STATUS_MESSAGE
DBA_ALERT_HISTORY              REASON
DBA_ALERT_HISTORY              SUGGESTED_ACTION
DBA_ALERT_HISTORY_DETAIL       REASON
DBA_ALERT_HISTORY_DETAIL       SUGGESTED_ACTION
DBA_APPLY_ENQUEUE              DESTINATION_QUEUE_NAME
DBA_ATTRIBUTE_DIM_JOIN_PATHS   ON_CONDITION
DBA_AUTOTASK_CLIENT            ATTRIBUTES
DBA_AUTOTASK_OPERATION         ATTRIBUTES
DBA_AUTOTASK_TASK              ATTRIBUTES
DBA_AUTO_INDEX_CONFIG          PARAMETER_VALUE
DBA_AUTO_INDEX_EXECUTIONS      ERROR_MESSAGE
DBA_AW_PROP                    PROPERTY_TYPE
DBA_AW_PROP                    PROPERTY_VALUE
DBA_COL_PENDING_STATS          HIGH_VALUE
DBA_COL_PENDING_STATS          LOW_VALUE
DBA_CONNECT_ROLE_GRANTEES      PATH_OF_CONNECT_ROLE_GRANT
DBA_CONSTRAINTS                SEARCH_CONDITION_VC
DBA_GG_INBOUND_PROGRESS        APPLIED_HIGH_POSITION
DBA_GG_INBOUND_PROGRESS        APPLIED_LOW_POSITION
DBA_GG_INBOUND_PROGRESS        LOGBSN
DBA_GG_INBOUND_PROGRESS        OLDEST_POSITION
DBA_GG_INBOUND_PROGRESS        PROCESSED_LOW_POSITION
DBA_GG_INBOUND_PROGRESS        SPILL_POSITION
DBA_HIST_CELL_DISKTYPE         CELL_NAME
DBA_HIST_CELL_DISKTYPE         FLASH_DISK_TYPE
DBA_HIST_CELL_DISKTYPE         HARD_DISK_TYPE
DBA_HIST_CELL_DISK_NAME        DISK
DBA_HIST_CELL_DISK_NAME        DISK_NAME
DBA_HIST_CELL_NAME             CELL_NAME
DBA_JAVA_COMPILER_OPTIONS      VALUE
DBA_NESTED_TABLE_COLS          HIGH_VALUE
DBA_NESTED_TABLE_COLS          LOW_VALUE
DBA_OUTSTANDING_ALERTS         REASON
DBA_OUTSTANDING_ALERTS         SUGGESTED_ACTION
DBA_PART_COL_STATISTICS        HIGH_VALUE
DBA_PART_COL_STATISTICS        LOW_VALUE
DBA_PART_HISTOGRAMS            ENDPOINT_ACTUAL_VALUE
DBA_PART_HISTOGRAMS            ENDPOINT_ACTUAL_VALUE_RAW
DBA_REGISTRY                   OTHER_SCHEMAS
DBA_REGISTRY_HIERARCHY         COMP_ID
DBA_SCHEDULER_CHAIN_RULES      ACTION
DBA_SCHEDULER_CHAIN_RULES      CONDITION
DBA_SCHEDULER_JOBS             RAISE_EVENTS
DBA_SCHEDULER_JOB_ARGS         VALUE
DBA_SCHEDULER_JOB_RUN_DETAILS  ERRORS
DBA_SCHEDULER_JOB_RUN_DETAILS  OUTPUT
DBA_SCHEDULER_PROGRAM_ARGS     DEFAULT_VALUE
DBA_SERVER_REGISTRY            OTHER_SCHEMAS
DBA_SQL_MANAGEMENT_CONFIG      PARAMETER_VALUE
DBA_SQL_PLAN_DIR_OBJECTS       OBJECT_NAME
DBA_SQL_QUARANTINE             CPU_TIME
DBA_SQL_QUARANTINE             ELAPSED_TIME
DBA_SQL_QUARANTINE             IO_LOGICAL
DBA_SQL_QUARANTINE             IO_MEGABYTES
DBA_SQL_QUARANTINE             IO_REQUESTS
DBA_STREAMS_ADD_COLUMN         COLUMN_TYPE
DBA_STREAMS_TRANSFORMATIONS    COLUMN_TYPE
DBA_STREAMS_TRANSFORMATIONS    USER_FUNCTION_NAME
DBA_STREAMS_TRANSFORM_FUNCTION TRANSFORM_FUNCTION_NAME
DBA_STREAMS_TRANSFORM_FUNCTION VALUE_TYPE
DBA_SUBPART_COL_STATISTICS     HIGH_VALUE
DBA_SUBPART_COL_STATISTICS     LOW_VALUE
DBA_SUBPART_HISTOGRAMS         ENDPOINT_ACTUAL_VALUE
DBA_SUBPART_HISTOGRAMS         ENDPOINT_ACTUAL_VALUE_RAW
DBA_TAB_COLS                   HIGH_VALUE
DBA_TAB_COLS                   LOW_VALUE
DBA_TAB_COLS_V$                HIGH_VALUE
DBA_TAB_COLS_V$                LOW_VALUE
DBA_TAB_COLUMNS                HIGH_VALUE
DBA_TAB_COLUMNS                LOW_VALUE
DBA_TAB_COL_STATISTICS         HIGH_VALUE
DBA_TAB_COL_STATISTICS         LOW_VALUE
DBA_TAB_HISTGRM_PENDING_STATS  ENDPOINT_ACTUAL_VALUE
DBA_TAB_HISTGRM_PENDING_STATS  ENDPOINT_ACTUAL_VALUE_RAW
DBA_TAB_HISTOGRAMS             ENDPOINT_ACTUAL_VALUE
DBA_TAB_HISTOGRAMS             ENDPOINT_ACTUAL_VALUE_RAW
DBA_VIEWS                      TEXT_VC
DBA_VIEWS_AE                   TEXT_VC
DBA_WM_VERSIONED_TABLES        CONFLICT
DBA_WM_VERSIONED_TABLES        DIFF
DBA_WM_VT_ERRORS               SQL_STR
DBA_WORKLOAD_DIV_SUMMARY       EXPECTED_ERROR_MESSAGE
DBA_WORKLOAD_DIV_SUMMARY       OBSERVED_ERROR_MESSAGE
DBA_WORKLOAD_REPLAY_DIVERGENCE EXPECTED_ERROR_MESSAGE
DBA_WORKLOAD_REPLAY_DIVERGENCE OBSERVED_ERROR_MESSAGE
DBA_XML_SCHEMAS                INT_OBJNAME
DBA_XML_TABLES                 TOKENSETS
DBA_XML_TAB_COLS               TOKENSETS
DBA_XSTREAM_TRANSFORMATIONS    COLUMN_TYPE
DBA_XSTREAM_TRANSFORMATIONS    USER_FUNCTION_NAME
EXU10ASC                       HIVAL
EXU10ASC                       LOWVAL
EXU10ASCU                      HIVAL
EXU10ASCU                      LOWVAL
EXU8ASC                        HIVAL
EXU8ASC                        LOWVAL
EXU8ASCU                       HIVAL
EXU8ASCU                       LOWVAL
INT$DBA_APP_STATEMENTS         SQLSTMT
INT$DBA_ATTR_DIM_JOIN_PATHS    ON_CONDITION
INT$DBA_CONSTRAINTS            SEARCH_CONDITION_VC
INT$DBA_VIEWS                  TEXT_VC
INT$DBA_VIEWS_AE               TEXT_VC
INT$INT$DBA_CONSTRAINTS        SEARCH_CONDITION_VC
KU$_10_1_DBLINK_VIEW           AUTHPWDX
KU$_10_1_DBLINK_VIEW           PASSWORDX
KU$_10_1_FHTABLE_VIEW          TSTZ_COLS
KU$_10_1_FHTABLE_VIEW          XMLHIERARCHY
KU$_10_1_HTABLE_VIEW           TSTZ_COLS
KU$_10_1_IOTABLE_VIEW          TSTZ_COLS
KU$_10_1_IOTABLE_VIEW          XMLHIERARCHY
KU$_10_1_PFHTABLE_VIEW         TSTZ_COLS
KU$_10_1_PFHTABLE_VIEW         XMLHIERARCHY
KU$_10_1_PHTABLE_VIEW          TSTZ_COLS
KU$_10_1_PIOTABLE_VIEW         TSTZ_COLS
KU$_10_1_PIOTABLE_VIEW         XMLHIERARCHY
KU$_10_1_PTAB_COL_STATS_VIEW   HIVAL
KU$_10_1_PTAB_COL_STATS_VIEW   LOWVAL
KU$_10_1_TABLE_DATA_VIEW       TSTZ_COLS
KU$_10_1_TAB_COL_STATS_VIEW    HIVAL
KU$_10_1_TAB_COL_STATS_VIEW    LOWVAL
KU$_10_2_FHTABLE_VIEW          TSTZ_COLS
KU$_10_2_FHTABLE_VIEW          XMLHIERARCHY
KU$_10_2_STRMCOLTYPE_VIEW      HASHCODE
KU$_10_2_STRMCOL_VIEW          BASE_COL_NAME
KU$_10_2_STRMSUBCOLTYPE_VIEW   HASHCODE
KU$_10_2_STRMTABLE_VIEW        FDO
KU$_10_2_TABLE_DATA_VIEW       TSTZ_COLS
KU$_10_2_TAB_COL_VIEW          DEFAULT_VAL
KU$_11_2_VIEW_VIEW             TRANSTEXT
KU$_11_2_VIEW_VIEW             UNDERTEXT
KU$_ACPTABLE_VIEW              TSTZ_COLS
KU$_ACPTABLE_VIEW              XMLHIERARCHY
KU$_ADD_SNAP_VIEW              REF_ADD_DBA
KU$_ADD_SNAP_VIEW              REF_ADD_USER
KU$_ARGUMENT_VIEW              DEFAULT_VAL
KU$_ATTR_DIM_JOIN_PATH_VIEW    ON_CONDITION
KU$_COLTYPE_VIEW               HASHCODE
KU$_COLTYPE_VIEW               HAS_TSTZ
KU$_COLUMN_VIEW                ATTRNAME
KU$_COLUMN_VIEW                ATTRNAME2
KU$_COLUMN_VIEW                BASE_COL_NAME
KU$_COLUMN_VIEW                DEFAULT_VAL
KU$_COLUMN_VIEW                FULLATTRNAME
KU$_COL_STATS_VIEW             HIVAL
KU$_COL_STATS_VIEW             HIVAL_1000
KU$_COL_STATS_VIEW             LOWVAL
KU$_COL_STATS_VIEW             LOWVAL_1000
KU$_DBLINK_VIEW                AUTHPWDX
KU$_DBLINK_VIEW                PASSWORDX
KU$_EQNTABLE_DATA_VIEW         TSTZ_COLS
KU$_FHTABLE_VIEW               TSTZ_COLS
KU$_FHTABLE_VIEW               XMLHIERARCHY
KU$_HISTGRM_VIEW               EPVALUE
KU$_HISTGRM_VIEW               EPVALUE_RAW
KU$_HTABLE_DATA_VIEW           TSTZ_COLS
KU$_HTABLE_VIEW                TSTZ_COLS
KU$_HTPART_DATA_VIEW           TSTZ_COLS
KU$_HTSPART_DATA_VIEW          TSTZ_COLS
KU$_IND_COL_VIEW               DEFAULT_VAL
KU$_IND_COMPART_VIEW           HIBOUNDVAL
KU$_IND_PART_VIEW              HIBOUNDVAL
KU$_IOTABLE_DATA_VIEW          TSTZ_COLS
KU$_IOTABLE_VIEW               TSTZ_COLS
KU$_IOTABLE_VIEW               XMLHIERARCHY
KU$_IOTPART_DATA_VIEW          TSTZ_COLS
KU$_NIOTABLE_DATA_VIEW         TSTZ_COLS
KU$_NTABLE_DATA_VIEW           TSTZ_COLS
KU$_P2TCOLUMN_VIEW             ATTRNAME
KU$_P2TCOLUMN_VIEW             ATTRNAME2
KU$_P2TCOLUMN_VIEW             BASE_COL_NAME
KU$_P2TCOLUMN_VIEW             DEFAULT_VAL
KU$_P2TCOLUMN_VIEW             FULLATTRNAME
KU$_P2TPARTCOL_VIEW            ATTRNAME
KU$_P2TPARTCOL_VIEW            ATTRNAME2
KU$_P2TPARTCOL_VIEW            BASE_COL_NAME
KU$_P2TPARTCOL_VIEW            DEFAULT_VAL
KU$_P2TPARTCOL_VIEW            FULLATTRNAME
KU$_PARTITION_VIEW             TSTZ_COLS
KU$_PARTITION_VIEW             XMLHIERARCHY
KU$_PCOLUMN_VIEW               ATTRNAME
KU$_PCOLUMN_VIEW               ATTRNAME2
KU$_PCOLUMN_VIEW               BASE_COL_NAME
KU$_PCOLUMN_VIEW               DEFAULT_VAL
KU$_PCOLUMN_VIEW               FULLATTRNAME
KU$_PFHTABLE_VIEW              TSTZ_COLS
KU$_PFHTABLE_VIEW              XMLHIERARCHY
KU$_PHTABLE_VIEW               TSTZ_COLS
KU$_PIOTABLE_VIEW              TSTZ_COLS
KU$_PIOTABLE_VIEW              XMLHIERARCHY
KU$_PIOT_PART_VIEW             HIBOUNDVAL
KU$_PRIM_COLUMN_VIEW           ATTRNAME2
KU$_PRIM_COLUMN_VIEW           DEFAULT_VAL
KU$_REFGROUP_VIEW              REF_MAKE_DBA
KU$_REFGROUP_VIEW              REF_MAKE_USER
KU$_SIMPLE_COL_VIEW            ATTRNAME
KU$_SIMPLE_COL_VIEW            DEFAULT_VAL
KU$_SIMPLE_PKREF_COL_VIEW      DEFAULT_VAL
KU$_SIMPLE_SETID_COL_VIEW      DEFAULT_VAL
KU$_SP2TCOLUMN_VIEW            ATTRNAME
KU$_SP2TCOLUMN_VIEW            ATTRNAME2
KU$_SP2TCOLUMN_VIEW            BASE_COL_NAME
KU$_SP2TCOLUMN_VIEW            DEFAULT_VAL
KU$_SP2TCOLUMN_VIEW            FULLATTRNAME
KU$_SP2TPARTCOL_VIEW           ATTRNAME
KU$_SP2TPARTCOL_VIEW           ATTRNAME2
KU$_SP2TPARTCOL_VIEW           BASE_COL_NAME
KU$_SP2TPARTCOL_VIEW           DEFAULT_VAL
KU$_SP2TPARTCOL_VIEW           FULLATTRNAME
KU$_STRMCOLTYPE_VIEW           HASHCODE
KU$_STRMCOL_VIEW               ATTRNAME2
KU$_STRMCOL_VIEW               BASE_COL_NAME
KU$_STRMSUBCOLTYPE_VIEW        HASHCODE
KU$_STRMTABLE_VIEW             FDO
KU$_STRMTABLE_VIEW             VERS_MINOR
KU$_SUBCOLTYPE_VIEW            HASHCODE
KU$_SUBPARTITION_VIEW          TSTZ_COLS
KU$_SUBPARTITION_VIEW          XMLHIERARCHY
KU$_TABLE_DATA_VIEW            TSTZ_COLS
KU$_TAB_COL_VIEW               DEFAULT_VAL
KU$_TAB_COMPART_VIEW           HIBOUNDVAL
KU$_TAB_PART_VIEW              HIBOUNDVAL
KU$_TAB_SUBPART_VIEW           HIBOUNDVAL
KU$_TAB_TSUBPART_VIEW          HIBOUNDVAL
KU$_TYPE_VIEW                  HASHCODE
KU$_VIEW_VIEW                  TRANSTEXT
KU$_VIEW_VIEW                  UNDERTEXT
KU$_XMLSCHEMA_ELMT_VIEW        ELEMENT_NAME
LOCAL_CHUNK_TYPES              SHARDGROUP_NAME
MGMT_BSLN_BASELINES            TARGET_UID
MGMT_BSLN_DATASOURCES          DATASOURCE_GUID
MGMT_BSLN_DATASOURCES          METRIC_UID
MGMT_BSLN_DATASOURCES          TARGET_UID
MGMT_BSLN_METRICS              METRIC_UID
MGMT_BSLN_STATISTICS           DATASOURCE_GUID
MGMT_BSLN_THRESHOLD_PARMS      DATASOURCE_GUID
RESOURCE_VIEW                  ANY_PATH
SCHEDULER_JOB_ARGS             VALUE
SCHEDULER_JOB_ARGS_TBL         VALUE
SCHEDULER_PROGRAM_ARGS         DEFAULT_VALUE
SCHEDULER_PROGRAM_ARGS_TBL     DEFAULT_VALUE
SHA_DATABASES                  VERSION
SQT_TAB_COL_STATISTICS         HIGH_VALUE
SQT_TAB_COL_STATISTICS         LOW_VALUE
USER_ADDM_FINDINGS             FINDING_NAME
USER_ADDM_FINDINGS             IMPACT_TYPE
USER_ADDM_FINDINGS             MESSAGE
USER_ADDM_FINDINGS             MORE_INFO
USER_ADDM_TASKS                ERROR_MESSAGE
USER_ADDM_TASKS                STATUS_MESSAGE
USER_ADDM_TASK_DIRECTIVES      DESCRIPTION
USER_ADVISOR_ACTIONS           MESSAGE
USER_ADVISOR_ACTIONS           RESULT_MESSAGE
USER_ADVISOR_EXECUTIONS        ERROR_MESSAGE
USER_ADVISOR_EXECUTIONS        STATUS_MESSAGE
USER_ADVISOR_EXEC_PARAMETERS   DESCRIPTION
USER_ADVISOR_FINDINGS          FINDING_NAME
USER_ADVISOR_FINDINGS          IMPACT_TYPE
USER_ADVISOR_FINDINGS          MESSAGE
USER_ADVISOR_FINDINGS          MORE_INFO
USER_ADVISOR_JOURNAL           JOURNAL_ENTRY
USER_ADVISOR_LOG               ERROR_MESSAGE
USER_ADVISOR_LOG               STATUS_MESSAGE
USER_ADVISOR_PARAMETERS        DESCRIPTION
USER_ADVISOR_RATIONALE         IMPACT_TYPE
USER_ADVISOR_RATIONALE         MESSAGE
USER_ADVISOR_RECOMMENDATIONS   BENEFIT_TYPE
USER_ADVISOR_SQLW_JOURNAL      JOURNAL_ENTRY
USER_ADVISOR_SQLW_PARAMETERS   DESCRIPTION
USER_ADVISOR_TASKS             ERROR_MESSAGE
USER_ADVISOR_TASKS             STATUS_MESSAGE
USER_ATTRIBUTE_DIM_JOIN_PATHS  ON_CONDITION
USER_AW_PROP                   PROPERTY_TYPE
USER_AW_PROP                   PROPERTY_VALUE
USER_COL_PENDING_STATS         HIGH_VALUE
USER_COL_PENDING_STATS         LOW_VALUE
USER_CONSTRAINTS               SEARCH_CONDITION_VC
USER_JAVA_COMPILER_OPTIONS     VALUE
USER_NESTED_TABLE_COLS         HIGH_VALUE
USER_NESTED_TABLE_COLS         LOW_VALUE
USER_PART_COL_STATISTICS       HIGH_VALUE
USER_PART_COL_STATISTICS       LOW_VALUE
USER_PART_HISTOGRAMS           ENDPOINT_ACTUAL_VALUE
USER_PART_HISTOGRAMS           ENDPOINT_ACTUAL_VALUE_RAW
USER_REGISTRY                  OTHER_SCHEMAS
USER_SCHEDULER_CHAIN_RULES     ACTION
USER_SCHEDULER_CHAIN_RULES     CONDITION
USER_SCHEDULER_JOBS            RAISE_EVENTS
USER_SCHEDULER_JOB_ARGS        VALUE
USER_SCHEDULER_JOB_RUN_DETAILS ERRORS
USER_SCHEDULER_JOB_RUN_DETAILS OUTPUT
USER_SCHEDULER_PROGRAM_ARGS    DEFAULT_VALUE
USER_SUBPART_COL_STATISTICS    HIGH_VALUE
USER_SUBPART_COL_STATISTICS    LOW_VALUE
USER_SUBPART_HISTOGRAMS        ENDPOINT_ACTUAL_VALUE
USER_SUBPART_HISTOGRAMS        ENDPOINT_ACTUAL_VALUE_RAW
USER_TAB_COLS                  HIGH_VALUE
USER_TAB_COLS                  LOW_VALUE
USER_TAB_COLS_V$               HIGH_VALUE
USER_TAB_COLS_V$               LOW_VALUE
USER_TAB_COLUMNS               HIGH_VALUE
USER_TAB_COLUMNS               LOW_VALUE
USER_TAB_COL_STATISTICS        HIGH_VALUE
USER_TAB_COL_STATISTICS        LOW_VALUE
USER_TAB_HISTGRM_PENDING_STATS ENDPOINT_ACTUAL_VALUE
USER_TAB_HISTGRM_PENDING_STATS ENDPOINT_ACTUAL_VALUE_RAW
USER_TAB_HISTOGRAMS            ENDPOINT_ACTUAL_VALUE
USER_TAB_HISTOGRAMS            ENDPOINT_ACTUAL_VALUE_RAW
USER_VIEWS                     TEXT_VC
USER_VIEWS_AE                  TEXT_VC
USER_WM_LOCKED_TABLES          LOCKING_STATE
USER_WM_LOCKED_TABLES          LOCK_OWNER
USER_WM_TAB_TRIGGERS           TRIGGER_TYPE
USER_WM_VERSIONED_TABLES       CONFLICT
USER_WM_VERSIONED_TABLES       DIFF
USER_WM_VT_ERRORS              SQL_STR
USER_XML_SCHEMAS               INT_OBJNAME
USER_XML_TABLES                TOKENSETS
USER_XML_TAB_COLS              TOKENSETS
V_$BACKUP_ARCHIVELOG_DETAILS   FILESIZE_DISPLAY
V_$BACKUP_ARCHIVELOG_SUMMARY   INPUT_BYTES_DISPLAY
V_$BACKUP_ARCHIVELOG_SUMMARY   OUTPUT_BYTES_DISPLAY
V_$BACKUP_CONTROLFILE_DETAILS  FILESIZE_DISPLAY
V_$BACKUP_CONTROLFILE_SUMMARY  INPUT_BYTES_DISPLAY
V_$BACKUP_CONTROLFILE_SUMMARY  OUTPUT_BYTES_DISPLAY
V_$BACKUP_COPY_DETAILS         OUTPUT_BYTES_DISPLAY
V_$BACKUP_COPY_SUMMARY         OUTPUT_BYTES_DISPLAY
V_$BACKUP_DATAFILE_DETAILS     FILESIZE_DISPLAY
V_$BACKUP_DATAFILE_SUMMARY     INPUT_BYTES_DISPLAY
V_$BACKUP_DATAFILE_SUMMARY     OUTPUT_BYTES_DISPLAY
V_$BACKUP_PIECE_DETAILS        SIZE_BYTES_DISPLAY
V_$BACKUP_SET_DETAILS          ORIGINAL_INPRATE_BYTES_DISPLAY
V_$BACKUP_SET_DETAILS          ORIGINAL_INPUT_BYTES_DISPLAY
V_$BACKUP_SET_DETAILS          OUTPUT_BYTES_DISPLAY
V_$BACKUP_SET_DETAILS          OUTPUT_RATE_BYTES_DISPLAY
V_$BACKUP_SET_DETAILS          TIME_TAKEN_DISPLAY
V_$BACKUP_SET_SUMMARY          ORIGINAL_INPRATE_BYTES_DISPLAY
V_$BACKUP_SET_SUMMARY          ORIGINAL_INPUT_BYTES_DISPLAY
V_$BACKUP_SET_SUMMARY          OUTPUT_BYTES_DISPLAY
V_$BACKUP_SET_SUMMARY          OUTPUT_RATE_BYTES_DISPLAY
V_$BACKUP_SPFILE_DETAILS       FILESIZE_DISPLAY
V_$BACKUP_SPFILE_SUMMARY       INPUT_BYTES_DISPLAY
V_$PROXY_ARCHIVELOG_DETAILS    OUTPUT_BYTES_DISPLAY
V_$PROXY_ARCHIVELOG_SUMMARY    OUTPUT_BYTES_DISPLAY
V_$PROXY_COPY_DETAILS          OUTPUT_BYTES_DISPLAY
V_$PROXY_COPY_SUMMARY          OUTPUT_BYTES_DISPLAY
V_$RMAN_BACKUP_JOB_DETAILS     INPUT_BYTES_DISPLAY
V_$RMAN_BACKUP_JOB_DETAILS     INPUT_BYTES_PER_SEC_DISPLAY
V_$RMAN_BACKUP_JOB_DETAILS     OUTPUT_BYTES_DISPLAY
V_$RMAN_BACKUP_JOB_DETAILS     OUTPUT_BYTES_PER_SEC_DISPLAY
V_$RMAN_BACKUP_JOB_DETAILS     TIME_TAKEN_DISPLAY
V_$RMAN_BACKUP_SUBJOB_DETAILS  INPUT_BYTES_DISPLAY
V_$RMAN_BACKUP_SUBJOB_DETAILS  OUTPUT_BYTES_DISPLAY
WM$ALL_LOCKS_VIEW              LOCKING_STATE
WM$ALL_LOCKS_VIEW              LOCK_OWNER
WM$EXP_MAP                     VFIELD3
WM$METADATA_MAP                VFIELD3
XDS_ACE                        PRINCIPAL
XDS_ACL                        DESCRIPTION
XDS_ACL                        PARENT_ACL_PATH
_DBA_STREAMS_TRANSFM_FUNCTION  TRANSFORM_FUNCTION_NAME
_DBA_STREAMS_TRANSFM_FUNCTION  VALUE_TYPE
_DBA_SXGG_TRANSFORMATIONS      COLUMN_TYPE
_DBA_SXGG_TRANSFORMATIONS      USER_FUNCTION_NAME
_GV$SXGG_APPLY_COORDINATOR     HWM_POSITION
_GV$SXGG_APPLY_COORDINATOR     LWM_POSITION
_GV$SXGG_APPLY_READER          DEQUEUED_POSITION
_GV$SXGG_APPLY_READER          SPILL_LWM_POSITION
_GV$SXGG_APPLY_SERVER          COMMIT_POSITION
_GV$SXGG_APPLY_SERVER          DEP_COMMIT_POSITION
_GV$SXGG_APPLY_SERVER          LAST_APPLY_POSITION
_GV$SXGG_MESSAGE_TRACKING      MESSAGE_POSITION
_GV$SXGG_TRANSACTION           FIRST_MESSAGE_POSITION
_GV$SXGG_TRANSACTION           LAST_MESSAGE_POSITION
_HISTGRM_DEC                   EPVALUE_RAW
_HIST_HEAD_DEC                 HIVAL
_HIST_HEAD_DEC                 LOWVAL
_OPTSTAT_HISTGRM_HISTORY_DEC   EPVALUE_RAW
_OPTSTAT_HISTHEAD_HISTORY_DEC  HIVAL
_OPTSTAT_HISTHEAD_HISTORY_DEC  LOWVAL
_V$SXGG_APPLY_COORDINATOR      HWM_POSITION
_V$SXGG_APPLY_COORDINATOR      LWM_POSITION
_V$SXGG_APPLY_READER           DEQUEUED_POSITION
_V$SXGG_APPLY_READER           SPILL_LWM_POSITION
_V$SXGG_APPLY_SERVER           COMMIT_POSITION
_V$SXGG_APPLY_SERVER           DEP_COMMIT_POSITION
_V$SXGG_APPLY_SERVER           LAST_APPLY_POSITION
_V$SXGG_MESSAGE_TRACKING       MESSAGE_POSITION
_V$SXGG_TRANSACTION            FIRST_MESSAGE_POSITION
_V$SXGG_TRANSACTION            LAST_MESSAGE_POSITION
_user_stat                     R1
_user_stat                     R2
_user_stat                     R3
_user_stat_varray              R1
_user_stat_varray              R2
_user_stat_varray              R3

629 rows selected.

SQL>

Even that is still a subset of the true picture. If I alter the query to be anything that is larger than 4000 characters you can see that many dictionary objects have been spruced up to hold more information.


SQL> select table_name, column_name, data_length
  2  from   dba_tab_columns
  3  where  data_length > 4000 and data_length < 32767
  4  order by 1,2;

TABLE_NAME                     COLUMN_NAME                    DATA_LENGTH
------------------------------ ------------------------------ -----------
ALL_APPLY_ERROR_MESSAGES       MESSAGE                              32765
ALL_AW_PROP                    FULL_PROPERTY_VALUE                  32765
ALL_CAPTURE                    CLIENT_NAME                          16000
ALL_GOLDENGATE_INBOUND         REPLICAT_NAME                        16000
ALL_JSON_DATAGUIDES            DATAGUIDE                            32765
ALL_SCHEDULER_JOBS             PROGRAM_NAME                         16000
ALL_SCHEDULER_JOBS             PROGRAM_OWNER                        16000
ALL_SCHEDULER_JOBS             SCHEDULE_NAME                        16000
ALL_SCHEDULER_JOBS             SCHEDULE_OWNER                       16000
ALL_SCHEDULER_PROGRAM_ARGS     DEFAULT_ANYDATA_VALUE                 4408
ALL_SCHEDULER_WINDOWS          SCHEDULE_NAME                        16000
ALL_SCHEDULER_WINDOWS          SCHEDULE_OWNER                       16000
ALL_SDO_3DTXFMS                AFFINE_PARAMETERS                     4408
ALL_SDO_3DTXFMS                TXFM_SERIES_IDS                       4408
ALL_SDO_GEOR_SYSDATA           OTHER_TABLE_NAMES                     4408
ALL_STAT_EXTENSIONS            EXTENSION                            32765
ALL_WM_CONSTRAINT_VIOLATIONS   PREDICATE1                           32765
ALL_WM_CONSTRAINT_VIOLATIONS   PREDICATE2                           32765
AQ$_ALERT_QT_F                 USER_PROP                             4408
AQ$_AQ$_MEM_MC_F               USER_PROP                             4408
AQ$_AQ_PROP_TABLE_F            USER_PROP                             4408
AQ$_CHANGE_LOG_QUEUE_TABLE_F   USER_PROP                             4408
AQ$_ORA$PREPLUGIN_BACKUP_QTB_F USER_PROP                             4408
AQ$_PDB_MON_EVENT_QTABLE$_F    USER_PROP                             4408
AQ$_SCHEDULER$_EVENT_QTAB_F    USER_PROP                             4408
AQ$_SCHEDULER$_REMDB_JOBQTAB_F USER_PROP                             4408
AQ$_SCHEDULER_FILEWATCHER_QT_F USER_PROP                             4408
AQ$_SYS$SERVICE_METRICS_TAB_F  USER_PROP                             4408
AQ$_WM$EVENT_QUEUE_TABLE_F     USER_PROP                             4408
CDB_ADVISOR_OBJECTS            ATTR4                                32765
CDB_APPLY_ERROR_MESSAGES       MESSAGE                              32765
CDB_APP_ERRORS                 APP_STATEMENT                        32765
CDB_APP_STATEMENTS             APP_STATEMENT                        32765
CDB_AW_PROP                    FULL_PROPERTY_VALUE                  32765
CDB_CAPTURE                    CLIENT_NAME                          16000
CDB_COMMON_AUDIT_TRAIL         RLS_INFO                             32765
CDB_COMMON_AUDIT_TRAIL         SQL_BIND                             32766
CDB_COMMON_AUDIT_TRAIL         SQL_TEXT                             32766
CDB_CQ_NOTIFICATION_QUERIES    QUERYTEXT                            32765
CDB_GOLDENGATE_INBOUND         REPLICAT_NAME                        16000
CDB_HIST_REPORTS_DETAILS       REPORT                               32765
CDB_ILMDATAMOVEMENTPOLICIES    ACTION_CLAUSE                        32765
CDB_JSON_DATAGUIDES            DATAGUIDE                            32765
CDB_OUTLINE_HINTS              HINT                                 32765
CDB_SCHEDULER_JOBS             PROGRAM_NAME                         16000
CDB_SCHEDULER_JOBS             PROGRAM_OWNER                        16000
CDB_SCHEDULER_JOBS             SCHEDULE_NAME                        16000
CDB_SCHEDULER_JOBS             SCHEDULE_OWNER                       16000
CDB_SCHEDULER_JOB_ROLES        PROGRAM_NAME                         16000
CDB_SCHEDULER_JOB_ROLES        PROGRAM_OWNER                        16000
CDB_SCHEDULER_JOB_ROLES        SCHEDULE_NAME                        16000
CDB_SCHEDULER_JOB_ROLES        SCHEDULE_OWNER                       16000
CDB_SCHEDULER_WINDOWS          SCHEDULE_NAME                        16000
CDB_SCHEDULER_WINDOWS          SCHEDULE_OWNER                       16000
CDB_STAT_EXTENSIONS            EXTENSION                            32765
CDB_TUNE_MVIEW                 STATEMENT                            32765
CDB_UNIFIED_AUDIT_TRAIL        RLS_INFO                             32765
CDB_UNIFIED_AUDIT_TRAIL        SQL_BINDS                            32765
CDB_UNIFIED_AUDIT_TRAIL        SQL_TEXT                             32765
DBA_ADVISOR_OBJECTS            ATTR4                                32765
DBA_APPLY_ERROR_MESSAGES       MESSAGE                              32765
DBA_APP_ERRORS                 APP_STATEMENT                        32765
DBA_APP_STATEMENTS             APP_STATEMENT                        32765
DBA_AW_PROP                    FULL_PROPERTY_VALUE                  32765
DBA_CAPTURE                    CLIENT_NAME                          16000
DBA_COMMON_AUDIT_TRAIL         RLS_INFO                             32765
DBA_COMMON_AUDIT_TRAIL         SQL_BIND                             32766
DBA_COMMON_AUDIT_TRAIL         SQL_TEXT                             32766
DBA_CQ_NOTIFICATION_QUERIES    QUERYTEXT                            32765
DBA_GOLDENGATE_INBOUND         REPLICAT_NAME                        16000
DBA_HIST_REPORTS_DETAILS       REPORT                               32765
DBA_ILMDATAMOVEMENTPOLICIES    ACTION_CLAUSE                        32765
DBA_JSON_DATAGUIDES            DATAGUIDE                            32765
DBA_OUTLINE_HINTS              HINT                                 32765
DBA_SCHEDULER_JOBS             PROGRAM_NAME                         16000
DBA_SCHEDULER_JOBS             PROGRAM_OWNER                        16000
DBA_SCHEDULER_JOBS             SCHEDULE_NAME                        16000
DBA_SCHEDULER_JOBS             SCHEDULE_OWNER                       16000
DBA_SCHEDULER_JOB_ROLES        PROGRAM_NAME                         16000
DBA_SCHEDULER_JOB_ROLES        PROGRAM_OWNER                        16000
DBA_SCHEDULER_JOB_ROLES        SCHEDULE_NAME                        16000
DBA_SCHEDULER_JOB_ROLES        SCHEDULE_OWNER                       16000
DBA_SCHEDULER_PROGRAM_ARGS     DEFAULT_ANYDATA_VALUE                 4408
DBA_SCHEDULER_WINDOWS          SCHEDULE_NAME                        16000
DBA_SCHEDULER_WINDOWS          SCHEDULE_OWNER                       16000
DBA_SQLTUNE_BINDS              VALUE                                 4408
DBA_STAT_EXTENSIONS            EXTENSION                            32765
DBA_TUNE_MVIEW                 STATEMENT                            32765
DBA_UNUSED_OBJPRIVS_PATH       PATH                                  4408
DBA_UNUSED_PRIVS               PATH                                  4408
DBA_UNUSED_SYSPRIVS_PATH       PATH                                  4408
DBA_UNUSED_USERPRIVS_PATH      PATH                                  4408
EXU8JBQ                        NLSENV                                8000
EXU8JBQ                        WHAT                                  8000
EXU8JBQU                       NLSENV                                8000
EXU8JBQU                       WHAT                                  8000
EXU9FGA                        POLTXT                                8000
GV_$ADVISOR_CURRENT_SQLPLAN    OTHER_XML                            32765
GV_$ALL_SQL_MONITOR            BINDS_XML                            32765
GV_$ALL_SQL_MONITOR            OTHER_XML                            32765
GV_$ALL_SQL_PLAN               OTHER_XML                            32765
GV_$ALL_SQL_PLAN_MONITOR       OTHER_XML                            32765
GV_$CELL_CONFIG                CONFVAL                              32765
GV_$CELL_CONFIG_INFO           CONFVAL                              32765
GV_$CELL_STATE                 STATISTICS_VALUE                     32765
GV_$MAPPED_SQL                 MAPPED_SQL_FULLTEXT                  32765
GV_$MAPPED_SQL                 SQL_FULLTEXT                         32765
GV_$SQL                        SQL_FULLTEXT                         32765
GV_$SQLAREA                    SQL_FULLTEXT                         32765
GV_$SQLAREA_PLAN_HASH          SQL_FULLTEXT                         32765
GV_$SQLSTATS                   SQL_FULLTEXT                         32765
GV_$SQLSTATS_PLAN_HASH         SQL_FULLTEXT                         32765
GV_$SQL_MONITOR                BINDS_XML                            32765
GV_$SQL_MONITOR                OTHER_XML                            32765
GV_$SQL_PLAN                   OTHER_XML                            32765
GV_$SQL_PLAN_MONITOR           OTHER_XML                            32765
GV_$SQL_PLAN_STATISTICS_ALL    OTHER_XML                            32765
GV_$SQL_SHARED_CURSOR          REASON                               32765
GV_$SQL_SHARED_MEMORY          SQL_FULLTEXT                         32765
GV_$SQL_TESTCASES              SQL_TEXT_FULL                        32765
GV_$UNIFIED_AUDIT_TRAIL        RLS_INFO                             32765
GV_$UNIFIED_AUDIT_TRAIL        SQL_BINDS                            32765
GV_$UNIFIED_AUDIT_TRAIL        SQL_TEXT                             32765
HS_PARALLEL_PARTITION_DATA     HIGH_VALUE                            4408
HS_PARALLEL_PARTITION_DATA     LOW_VALUE                             4408
INT$DBA_APP_STATEMENTS         LONGSQLTXT                           32765
INT$DBA_JSON_DATAGUIDES        DATAGUIDE                            32765
KU$_10_1_COMMENT_VIEW          CMNT                                 32765
KU$_10_2_TRIGGER_VIEW          BODY                                 32765
KU$_11_2_TRIGGER_VIEW          BODY                                 32765
KU$_11_2_VIEW_VIEW             TEXT                                 32765
KU$_12_1_TRIGGER_VIEW          BODY                                 32765
KU$_CLUSTER_VIEW               FUNC_CLOB                            32765
KU$_COLUMN_VIEW                BINARYDEFVAL                         32765
KU$_COLUMN_VIEW                DEFAULT_VALC                         32765
KU$_COMMENT_VIEW               CMNT                                 32765
KU$_CONSTRAINT1_VIEW           CONDITION                            32765
KU$_DIMENSION_VIEW             DIMTEXT                              32765
KU$_FGA_POLICY_VIEW            PTXT                                 32765
KU$_IND_COMPART_VIEW           HIBOUNDVALC                          32765
KU$_IND_PART_VIEW              HIBOUNDVALC                          32765
KU$_JOB_VIEW                   INTERVAL_NUM                          8000
KU$_JOB_VIEW                   NLSENV                               32765
KU$_JOB_VIEW                   WHAT                                 32765
KU$_M_VIEW_VIEW                QUERY_TXT                            32765
KU$_M_VIEW_VIEW_BASE           QUERY_TXT                            32765
KU$_M_ZONEMAP_VIEW             QUERY_TXT                            32765
KU$_OUTLINE_VIEW               SQL_TEXT                             32765
KU$_P2TCOLUMN_VIEW             BINARYDEFVAL                         32765
KU$_P2TCOLUMN_VIEW             DEFAULT_VALC                         32765
KU$_P2TPARTCOL_VIEW            BINARYDEFVAL                         32765
KU$_P2TPARTCOL_VIEW            DEFAULT_VALC                         32765
KU$_P2T_CON1A_VIEW             CONDITION                            32765
KU$_P2T_CON1B_VIEW             CONDITION                            32765
KU$_P2T_CONSTRAINT1_VIEW       CONDITION                            32765
KU$_PCOLUMN_VIEW               BINARYDEFVAL                         32765
KU$_PCOLUMN_VIEW               DEFAULT_VALC                         32765
KU$_PIOT_PART_VIEW             HIBOUNDVALC                          32765
KU$_PRIM_COLUMN_VIEW           BINARYDEFVAL                         32765
KU$_PRIM_COLUMN_VIEW           DEFAULT_VALC                         32765
KU$_QTRANS_VIEW                SQL_EXPRESSION                       32765
KU$_SIMPLE_COL_VIEW            DEFAULT_VALC                         32765
KU$_SIMPLE_PKREF_COL_VIEW      DEFAULT_VALC                         32765
KU$_SIMPLE_SETID_COL_VIEW      DEFAULT_VALC                         32765
KU$_SP2TCOLUMN_VIEW            BINARYDEFVAL                         32765
KU$_SP2TCOLUMN_VIEW            DEFAULT_VALC                         32765
KU$_SP2TPARTCOL_VIEW           BINARYDEFVAL                         32765
KU$_SP2TPARTCOL_VIEW           DEFAULT_VALC                         32765
KU$_SP2T_CON1A_VIEW            CONDITION                            32765
KU$_SP2T_CONSTRAINT1_VIEW      CONDITION                            32765
KU$_TAB_COMPART_VIEW           HIBOUNDVALC                          32765
KU$_TAB_PART_VIEW              HIBOUNDVALC                          32765
KU$_TAB_SUBPART_VIEW           HIBOUNDVALC                          32765
KU$_TAB_TSUBPART_VIEW          HIBOUNDVALC                          32765
KU$_TRIGGER_VIEW               BODY                                 32765
KU$_VIEW_VIEW                  TEXT                                 32765
KU$_XMLSCHEMA_VIEW             SCHEMA_VAL                           32765
KU$_XMLSCHEMA_VIEW             STRIPPED_VAL                         32765
KU$_XSINST_RULE_VIEW           RULE                                  8000
KU$_ZM_VIEW_VIEW               QUERY_TXT                            32765
MDX_ODBO_CUBES                 CUBE_CAPTION                         32765
MDX_ODBO_CUBES                 DESCRIPTION                          32765
MDX_ODBO_DIMENSIONS            DESCRIPTION                          32765
MDX_ODBO_DIMENSIONS            DIMENSION_CAPTION                    32765
MDX_ODBO_DIMENSIONS            DIMENSION_NAME                       32765
MDX_ODBO_HIERARCHIES           DESCRIPTION                          32765
MDX_ODBO_HIERARCHIES           HIERARCHY_CAPTION                    32765
MDX_ODBO_LEVELS                DESCRIPTION                          32765
MDX_ODBO_LEVELS                LEVEL_CAPTION                        32765
MDX_ODBO_MEASURES              DESCRIPTION                          32765
MDX_ODBO_MEASURES              MEASURE_CAPTION                      32765
MDX_ODBO_PROPERTIES            DESCRIPTION                          32765
MDX_ODBO_PROPERTIES            PROPERTY_CAPTION                     32765
OPATCH_SQL_PATCHES             NODE_NAMES                           32000
ORDDCM_ANON_ATTRS              TAG_DESC                              7996
ORDDCM_ANON_ATTRS_TMP          TAG_DESC                              7996
ORDDCM_ANON_ATTRS_USR          TAG_DESC                              7996
ORDDCM_ANON_ATTRS_WRK          TAG_DESC                              7996
ORDDCM_CONFORMANCE_VLD_MSGS    MESSAGE                               7996
ORDDCM_CT_ACTION               DESCRIPTION                           7996
ORDDCM_CT_ACTION_TMP           DESCRIPTION                           7996
ORDDCM_CT_ACTION_USR           DESCRIPTION                           7996
ORDDCM_CT_ACTION_WRK           DESCRIPTION                           7996
ORDDCM_CT_LOCATORPATHS         LOCATOR_PATH                          7996
ORDDCM_CT_LOCATORPATHS_TMP     LOCATOR_PATH                          7996
ORDDCM_CT_LOCATORPATHS_USR     LOCATOR_PATH                          7996
ORDDCM_CT_LOCATORPATHS_WRK     LOCATOR_PATH                          7996
ORDDCM_CT_PRED                 DESCRIPTION                           7996
ORDDCM_CT_PRED_PAR             PARVAL                                7996
ORDDCM_CT_PRED_PAR_TMP         PARVAL                                7996
ORDDCM_CT_PRED_PAR_USR         PARVAL                                7996
ORDDCM_CT_PRED_PAR_WRK         PARVAL                                7996
ORDDCM_CT_PRED_SET             DESCRIPTION                           7996
ORDDCM_CT_PRED_SET_TMP         DESCRIPTION                           7996
ORDDCM_CT_PRED_SET_USR         DESCRIPTION                           7996
ORDDCM_CT_PRED_SET_WRK         DESCRIPTION                           7996
ORDDCM_CT_PRED_TMP             DESCRIPTION                           7996
ORDDCM_CT_PRED_USR             DESCRIPTION                           7996
ORDDCM_CT_PRED_WRK             DESCRIPTION                           7996
ORDDCM_CT_VLD_MSG              MESSAGE                               7996
ORDDCM_MAPPED_PATHS            REL_PATH                              7996
ORDDCM_MAPPED_PATHS_TMP        REL_PATH                              7996
ORDDCM_MAPPED_PATHS_USR        REL_PATH                              7996
ORDDCM_MAPPED_PATHS_WRK        REL_PATH                              7996
ORDDCM_RT_PREF_PARAMS          PARAM_DESC                            7996
ORDDCM_RT_PREF_PARAMS          VALUE                                 7996
ORDDCM_RT_PREF_PARAMS_TMP      PARAM_DESC                            7996
ORDDCM_RT_PREF_PARAMS_TMP      VALUE                                 7996
ORDDCM_RT_PREF_PARAMS_USR      PARAM_DESC                            7996
ORDDCM_RT_PREF_PARAMS_USR      VALUE                                 7996
ORDDCM_RT_PREF_PARAMS_WRK      PARAM_DESC                            7996
ORDDCM_RT_PREF_PARAMS_WRK      VALUE                                 7996
ORDDCM_UID_DEFS                UID_DESC                              7996
ORDDCM_UID_DEFS_TMP            UID_DESC                              7996
ORDDCM_UID_DEFS_USR            UID_DESC                              7996
ORDDCM_UID_DEFS_WRK            UID_DESC                              7996
PATH_VIEW                      PATH                                  4096
SCHEDULER_PROGRAM_ARGS         DEFAULT_ANYDATA_VALUE                 4408
SYSDBIMFS_METADATA$            VALUE                                 4096
UNIFIED_AUDIT_TRAIL            RLS_INFO                             32765
UNIFIED_AUDIT_TRAIL            SQL_BINDS                            32765
UNIFIED_AUDIT_TRAIL            SQL_TEXT                             32765
USER_ADVISOR_OBJECTS           ATTR4                                32765
USER_AW_PROP                   FULL_PROPERTY_VALUE                  32765
USER_CQ_NOTIFICATION_QUERIES   QUERYTEXT                            32765
USER_ILMDATAMOVEMENTPOLICIES   ACTION_CLAUSE                        32765
USER_JSON_DATAGUIDES           DATAGUIDE                            32765
USER_OUTLINE_HINTS             HINT                                 32765
USER_SCHEDULER_JOBS            PROGRAM_NAME                         16000
USER_SCHEDULER_JOBS            PROGRAM_OWNER                        16000
USER_SCHEDULER_JOBS            SCHEDULE_NAME                        16000
USER_SCHEDULER_JOBS            SCHEDULE_OWNER                       16000
USER_SCHEDULER_PROGRAM_ARGS    DEFAULT_ANYDATA_VALUE                 4408
USER_SDO_3DTXFMS               AFFINE_PARAMETERS                     4408
USER_SDO_3DTXFMS               TXFM_SERIES_IDS                       4408
USER_SDO_GEOR_SYSDATA          OTHER_TABLE_NAMES                     4408
USER_SQLTUNE_BINDS             VALUE                                 4408
USER_STAT_EXTENSIONS           EXTENSION                            32765
USER_SUBSCR_REGISTRATIONS      ANY_CONTEXT                           4408
USER_TUNE_MVIEW                STATEMENT                            32765
V_$ADVISOR_CURRENT_SQLPLAN     OTHER_XML                            32765
V_$ALL_SQL_MONITOR             BINDS_XML                            32765
V_$ALL_SQL_MONITOR             OTHER_XML                            32765
V_$ALL_SQL_PLAN                OTHER_XML                            32765
V_$ALL_SQL_PLAN_MONITOR        OTHER_XML                            32765
V_$CELL_CONFIG                 CONFVAL                              32765
V_$CELL_CONFIG_INFO            CONFVAL                              32765
V_$CELL_STATE                  STATISTICS_VALUE                     32765
V_$DIAG_LOG_EXT                SUPPLEMENTAL_DETAILS                  4003
V_$MAPPED_SQL                  MAPPED_SQL_FULLTEXT                  32765
V_$MAPPED_SQL                  SQL_FULLTEXT                         32765
V_$SQL                         SQL_FULLTEXT                         32765
V_$SQLAREA                     SQL_FULLTEXT                         32765
V_$SQLAREA_PLAN_HASH           SQL_FULLTEXT                         32765
V_$SQLSTATS                    SQL_FULLTEXT                         32765
V_$SQLSTATS_PLAN_HASH          SQL_FULLTEXT                         32765
V_$SQL_MONITOR                 BINDS_XML                            32765
V_$SQL_MONITOR                 OTHER_XML                            32765
V_$SQL_PLAN                    OTHER_XML                            32765
V_$SQL_PLAN_MONITOR            OTHER_XML                            32765
V_$SQL_PLAN_STATISTICS_ALL     OTHER_XML                            32765
V_$SQL_SHARED_CURSOR           REASON                               32765
V_$SQL_SHARED_MEMORY           SQL_FULLTEXT                         32765
V_$SQL_TESTCASES               SQL_TEXT_FULL                        32765
V_$UNIFIED_AUDIT_TRAIL         RLS_INFO                             32765
V_$UNIFIED_AUDIT_TRAIL         SQL_BINDS                            32765
V_$UNIFIED_AUDIT_TRAIL         SQL_TEXT                             32765
WM$MW_VERSIONS_VIEW_9I         SEEN_BY                              32765
_DBA_APPLY_ERROR_TXN           MESSAGE                               4408
_DBA_STREAMS_COMPONENT         COMPONENT_NAME                        4525
_DBA_STREAMS_COMPONENT_LINK    DEST_COMPONENT_NAME                   4525
_DBA_STREAMS_COMPONENT_LINK    SOURCE_COMPONENT_NAME                 4525
_DBA_STREAMS_MSG_NOTIFICATIONS ANY_CONTEXT                           4408
_DBA_STREAMS_TRANSFORMATIONS   COLUMN_VALUE                          4408
_user_stat                     CL1                                  32765

Now I could use the database configuration assistant to build a template based on this empty database, save the data files, and now I’ll get much quicker creation next time.

So if you are looking to use larger strings, perhaps take this opportunity to consider building your database from scratch and then using DataPump to import your existing data in order to get access to the full benefits of bigger strings.

2 comments

  1. Don’t have one of those snazzy new databases to hand, but I can see in XE 18c the DBA_VIEWS and DBA_CONSTRAINTS use a function SYS.GETLONG to convert the underlying LONG value into a VARCHAR2. That maps to CDBVIEW package GetLong. Unusually for Oracle, that is unwrapped and I can see the ‘retval’ defined as a VARCHAR2(4000) while the function is defined as returning a VARCHAR2.
    So my question is, in the ‘from scratch’ database, is there a different/later version of the CDBVIEW package with an increased variable size, or is the apparent 32767 size just an artefact of returning a a VARCHAR2 of indeterminate length from a PL/SL function.

Got some thoughts? Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.