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.
Learning is not a spectator sport 
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.
Funny you should say that … because I found the same, and found someone had already logged a bug on precisely that.