Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
This section describes new features of Oracle Database 10g release 2 (10.2) and provides pointers to additional information. New features information from release 1 (10.1) is also retained to help those users upgrading to the current release. For information on features that were new in earlier releases of the Oracle Database, refer to the documentation for the earlier release.
The following sections describe the new features in Oracle Database Reference:
The following initialization parameters are new to release 10.2:
AUDIT_SYSLOG_LEVEL
COMMIT_WRITE
OPTIMIZER_SECURE_VIEW_MERGING
PLSQL_CCFLAGS
RECYCLEBIN
See Also:
Part I, "Initialization Parameters" for more information about these initialization parametersThe following static data dictionary views are new to release 10.2:
ALL_ Views | DBA_ Views | USER_ Views |
---|---|---|
ALL_DEQUEUE_QUEUES |
||
DBA_APPLY_OBJECT_DEPENDENCIES |
||
DBA_APPLY_SPILL_TXN |
||
DBA_APPLY_VALUE_DEPENDENCIES |
||
DBA_AUTO_SEGADV_CTL |
||
DBA_AUTO_SEGADV_SUMMARY |
||
DBA_CHANGE_NOTIFICATION_REGS |
USER_CHANGE_NOTIFICATION_REGS |
|
DBA_CONNECT_ROLE_GRANTEES |
||
DBA_CPU_USAGE_STATISTICS |
||
ALL_ENCRYPTED_COLUMNS |
DBA_ENCRYPTED_COLUMNS |
USER_ENCRYPTED_COLUMNS |
ALL_FILE_GROUP_EXPORT_INFO |
DBA_FILE_GROUP_EXPORT_INFO |
USER_FILE_GROUP_EXPORT_INFO |
ALL_FILE_GROUP_FILES |
DBA_FILE_GROUP_FILES |
USER_FILE_GROUP_FILES |
ALL_FILE_GROUP_TABLES |
DBA_FILE_GROUP_TABLES |
USER_FILE_GROUP_TABLES |
ALL_FILE_GROUP_TABLESPACES |
DBA_FILE_GROUP_TABLESPACES |
USER_FILE_GROUP_TABLESPACES |
ALL_FILE_GROUP_VERSIONS |
DBA_FILE_GROUP_VERSIONS |
USER_FILE_GROUP_VERSIONS |
ALL_FILE_GROUPS |
DBA_FILE_GROUPS |
USER_FILE_GROUPS |
DBA_HIST_BUFFERED_QUEUES |
||
DBA_HIST_BUFFERED_SUBSCRIBERS |
||
DBA_HIST_COMP_IOSTAT |
||
DBA_HIST_PROCESS_MEM_SUMMARY |
||
DBA_HIST_RULE_SET |
||
DBA_HIST_SESS_TIME_STATS |
||
DBA_HIST_SGA_TARGET_ADVICE |
||
DBA_HIST_SQL_BIND_METADATA |
||
DBA_HIST_STREAMS_APPLY_SUM |
||
DBA_HIST_STREAMS_CAPTURE |
||
DBA_HIST_STREAMS_POOL_ADVICE |
||
ALL_QUEUE_SUBSCRIBERS |
DBA_QUEUE_SUBSCRIBERS |
USER_QUEUE_SUBSCRIBERS |
DBA_RECOVERABLE_SCRIPT |
||
DBA_RECOVERABLE_SCRIPT_BLOCKS |
||
DBA_RECOVERABLE_SCRIPT_ERRORS |
||
DBA_RECOVERABLE_SCRIPT_PARAMS |
||
DBA_REGISTRY_HISTORY |
||
DBA_REGISTRY_LOG |
||
DBA_RESOURCE_INCARNATIONS |
||
ALL_SCHEDULER_CHAIN_RULES |
DBA_SCHEDULER_CHAIN_RULES |
USER_SCHEDULER_CHAIN_RULES |
ALL_SCHEDULER_CHAIN_STEPS |
DBA_SCHEDULER_CHAIN_STEPS |
USER_SCHEDULER_CHAIN_STEPS |
ALL_SCHEDULER_CHAINS |
DBA_SCHEDULER_CHAINS |
USER_SCHEDULER_CHAINS |
ALL_SCHEDULER_RUNNING_CHAINS |
DBA_SCHEDULER_RUNNING_CHAINS |
USER_SCHEDULER_RUNNING_CHAINS |
DBA_SEGMENTS_OLD |
||
ALL_SQLSET |
||
ALL_SQLSET_BINDS |
||
ALL_SQLSET_PLANS |
DBA_SQLSET_PLANS |
USER_SQLSET_PLANS |
ALL_SQLSET_REFERENCES |
||
ALL_SQLSET_STATEMENTS |
||
DBA_STREAMS_ADD_COLUMN |
||
DBA_STREAMS_DELETE_COLUMN |
||
DBA_STREAMS_RENAME_COLUMN |
||
DBA_STREAMS_RENAME_SCHEMA |
||
DBA_STREAMS_RENAME_TABLE |
||
DBA_STREAMS_TRANSFORMATIONS |
||
DBA_TSM_DESTINATION |
||
DBA_TSM_SOURCE |
||
DBA_WORKSPACE_SESSIONS |
||
ALL_WORKSPACES |
DBA_WORKSPACES |
USER_WORKSPACES |
See Also:
Part II, "Static Data Dictionary Views" for more information about these static data dictionary viewsThe following dynamic performance views are new to release 10.2:
GV$ Views | V$ Views |
---|---|
GV$ASM_DISK_STAT |
V$ASM_DISK_STAT |
GV$ASM_DISKGROUP_STAT |
V$ASM_DISKGROUP_STAT |
V$BACKUP_ARCHIVELOG_DETAILS |
|
V$BACKUP_ARCHIVELOG_SUMMARY |
|
V$BACKUP_CONTROLFILE_DETAILS |
|
V$BACKUP_CONTROLFILE_SUMMARY |
|
V$BACKUP_COPY_DETAILS |
|
V$BACKUP_COPY_SUMMARY |
|
V$BACKUP_DATAFILE_DETAILS |
|
V$BACKUP_DATAFILE_SUMMARY |
|
V$BACKUP_PIECE_DETAILS |
|
V$BACKUP_SET_DETAILS |
|
V$BACKUP_SET_SUMMARY |
|
V$BACKUP_SPFILE_DETAILS |
|
V$BACKUP_SPFILE_SUMMARY |
|
GV$BLOCKING_QUIESCE |
V$BLOCKING_QUIESCE |
GV$CLUSTER_INTERCONNECTS |
V$CLUSTER_INTERCONNECTS |
GV$CONFIGURED_INTERCONNECTS |
V$CONFIGURED_INTERCONNECTS |
V$DATAGUARD_STATS |
|
V$DB_TRANSPORTABLE_PLATFORM |
|
V$FLASH_RECOVERY_AREA_USAGE |
|
GV$LOGMNR_DICTIONARY_LOAD |
V$LOGMNR_DICTIONARY_LOAD |
GV$LOGSTDBY_PROCESS |
V$LOGSTDBY_PROCESS |
GV$LOGSTDBY_PROGRESS |
V$LOGSTDBY_PROGRESS |
GV$LOGSTDBY_STATE |
V$LOGSTDBY_STATE |
GV$LOGSTDBY_TRANSACTION |
V$LOGSTDBY_TRANSACTION |
GV$MUTEX_SLEEP |
V$MUTEX_SLEEP |
GV$MUTEX_SLEEP_HISTORY |
V$MUTEX_SLEEP_HISTORY |
GV$PROCESS_MEMORY |
V$PROCESS_MEMORY |
GV$PARAMETER_VALID_VALUES |
V$PARAMETER_VALID_VALUES |
V$PROXY_ARCHIVELOG_DETAILS |
|
V$PROXY_ARCHIVELOG_SUMMARY |
|
V$PROXY_COPY_DETAILS |
|
V$PROXY_COPY_SUMMARY |
|
GV$RESERVED_WORDS |
V$RESERVED_WORDS |
GV$RESTORE_POINT |
V$RESTORE_POINT |
GV$RFS_THREAD |
V$RFS_THREAD |
V$RMAN_BACKUP_JOB_DETAILS |
|
V$RMAN_BACKUP_SUBJOB_DETAILS |
|
V$RMAN_BACKUP_TYPE |
|
V$RMAN_ENCRYPTION_ALGORITHMS |
|
GV$RSRC_CONS_GROUP_HISTORY |
V$RSRC_CONS_GROUP_HISTORY |
GV$RSRC_PLAN_HISTORY |
V$RSRC_PLAN_HISTORY |
GV$RSRC_SESSION_INFO |
V$RSRC_SESSION_INFO |
GV$SCHEDULER_RUNNING_JOBS |
V$SCHEDULER_RUNNING_JOBS |
GV$SGA_TARGET_ADVICE |
V$SGA_TARGET_ADVICE |
GV$SQL_JOIN_FILTER |
V$SQL_JOIN_FILTER |
GV$SQLAREA_PLAN_HASH |
V$SQLAREA_PLAN_HASH |
GV$SQLSTATS |
V$SQLSTATS |
GV$STREAMS_POOL_ADVICE |
V$STREAMS_POOL_ADVICE |
GV$STREAMS_TRANSACTION |
V$STREAMS_TRANSACTION |
GV$TSM_SESSIONS |
V$TSM_SESSIONS |
V$UNUSABLE_BACKUPFILE_DETAILS |
|
GV$WALLET |
V$WALLET |
GV$XML_AUDIT_TRAIL |
V$XML_AUDIT_TRAIL |
See Also:
Part III, "Dynamic Performance Views" for more information about these dynamic performance viewsThe following static data dictionary views have new columns in release 10.2:
Static Data Dictionary Views | New Columns |
---|---|
ALL_DEF_AUDIT_OPTS |
REA |
ALL_PROPAGATION |
ERROR_DATE
|
ALL_SCHEDULER_JOBS |
SCHEDULE_TYPE |
ALL_SCHEDULER_PROGRAMS |
DETACHED |
ALL_SCHEDULER_RUNNING_CHAINS |
JOB_SUBNAME
|
ALL_SCHEDULER_RUNNING_JOBS |
SLAVE_OS_PROCESS_ID |
ALL_SCHEDULER_SCHEDULES |
SCHEDULE_TYPE |
ALL_SCHEDULER_WINDOW_GROUPS |
NEXT_START_DATE |
ALL_SCHEDULER_WINDOWS |
MANUAL_DURATION
|
ALL_SERVICES |
CLB_GOAL |
ALL_STREAMS_TRANSFORM_FUNCTION |
CUSTOM_TYPE |
DBA_ADVISOR_OBJECTS |
OTHER |
DBA_AUDIT_EXISTS |
ECONTEXT_ID |
DBA_AUDIT_OBJECT |
ECONTEXT_ID |
DBA_AUDIT_STATEMENT |
ECONTEXT_ID |
DBA_AUDIT_TRAIL |
ECONTEXT_ID |
DBA_COMMON_AUDIT_TRAIL |
OS_PRIVILEGE
|
DBA_FGA_AUDIT_TRAIL |
ECONTEXT_ID |
DBA_HIST_SQLSTAT |
FORCE_MATCHING_SIGNATURE
|
DBA_HIST_ACTIVE_SESS_HISTORY |
P1TEXT
|
DBA_PROPAGATION |
ERROR_DATE
|
DBA_REGISTERED_ARCHIVED_LOG |
RESETLOGS_CHANGE#
|
DBA_SCHEDULER_JOBS |
SCHEDULE_TYPE |
DBA_SCHEDULER_RUNNING_CHAINS |
JOB_SUBNAME
|
DBA_SCHEDULER_RUNNING_JOBS |
SLAVE_OS_PROCESS_ID |
DBA_SCHEDULER_SCHEDULES |
SCHEDULE_TYPE |
DBA_SCHEDULER_WINDOW_GROUPS |
NEXT_START_DATE |
DBA_SCHEDULER_WINDOWS |
MANUAL_DURATION
|
DBA_SERVICES |
CLB_GOAL |
DBA_SQLTUNE_STATISTICS |
DIRECT_WRITES |
DBA_STREAMS_TRANSFORM_FUNCTION |
CUSTOM_TYPE |
DBA_TS_QUOTAS |
DROPPED |
USER_AUDIT_OBJECT |
ECONTEXT_ID |
USER_AUDIT_STATEMENT |
ECONTEXT_ID |
USER_AUDIT_TRAIL |
ECONTEXT_ID |
USER_SCHEDULER_JOBS |
SCHEDULE_TYPE |
USER_SCHEDULER_RUNNING_CHAINS |
JOB_SUBNAME
|
USER_SCHEDULER_RUNNING_JOBS |
SLAVE_OS_PROCESS_ID |
USER_SCHEDULER_SCHEDULES |
SCHEDULE_TYPE |
USER_SQLTUNE_STATISTICS |
DIRECT_WRITES |
USER_TS_QUOTAS |
DROPPED |
See Also:
Part II, "Static Data Dictionary Views" for more information about the new columns in these static data dictionary viewsThe following dynamic performance views have new columns in release 10.2:
Dynamic Performance View | New Columns |
---|---|
V$ACTIVE_SESSION_HISTORY |
P1TEXT
|
V$ARCHIVE_DEST |
MAX_CONNECTIONS |
V$ARCHIVE_DEST_STATUS |
PROTECTION_REASON |
SYNCHRONIZED |
|
V$ARCHIVED_LOG |
END_OF_REDO_TYPE |
V$ASM_DISK |
PRODUCT |
V$ASM_DISKGROUP |
COMPATIBILITY |
DATABASE_COMPATIBILITY |
|
V$ASM_DISK_STAT |
PRODUCT |
V$BACKUP_DATAFILE |
USED_OPTIMIZATION |
V$BUFFERED_PUBLISHERS |
MEMORY_USAGE
|
V$DATAFILE |
FIRST_NONLOGGED_SCN
|
V$DATAFILE_HEADER |
LAST_DEALLOC_SCN
|
V$DB_OBJECT_CACHE |
INVALIDATIONS |
V$LATCHHOLDER |
GETS |
V$LICENSE |
CPU_COUNT_CURRENT
|
V$PROPAGATION_RECEIVER |
DST_QUEUE_NAME
|
V$PROPAGATION_SENDER |
DST_QUEUE_NAME
|
V$RECOVERY_PROGRESS |
START_TIME
|
V$RMAN_OUTPUT |
SESSION_KEY |
V$SERVICEMETRIC |
CALLSPERSEC
|
V$SERVICEMETRIC_HISTORY |
CALLSPERSEC
|
V$SESSION |
BLOCKING_INSTANCE |
V$SESSION_LONGOPS |
TIMESTAMP |
V$SQL |
BIND_DATA
|
V$SQL_SHARED_CURSOR |
MV_STALEOBJ_MISMATCH
|
V$SQLAREA |
BIND_DATA
|
V$STREAMS_APPLY_COORDINATOR |
ELAPSED_IDLE_TIME |
V$STREAMS_APPLY_READER |
ELAPSED_SPILL_TIME
|
V$STREAMS_CAPTURE |
STATE_CHANGED_TIME |
V$TABLESPACE |
ENCRYPT_IN_BACKUP |
V$THREAD |
LAST_REDO_CHANGE#
|
V$THRESHOLD_TYPES |
METRIC_VALUE_TYPE |
See Also:
Part III, "Dynamic Performance Views" for more information about the new columns in these dynamic performance viewsThe following initialization parameters are new to release 10.1:
ASM_DISKGROUPS
ASM_DISKSTRING
ASM_POWER_LIMIT
CREATE_STORED_OUTLINES
DB_FLASHBACK_RETENTION_TARGET
DB_RECOVERY_FILE_DEST
DB_RECOVERY_FILE_DEST_SIZE
DB_UNIQUE_NAME
DDL_WAIT_FOR_LOCKS
FILEIO_NETWORK_ADAPTERS
GCS_SERVER_PROCESSES
INSTANCE_TYPE
LDAP_DIRECTORY_ACCESS
LOG_ARCHIVE_CONFIG
LOG_ARCHIVE_LOCAL_FIRST
PLSQL_CODE_TYPE
PLSQL_DEBUG
PLSQL_OPTIMIZE_LEVEL
PLSQL_WARNINGS
RESUMABLE_TIMEOUT
SGA_TARGET
SKIP_UNUSABLE_INDEXES
SMTP_OUT_SERVER
SQLTUNE_CATEGORY
STREAMS_POOL_SIZE
See Also:
Part I, "Initialization Parameters" for more information about these initialization parametersThe following static data dictionary views are new to release 10.1:
ALL_ Views | DBA_ Views | USER_ Views |
---|---|---|
DBA_ADVISOR_ACTIONS |
USER_ADVISOR_ACTIONS |
|
DBA_ADVISOR_COMMANDS |
||
DBA_ADVISOR_DEFINITIONS |
||
DBA_ADVISOR_FINDINGS |
USER_ADVISOR_FINDINGS |
|
DBA_ADVISOR_JOURNAL |
USER_ADVISOR_JOURNAL |
|
DBA_ADVISOR_LOG |
USER_ADVISOR_LOG |
|
DBA_ADVISOR_OBJECT_TYPES |
||
DBA_ADVISOR_OBJECTS |
USER_ADVISOR_OBJECTS |
|
DBA_ADVISOR_PARAMETERS |
USER_ADVISOR_PARAMETERS |
|
DBA_ADVISOR_RATIONALE |
USER_ADVISOR_RATIONALE |
|
DBA_ADVISOR_RECOMMENDATIONS |
USER_ADVISOR_RECOMMENDATIONS |
|
DBA_ADVISOR_SQLA_REC_SUM |
USER_ADVISOR_SQLA_REC_SUM |
|
DBA_ADVISOR_SQLA_WK_MAP |
USER_ADVISOR_SQLA_WK_MAP |
|
DBA_ADVISOR_SQLA_WK_STMTS |
USER_ADVISOR_SQLA_WK_STMTS |
|
DBA_ADVISOR_SQLW_JOURNAL |
USER_ADVISOR_SQLW_JOURNAL |
|
DBA_ADVISOR_SQLW_PARAMETERS |
USER_ADVISOR_SQLW_PARAMETERS |
|
DBA_ADVISOR_SQLW_STMTS |
USER_ADVISOR_SQLW_STMTS |
|
DBA_ADVISOR_SQLW_SUM |
USER_ADVISOR_SQLW_SUM |
|
DBA_ADVISOR_SQLW_TABLES |
USER_ADVISOR_SQLW_TABLES |
|
DBA_ADVISOR_SQLW_TEMPLATES |
USER_ADVISOR_SQLW_TEMPLATES |
|
DBA_ADVISOR_TASKS |
USER_ADVISOR_TASKS |
|
DBA_ADVISOR_TEMPLATES |
USER_ADVISOR_TEMPLATES |
|
DBA_ADVISOR_USAGE |
||
DBA_ALERT_HISTORY |
||
ALL_APPLY_ENQUEUE |
DBA_APPLY_ENQUEUE |
|
ALL_APPLY_EXECUTE |
DBA_APPLY_EXECUTE |
|
DBA_APPLY_INSTANTIATED_GLOBAL |
||
DBA_APPLY_INSTANTIATED_SCHEMAS |
||
ALL_APPLY_TABLE_COLUMNS |
DBA_APPLY_TABLE_COLUMNS |
|
ALL_AUDIT_POLICY_COLUMNS |
DBA_AUDIT_POLICY_COLUMNS |
USER_AUDIT_POLICY_COLUMNS |
ALL_AW_PS |
||
ALL_AWS |
||
ALL_CAPTURE_EXTRA_ATTRIBUTES |
DBA_CAPTURE_EXTRA_ATTRIBUTES |
|
DBA_COMMON_AUDIT_TRAIL |
||
DBA_DATAPUMP_JOBS |
USER_DATAPUMP_JOBS |
|
DBA_DATAPUMP_SESSIONS |
||
DBA_ENABLED_AGGREGATIONS |
||
DBA_ENABLED_TRACES |
||
DBA_FEATURE_USAGE_STATISTICS |
||
DBA_HIGH_WATER_MARK_STATISTICS |
||
DBA_HIST_ACTIVE_SESS_HISTORY |
||
DBA_HIST_BASELINE |
||
DBA_HIST_BG_EVENT_SUMMARY |
||
DBA_HIST_BUFFER_POOL_STAT |
||
DBA_HIST_CR_BLOCK_SERVER |
||
DBA_HIST_CURRENT_BLOCK_SERVER |
||
DBA_HIST_DATABASE_INSTANCE |
||
DBA_HIST_DATAFILE |
||
DBA_HIST_DB_CACHE_ADVICE |
||
DBA_HIST_DLM_MISC |
||
DBA_HIST_ENQUEUE_STAT |
||
DBA_HIST_EVENT_NAME |
||
DBA_HIST_FILEMETRIC_HISTORY |
||
DBA_HIST_FILESTATXS |
||
DBA_HIST_INST_CACHE_TRANSFER |
||
DBA_HIST_INSTANCE_RECOVERY |
||
DBA_HIST_JAVA_POOL_ADVICE |
||
DBA_HIST_LATCH |
||
DBA_HIST_LATCH_CHILDREN |
||
DBA_HIST_LATCH_MISSES_SUMMARY |
||
DBA_HIST_LATCH_NAME |
||
DBA_HIST_LATCH_PARENT |
||
DBA_HIST_LIBRARYCACHE |
||
DBA_HIST_LOG |
||
DBA_HIST_METRIC_NAME |
||
DBA_HIST_MTTR_TARGET_ADVICE |
||
DBA_HIST_OPTIMIZER_ENV |
||
DBA_HIST_OSSTAT |
||
DBA_HIST_OSSTAT_NAME |
||
DBA_HIST_PARAMETER |
||
DBA_HIST_PARAMETER_NAME |
||
DBA_HIST_PGA_TARGET_ADVICE |
||
DBA_HIST_PGASTAT |
||
DBA_HIST_RESOURCE_LIMIT |
||
DBA_HIST_ROWCACHE_SUMMARY |
||
DBA_HIST_SEG_STAT |
||
DBA_HIST_SEG_STAT_OBJ |
||
DBA_HIST_SERVICE_NAME |
||
DBA_HIST_SERVICE_STAT |
||
DBA_HIST_SERVICE_WAIT_CLASS |
||
DBA_HIST_SESSMETRIC_HISTORY |
||
DBA_HIST_SGA |
||
DBA_HIST_SGASTAT |
||
DBA_HIST_SHARED_POOL_ADVICE |
||
DBA_HIST_SNAP_ERROR |
||
DBA_HIST_SNAPSHOT |
||
DBA_HIST_SQL_PLAN |
||
DBA_HIST_SQL_SUMMARY |
||
DBA_HIST_SQL_WORKAREA_HSTGRM |
||
DBA_HIST_SQLBIND |
||
DBA_HIST_SQLSTAT |
||
DBA_HIST_SQLTEXT |
||
DBA_HIST_STAT_NAME |
||
DBA_HIST_SYS_TIME_MODEL |
||
DBA_HIST_SYSMETRIC_HISTORY |
||
DBA_HIST_SYSMETRIC_SUMMARY |
||
DBA_HIST_SYSSTAT |
||
DBA_HIST_SYSTEM_EVENT |
||
DBA_HIST_TABLESPACE_STAT |
||
DBA_HIST_TBSPC_SPACE_USAGE |
||
DBA_HIST_TEMPFILE |
||
DBA_HIST_TEMPSTATXS |
||
DBA_HIST_THREAD |
||
DBA_HIST_UNDOSTAT |
||
DBA_HIST_WAITCLASSMET_HISTORY |
||
DBA_HIST_WAITSTAT |
||
DBA_HIST_WR_CONTROL |
||
ALL_IND_STATISTICS |
DBA_IND_STATISTICS |
USER_IND_STATISTICS |
ALL_INDEXTYPE_ARRAYTYPES |
DBA_INDEXTYPE_ARRAYTYPES |
USER_INDEXTYPE_ARRAYTYPES |
DBA_LOGMNR_LOG |
||
DBA_LOGMNR_PURGED_LOG |
||
DBA_LOGMNR_SESSION |
||
ALL_MVIEW_COMMENTS |
DBA_MVIEW_COMMENTS |
USER_MVIEW_COMMENTS |
ALL_NESTED_TABLE_COLS |
DBA_NESTED_TABLE_COLS |
USER_NESTED_TABLE_COLS |
DBA_OUTSTANDING_ALERTS |
||
ALL_PLSQL_OBJECT_SETTINGS |
DBA_PLSQL_OBJECT_SETTINGS |
USER_PLSQL_OBJECT_SETTINGS |
DBA_RECYCLEBIN |
USER_RECYCLEBIN |
|
DBA_REDEFINITION_ERRORS |
||
DBA_REDEFINITION_OBJECTS |
||
DBA_REGISTERED_ARCHIVED_LOG |
||
ALL_REWRITE_EQUIVALENCES |
DBA_REWRITE_EQUIVALENCES |
USER_REWRITE_EQUIVALENCES |
DBA_RSRC_GROUP_MAPPINGS |
||
DBA_RSRC_MAPPING_PRIORITY |
||
ALL_SCHEDULER_JOB_ARGS |
DBA_SCHEDULER_JOB_ARGS |
USER_SCHEDULER_JOB_ARGS |
ALL_SCHEDULER_JOB_CLASSES |
DBA_SCHEDULER_JOB_CLASSES |
|
ALL_SCHEDULER_JOB_LOG |
DBA_SCHEDULER_JOB_LOG |
USER_SCHEDULER_JOB_LOG |
ALL_SCHEDULER_JOB_RUN_DETAILS |
DBA_SCHEDULER_JOB_RUN_DETAILS |
USER_SCHEDULER_JOB_RUN_DETAILS |
ALL_SCHEDULER_JOBS |
DBA_SCHEDULER_JOBS |
USER_SCHEDULER_JOBS |
ALL_SCHEDULER_PROGRAM_ARGS |
DBA_SCHEDULER_PROGRAM_ARGS |
USER_SCHEDULER_PROGRAM_ARGS |
ALL_SCHEDULER_PROGRAMS |
DBA_SCHEDULER_PROGRAMS |
USER_SCHEDULER_PROGRAMS |
ALL_SCHEDULER_RUNNING_JOBS |
DBA_SCHEDULER_RUNNING_JOBS |
USER_SCHEDULER_RUNNING_JOBS |
ALL_SCHEDULER_SCHEDULES |
DBA_SCHEDULER_SCHEDULES |
USER_SCHEDULER_SCHEDULES |
ALL_SCHEDULER_WINDOW_DETAILS |
DBA_SCHEDULER_WINDOW_DETAILS |
|
ALL_SCHEDULER_WINDOW_GROUPS |
DBA_SCHEDULER_WINDOW_GROUPS |
|
ALL_SCHEDULER_WINDOW_LOG |
DBA_SCHEDULER_WINDOW_LOG |
|
ALL_SCHEDULER_WINDOWS |
DBA_SCHEDULER_WINDOWS |
|
ALL_SCHEDULER_WINGROUP_MEMBERS |
DBA_SCHEDULER_WINGROUP_MEMBERS |
|
ALL_SEC_RELEVANT_COLS |
DBA_SEC_RELEVANT_COLS |
USER_SEC_RELEVANT_COLS |
DBA_SERVER_REGISTRY |
||
ALL_SERVICES |
DBA_SERVICES |
|
DBA_SQL_PROFILES |
||
DBA_SQLSET |
USER_SQLSET |
|
DBA_SQLSET_BINDS |
USER_SQLSET_BINDS |
|
DBA_SQLSET_REFERENCES |
USER_SQLSET_REFERENCES |
|
DBA_SQLSET_STATEMENTS |
USER_SQLSET_STATEMENTS |
|
DBA_SQLTUNE_BINDS |
USER_SQLTUNE_BINDS |
|
DBA_SQLTUNE_PLANS |
USER_SQLTUNE_PLANS |
|
DBA_SQLTUNE_RATIONALE_PLAN |
USER_SQLTUNE_RATIONALE_PLAN |
|
DBA_SQLTUNE_STATISTICS |
USER_SQLTUNE_STATISTICS |
|
DBA_STREAMS_ADMINISTRATOR |
||
ALL_STREAMS_MESSAGE_CONSUMERS |
DBA_STREAMS_MESSAGE_CONSUMERS |
|
ALL_STREAMS_MESSAGE_RULES |
DBA_STREAMS_MESSAGE_RULES |
|
ALL_STREAMS_NEWLY_SUPPORTED |
DBA_STREAMS_NEWLY_SUPPORTED |
|
ALL_STREAMS_RULES |
DBA_STREAMS_RULES |
|
ALL_STREAMS_TRANSFORM_FUNCTION |
DBA_STREAMS_TRANSFORM_FUNCTION |
|
ALL_STREAMS_UNSUPPORTED |
DBA_STREAMS_UNSUPPORTED |
|
ALL_TAB_STATISTICS |
DBA_TAB_STATISTICS |
USER_TAB_STATISTICS |
DBA_TABLESPACE_GROUPS |
||
DBA_THRESHOLDS |
||
DBA_TUNE_MVIEW |
USER_TUNE_MVIEW |
|
ALL_WARNING_SETTINGS |
DBA_WARNING_SETTINGS |
USER_WARNING_SETTINGS |
See Also:
Part II, "Static Data Dictionary Views" for more information about these static data dictionary viewsThe following dynamic performance views are new to release 10.1:
GV$ Views | V$ Views |
---|---|
GV$ACTIVE_SERVICES |
V$ACTIVE_SERVICES |
GV$ACTIVE_SESSION_HISTORY |
V$ACTIVE_SESSION_HISTORY |
GV$ALERT_TYPES |
V$ALERT_TYPES |
GV$ASM_ALIAS |
V$ASM_ALIAS |
GV$ASM_CLIENT |
V$ASM_CLIENT |
GV$ASM_DISK |
V$ASM_DISK |
GV$ASM_DISKGROUP |
V$ASM_DISKGROUP |
GV$ASM_FILE |
V$ASM_FILE |
GV$ASM_OPERATION |
V$ASM_OPERATION |
GV$ASM_TEMPLATE |
V$ASM_TEMPLATE |
V$BACKUP_FILES |
|
V$BLOCK_CHANGE_TRACKING |
|
GV$BUFFERED_PUBLISHERS |
V$BUFFERED_PUBLISHERS |
GV$BUFFERED_QUEUES |
V$BUFFERED_QUEUES |
GV$BUFFERED_SUBSCRIBERS |
V$BUFFERED_SUBSCRIBERS |
GV$CLIENT_STATS |
V$CLIENT_STATS |
GV$CURRENT_BLOCK_SERVER |
V$CURRENT_BLOCK_SERVER |
GV$DATAGUARD_CONFIG |
V$DATAGUARD_CONFIG |
GV$DISPATCHER_CONFIG |
V$DISPATCHER_CONFIG |
GV$EVENT_HISTOGRAM |
V$EVENT_HISTOGRAM |
GV$EVENTMETRIC |
V$EVENTMETRIC |
GV$FILE_HISTOGRAM |
V$FILE_HISTOGRAM |
GV$FILEMETRIC |
V$FILEMETRIC |
GV$FILEMETRIC_HISTORY |
V$FILEMETRIC_HISTORY |
GV$FLASHBACK_DATABASE_LOG |
V$FLASHBACK_DATABASE_LOG |
GV$FLASHBACK_DATABASE_STAT |
V$FLASHBACK_DATABASE_STAT |
GV$JAVA_LIBRARY_CACHE_MEMORY |
V$JAVA_LIBRARY_CACHE_MEMORY |
GV$JAVA_POOL_ADVICE |
V$JAVA_POOL_ADVICE |
GV$METRICNAME |
V$METRICNAME |
GV$OSSTAT |
V$OSSTAT |
GV$PROPAGATION_RECEIVER |
V$PROPAGATION_RECEIVER |
GV$PROPAGATION_SENDER |
V$PROPAGATION_SENDER |
V$RECOVERY_FILE_DEST |
|
GV$RMAN_OUTPUT |
V$RMAN_OUTPUT |
V$RMAN_STATUS |
|
GV$RULE |
V$RULE |
GV$RULE_SET |
V$RULE_SET |
GV$RULE_SET_AGGREGATE_STATS |
V$RULE_SET_AGGREGATE_STATS |
GV$SERV_MOD_ACT_STATS |
V$SERV_MOD_ACT_STATS |
GV$SERVICE_EVENT |
V$SERVICE_EVENT |
GV$SERVICE_STATS |
V$SERVICE_STATS |
GV$SERVICE_WAIT_CLASS |
V$SERVICE_WAIT_CLASS |
GV$SERVICEMETRIC |
V$SERVICEMETRIC |
GV$SERVICEMETRIC_HISTORY |
V$SERVICEMETRIC_HISTORY |
GV$SERVICES |
V$SERVICES |
GV$SES_OPTIMIZER_ENV |
V$SES_OPTIMIZER_ENV |
GV$SESS_TIME_MODEL |
V$SESS_TIME_MODEL |
GV$SESSION_WAIT_CLASS |
V$SESSION_WAIT_CLASS |
GV$SESSION_WAIT_HISTORY |
V$SESSION_WAIT_HISTORY |
GV$SESSMETRIC |
V$SESSMETRIC |
GV$SGAINFO |
V$SGAINFO |
GV$SQL_BIND_CAPTURE |
V$SQL_BIND_CAPTURE |
GV$SQL_OPTIMIZER_ENV |
V$SQL_OPTIMIZER_ENV |
GV$SYS_OPTIMIZER_ENV |
V$SYS_OPTIMIZER_ENV |
GV$SYS_TIME_MODEL |
V$SYS_TIME_MODEL |
GV$SYSAUX_OCCUPANTS |
V$SYSAUX_OCCUPANTS |
GV$SYSMETRIC |
V$SYSMETRIC |
GV$SYSMETRIC_HISTORY |
V$SYSMETRIC_HISTORY |
GV$SYSMETRIC_SUMMARY |
V$SYSMETRIC_SUMMARY |
GV$SYSTEM_WAIT_CLASS |
V$SYSTEM_WAIT_CLASS |
GV$TEMP_HISTOGRAM |
V$TEMP_HISTOGRAM |
GV$THRESHOLD_TYPES |
V$THRESHOLD_TYPES |
V$TRANSPORTABLE_PLATFORM |
|
GV$WAITCLASSMETRIC |
V$WAITCLASSMETRIC |
GV$WAITCLASSMETRIC_HISTORY |
V$WAITCLASSMETRIC_HISTORY |
See Also:
Part III, "Dynamic Performance Views" for more information about these dynamic performance viewsThe following static data dictionary views have new columns in release 10.1:
Static Data Dictionary View | New Columns |
---|---|
ALL_ALL_TABLES |
DROPPED |
ALL_APPLY |
PRECOMMIT_HANDLER
|
ALL_APPLY_DML_HANDLERS |
APPLY_NAME |
ALL_APPLY_PROGRESS |
SOURCE_DATABASE |
ALL_AUDIT_POLICIES |
SEL
|
ALL_CAPTURE |
CAPTURE_USER
|
ALL_DEF_AUDIT_OPTS |
FBK |
ALL_DIM_ATTRIBUTES |
ATTRIBUTE_NAME |
ALL_ERRORS |
ATTRIBUTE
|
ALL_EXTERNAL_TABLES |
PROPERTY |
ALL_INDEXES |
IOT_REDUNDANT_PKEY_ELIM
|
ALL_INDEXTYPES |
ARRAY_DML |
ALL_LOBS |
TABLESPACE_NAME
|
ALL_LOG_GROUP_COLUMNS |
LOGGING_PROPERTY |
ALL_LOG_GROUPS |
LOG_GROUP_TYPE
|
ALL_MVIEWS |
UNKNOWN_TRUSTED_FD
|
ALL_OBJECT_TABLES |
DROPPED |
ALL_OUTLINES |
COMPATIBLE
|
ALL_PART_COL_STATISTICS |
HISTOGRAM |
ALL_POLICIES |
IDX
|
ALL_PROPAGATION |
NEGATIVE_RULE_SET_OWNER
|
ALL_SUBPART_COL_STATISTICS |
HISTOGRAM |
ALL_SUBSCRIBED_COLUMNS |
SUBSCRIPTION_NAME |
ALL_SUBSCRIBED_TABLES |
SUBSCRIPTION_NAME |
ALL_SUBSCRIPTIONS |
SUBSCRIPTION_NAME |
ALL_TAB_COL_STATISTICS |
HISTOGRAM |
ALL_TAB_COLS |
HISTOGRAM
|
ALL_TAB_COLUMNS |
HISTOGRAM |
ALL_TAB_MODIFICATIONS |
DROP_SEGMENTS |
ALL_TABLES |
DROPPED |
DBA_ALL_TABLES |
DROPPED |
DBA_APPLY |
PRECOMMIT_HANDLER
|
DBA_APPLY_DML_HANDLERS |
APPLY_NAME |
DBA_APPLY_PROGRESS |
SOURCE_DATABASE |
DBA_AUDIT_EXISTS |
EXTENDED_TIMESTAMP
|
DBA_AUDIT_OBJECT |
EXTENDED_TIMESTAMP
|
DBA_AUDIT_POLICIES |
SEL
|
DBA_AUDIT_SESSION |
EXTENDED_TIMESTAMP
|
DBA_AUDIT_STATEMENT |
EXTENDED_TIMESTAMP
|
DBA_AUDIT_TRAIL |
EXTENDED_TIMESTAMP
|
DBA_AW_PS |
MAXPAGES |
DBA_CAPTURE |
CAPTURE_USER
|
DBA_DIM_ATTRIBUTES |
ATTRIBUTE_NAME |
DBA_ERRORS |
ATTRIBUTE
|
DBA_EXTERNAL_TABLES |
PROPERTY |
DBA_FGA_AUDIT_TRAIL |
STATEMENT_TYPE
|
DBA_INDEXES |
IOT_REDUNDANT_PKEY_ELIM
|
DBA_INDEXTYPES |
ARRAY_DML |
DBA_LOBS |
TABLESPACE_NAME
|
DBA_LOG_GROUP_COLUMNS |
LOGGING_PROPERTY |
DBA_LOG_GROUPS |
LOG_GROUP_TYPE
|
DBA_LOGSTDBY_LOG |
APPLIED |
DBA_LOGSTDBY_PROGRESS |
APPLIED_THREAD#
|
DBA_LOGSTDBY_SKIP |
USE_LIKE
|
DBA_LOGSTDBY_UNSUPPORTED |
ATTRIBUTES |
DBA_MVIEWS |
UNKNOWN_TRUSTED_FD
|
DBA_OBJ_AUDIT_OPTS |
FBK |
DBA_OBJECT_TABLES |
DROPPED |
DBA_OUTLINES |
COMPATIBLE
|
DBA_PART_COL_STATISTICS |
HISTOGRAM |
DBA_POLICIES |
IDX
|
DBA_PROPAGATION |
NEGATIVE_RULE_SET_OWNER
|
DBA_PROXIES |
AUTHENTICATION |
DBA_REGISTRY |
NAMESPACE |
DBA_REGISTRY_HIERARCHY |
NAMESPACE |
DBA_RSRC_PLAN_DIRECTIVES |
MAX_IDLE_TIME
|
DBA_SUBPART_COL_STATISTICS |
HISTOGRAM |
DBA_SUBSCRIBED_COLUMNS |
SUBSCRIPTION_NAME |
DBA_SUBSCRIBED_TABLES |
SUBSCRIPTION_NAME |
DBA_SUBSCRIPTIONS |
SUBSCRIPTION_NAME |
DBA_TAB_COL_STATISTICS |
HISTOGRAM |
DBA_TAB_COLS |
HISTOGRAM
|
DBA_TAB_COLUMNS |
HISTOGRAM |
DBA_TAB_MODIFICATIONS |
DROP_SEGMENTS |
DBA_TABLES |
DROPPED |
DBA_TABLESPACES |
RETENTION
|
USER_ALL_TABLES |
DROPPED |
USER_AUDIT_OBJECT |
EXTENDED_TIMESTAMP
|
USER_AUDIT_POLICIES |
SEL
|
USER_AUDIT_SESSION |
EXTENDED_TIMESTAMP
|
USER_AUDIT_STATEMENT |
EXTENDED_TIMESTAMP
|
USER_AUDIT_TRAIL |
EXTENDED_TIMESTAMP
|
USER_AW_PS |
MAXPAGES |
USER_DIM_ATTRIBUTES |
ATTRIBUTE_NAME |
USER_ERRORS |
ATTRIBUTE
|
USER_EXTERNAL_TABLES |
PROPERTY |
USER_INDEXES |
IOT_REDUNDANT_PKEY_ELIM
|
USER_INDEXTYPES |
ARRAY_DML |
USER_LOBS |
TABLESPACE_NAME
|
USER_LOG_GROUP_COLUMNS |
LOGGING_PROPERTY |
USER_LOG_GROUPS |
LOG_GROUP_TYPE
|
USER_MVIEWS |
UNKNOWN_TRUSTED_FD
|
USER_OBJ_AUDIT_OPTS |
FBK |
USER_OBJECT_TABLES |
DROPPED |
USER_OUTLINES |
COMPATIBLE
|
USER_PART_COL_STATISTICS |
HISTOGRAM |
USER_POLICIES |
IDX
|
USER_PROXIES |
AUTHENTICATION |
USER_PUBLISHED_COLUMNS |
CHANGE_SET_NAME
|
USER_REGISTRY |
NAMESPACE |
USER_SUBPART_COL_STATISTICS |
HISTOGRAM |
USER_SUBSCRIBED_COLUMNS |
SUBSCRIPTION_NAME |
USER_SUBSCRIBED_TABLES |
SUBSCRIPTION_NAME |
USER_SUBSCRIPTIONS |
SUBSCRIPTION_NAME |
USER_TAB_COL_STATISTICS |
HISTOGRAM |
USER_TAB_COLS |
HISTOGRAM
|
USER_TAB_COLUMNS |
HISTOGRAM |
USER_TAB_MODIFICATIONS |
DROP_SEGMENTS |
USER_TABLES |
DROPPED |
USER_TABLESPACES |
RETENTION
|
See Also:
Part II, "Static Data Dictionary Views" for more information about the new columns in these static data dictionary viewsThe following dynamic performance views have new columns in release 10.1:
Dynamic Performance View | New Columns |
---|---|
GV$ARCHIVE_DEST and V$ARCHIVE_DEST |
VALID_NOW
|
GV$ARCHIVE_DEST_STATUS and V$ARCHIVE_DEST_STATUS |
DB_UNIQUE_NAME |
GV$ARCHIVED_LOG and V$ARCHIVED_LOG |
RESETLOGS_ID
|
GV$AW_CALC and V$AW_CALC |
SESSION_ID
|
GV$AW_SESSION_INFO and V$AW_SESSION_INFO |
SESSION_ID |
GV$BACKUP_ASYNC_IO and V$BACKUP_ASYNC_IO |
RMAN_STATUS_RECID
|
GV$BACKUP_DATAFILE and V$BACKUP_DATAFILE |
USED_CHANGE_TRACKING
|
GV$BACKUP_PIECE and V$BACKUP_PIECE |
BYTES
|
GV$BACKUP_SYNC_IO and V$BACKUP_SYNC_IO |
RMAN_STATUS_RECID
|
GV$BGPROCESS and V$BGPROCESS |
PSERIAL# |
GV$CLASS_CACHE_TRANSFER and V$CLASS_CACHE_TRANSFER |
CR_TRANSFER
|
GV$CONTROLFILE and V$CONTROLFILE |
IS_RECOVERY_DEST_FILE |
GV$DATABASE and V$DATABASE |
SWITCHOVER#
|
GV$DATABASE_INCARNATION and V$DATABASE_INCARNATION |
INCARNATION#
|
GV$DATAFILE_COPY and V$DATAFILE_COPY |
IS_RECOVERY_DEST_FILE
|
GV$DB_CACHE_ADVICE and V$DB_CACHE_ADVICE |
ESTD_PHYSICAL_READ_TIME
|
GV$EVENT_NAME and V$EVENT_NAME |
EVENT_ID
|
GV$FAST_START_SERVERS and V$FAST_START_SERVERS |
XID |
GV$FAST_START_TRANSACTIONS and V$FAST_START_TRANSACTIONS |
XID
|
GV$INSTANCE_RECOVERY and V$INSTANCE_RECOVERY |
OPTIMAL_LOGFILE_SIZE
|
GV$LATCH and V$LATCH |
HASH |
GV$LATCH_CHILDREN and V$LATCH_CHILDREN |
HASH |
GV$LATCH_PARENT and V$LATCH_PARENT |
HASH |
GV$LATCHNAME and V$LATCHNAME |
HASH |
GV$LOADISTAT and V$LOADISTAT |
MESSAGE_NUM |
GV$LOG_HISTORY and V$LOG_HISTORY |
RESETLOGS_CHANGE#
|
GV$LOGFILE and V$LOGFILE |
IS_RECOVERY_DEST_FILE |
GV$LOGMNR_CONTENTS and V$LOGMNR_CONTENTS |
TABLE_NAME
|
GV$LOGMNR_DICTIONARY and V$LOGMNR_DICTIONARY |
DB_CREATED
|
GV$LOGMNR_LOGS and V$LOGMNR_LOGS |
TYPE
|
GV$LOGMNR_PARAMETERS and V$LOGMNR_PARAMETERS |
REQUIRED_START_DATE
|
GV$MANAGED_STANDBY and V$MANAGED_STANDBY |
RESETLOG_ID |
GV$OFFLINE_RANGE and V$OFFLINE_RANGE |
RESETLOGS_CHANGE#
|
GV$OPEN_CURSOR and V$OPEN_CURSOR |
SQL_ID |
GV$PARAMETER and V$PARAMETER |
DISPLAY_VALUE
|
GV$PARAMETER2 and V$PARAMETER2 |
DISPLAY_VALUE
|
GV$PROXY_ARCHIVEDLOG and V$PROXY_ARCHIVEDLOG |
TAG
|
GV$PROXY_DATAFILE and V$PROXY_DATAFILE |
RMAN_STATUS_RECID
|
GV$RSRC_PLAN and V$RSRC_PLAN |
IS_TOP_PLAN |
GV$SESSION and V$SESSION |
SQL_ID
|
GV$SESSION_EVENT and V$SESSION_EVENT |
EVENT_ID |
GV$SESSION_LONGOPS and V$SESSION_LONGOPS |
SQL_ID |
GV$SESSION_WAIT and V$SESSION_WAIT |
WAIT_CLASS_ID
|
GV$SGA_DYNAMIC_COMPONENTS and V$SGA_DYNAMIC_COMPONENTS |
USER_SPECIFIED_SIZE |
GV$SHARED_POOL_ADVICE and V$SHARED_POOL_ADVICE |
ESTD_LC_LOAD_TIME
|
GV$SPPARAMETER and V$SPPARAMETER |
DISPLAY_VALUE |
GV$SQL and V$SQL |
SQL_FULLTEXT
|
GV$SQL_PLAN and V$SQL_PLAN |
SQL_ID
|
GV$SQL_PLAN_STATISTICS and V$SQL_PLAN_STATISTICS |
SQL_ID
|
GV$SQL_PLAN_STATISTICS_ALL and V$SQL_PLAN_STATISTICS_ALL |
SQL_ID
|
GV$SQL_REDIRECTION and V$SQL_REDIRECTION |
SQL_ID |
GV$SQL_SHARED_CURSOR and V$SQL_SHARED_CURSOR |
SQL_ID
|
GV$SQL_SHARED_MEMORY and V$SQL_SHARED_MEMORY |
SQL_FULLTEXT
|
GV$SQL_WORKAREA and V$SQL_WORKAREA |
SQL_ID |
GV$SQL_WORKAREA_ACTIVE and V$SQL_WORKAREA_ACTIVE |
SQL_HASH_VALUE
|
GV$SQLAREA and V$SQLAREA |
SQL_ID
|
GV$SQLTEXT and V$SQLTEXT |
SQL_ID |
GV$SQLTEXT_WITH_NEWLINES and V$SQLTEXT_WITH_NEWLINES |
SQL_ID |
GV$STANDBY_LOG and V$STANDBY_LOG |
DBID |
GV$STATNAME and V$STATNAME |
STAT_ID |
GV$STREAMS_APPLY_COORDINATOR and V$STREAMS_APPLY_COORDINATOR |
TOTAL_IGNORED
|
GV$STREAMS_APPLY_READER and V$STREAMS_APPLY_READER |
LAST_BROWSE_NUM
|
GV$STREAMS_APPLY_SERVER and V$STREAMS_APPLY_SERVER |
TOTAL_ROLLBACKS |
GV$STREAMS_CAPTURE and V$STREAMS_CAPTURE |
LOGMINER_ID
|
GV$SYSSTAT and V$SYSSTAT |
STAT_ID |
GV$SYSTEM_EVENT and V$SYSTEM_EVENT |
EVENT_ID |
GV$SYSTEM_PARAMETER and V$SYSTEM_PARAMETER |
DISPLAY_VALUE
|
GV$SYSTEM_PARAMETER2 and V$SYSTEM_PARAMETER2 |
DISPLAY_VALUE
|
GV$TABLESPACE and V$TABLESPACE |
BIGFILE
|
GV$TEMPORARY_LOBS and V$TEMPORARY_LOBS |
ABSTRACT_LOBS |
GV$TEMPSEG_USAGE and V$TEMPSEG_USAGE |
SQL_ID |
GV$TRANSACTION and V$TRANSACTION |
START_DATE
|
GV$UNDOSTAT and V$UNDOSTAT |
MAXQUERYID
|
GV$VPD_POLICY and V$VPD_POLICY |
SQL_ID |
See Also:
Part III, "Dynamic Performance Views" for more information about the new columns in these dynamic performance views