DBMS_WORKLOAD_CAPTURE
package is part of the Oracle Real Application Testing optionDBMS_WORKLOAD_REPLAY
package is part of the Oracle Real Application Testing optionDBMS_SQLPA
package is part of Oracle Real Application Testing optionDBMS_SQLTUNE
package, provide an interface to manage SQL tuning sets and are part of the Oracle Real Application Testing option:ADD_SQLSET_REFERENCE
CAPTURE_CURSOR_CACHE_SQLSET
CREATE_SQLSET
CREATE_STGTAB_SQLSET
DELETE_SQLSET
DROP_SQLSET
LOAD_SQLSET
PACK_STGTAB_SQLSET
REMOVE_SQLSET_REFERENCE
SELECT_CURSOR_CACHE
SELECT_SQLSET
SELECT_WORKLOAD_REPOSITORY
UNPACK_STGTAB_SQLSET
UPDATE_SQLSET
SDO_AGGR_UNION
spatial aggregate functionSDO_GEOM
package subprograms: SDO_GEOM.RELATE
, SDO_GEOM.SDO_DIFFERENCE
, SDO_GEOM.SDO_INTERSECTION
, SDO_GEOM.SDO_UNION
, SDO_GEOM.SDO_VOLUME
, and SDO_GEOM.SDO_XOR
oracle
.spatial
.geometry
(sdoapi
.jar
) and oracle
.spatial
.util
(sdoutil
.jar
) packages of the Spatial Java APISDO_SAM
package)SDO_WFS_PROCESS
and SDO_WFS_LOCK
packages), and Catalog services for the Web (CSW) support (SDO_CSW_PROCESS
package)ALTER
TABLE
)Licensed Page/Link | How to Access |
---|---|
Application Data Models | From the Enterprise Summary home page, click the Enterprisemenu, then QualityManagement, then Application Data Models. From the Oracle database or cluster database target home page, click the Schemamenu, then Application Data Models. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack. |
Data Masking Definitions | From the Enterprise Summary home page, click the Enterprisemenu, then QualityManagement, then DataMaskingDefinitions. From the Oracle database or cluster database target home page, click the Schemamenu, then DataMaskingDefinitions. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack. |
Data Masking Format Library | From the Enterprise Summary home page, click the Enterprisemenu, then QualityManagement, then DataMaskingFormats. From the Oracle database or cluster database target home page, click the Schemamenu, then DataMaskingFormatLibrary. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack. |
Data Subset Definitions | From the Enterprise Summary home page, click the Enterprisemenu, then QualityManagement, then DataSubsetDefinitions. From the Oracle database or cluster database target home page, click the Schemamenu, then DataSubsetting. All features, functions, links, buttons, and drill-downs on these menus are licensed as part of the Oracle Data Masking and Subsetting Pack. |
CONTROL_MANAGEMENT_PACK_ACCESS
, controls access to the Diagnostic Pack and Tuning Pack. This parameter can be set to one of three values:DIAGNOSTIC+TUNING
: Diagnostic Pack and Tuning Pack functionally is enabled in the database server.DIAGNOSTIC
: Only Diagnostic Pack functionality is enabled in the server.NONE
: Diagnostic Pack and Tuning pack functionally is disabled in the database server.DBMS_WORKLOAD_REPOSITORY
package is part of this pack.DBMS_ADDM
package is part of this pack.DBMS_ADVISOR
package is part of this pack if you specify ADDM as the value of the advisor_name
parameter, or if you specify for the value of the task_name
parameter any value starting with the ADDM prefix.V$ACTIVE_SESSION_HISTORY
dynamic performance view and its underlying table, X$ASH
, are part of this pack.DBA_STREAMS_TP_PATH_BOTTLENECK
view is part of this pack.DBA_ADDM_
are part of this pack.DBA_STREAMS_TP_COMPONENT_STAT
requires the Diagnostic Pack. The following filter clause to any query on DBA_STREAMS_TP_COMPONENT_STAT
shows Diagnostic-Pack-dependent data:DBA_HIST_
are part of this pack, along with their underlying tables.The only exception are the views: DBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE, DBA_HIST_SNAP_ERROR, DBA_HIST_SEG_STAT, DBA_HIST_SEG_STAT_OBJ,
and DBA_HIST_UNDOSTAT
. They can be used without the Diagnostic Pack license.DBA_ADVISOR_
are part of this pack if queries to these views return rows with the value ADDM
in the ADVISOR_NAME
column or a value of ADDM*
in the TASK_NAME
column or the corresponding TASK_ID
.CONTROL_MANAGEMENT_PACK_ACCESS
, is introduced to control access to the Diagnostic Pack and Tuning Pack in the database server. This parameter can be set to one of three values:DIAGNOSTIC+TUNING
: Diagnostic Pack and Tuning Pack functionally is enabled in the database server.DIAGNOSTIC
: Only Diagnostic Pack functionality is enabled in the server.NONE
: Diagnostic Pack and Tuning pack functionally is disabled in the database server.DBMS_SQLTUNE
DBMS_ADVISOR
, when the value of the advisor_name
parameter is either SQL Tuning Advisor or SQL Access Advisor.V$SQL_MONITOR
V$SQL_PLAN_MONITOR