DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS._BASE_OPT_FINDING_OBJ

Object Details
Object Name: _BASE_OPT_FINDING_OBJ
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
F_ID NUMBER
Yes
F_OBJ# NUMBER
Yes
OBJ_TYPE NUMBER
Yes
COL_LIST RAW (128)
CVEC_SIZE NUMBER
Yes
NOTES XMLTYPE (64)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT F_ID
,      F_OBJ#
,      OBJ_TYPE
,      COL_LIST
,      CVEC_SIZE
,      NOTES
FROM SYS._BASE_OPT_FINDING_OBJ;

Dependencies

[top of page]

SYS._BASE_OPT_FINDING_OBJ references the following:

SchemaSYS
TableOPT_FINDING_OBJ$
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE
SYS._BASE_OPT_FINDING_OBJ is referenced by following:

SchemaSYS
ViewDBA_SQL_PLAN_DIR_OBJECTS
View_BASE_OPT_FINDING_OBJ_COL