Diagnostic and Tuning Pack Components

Cyrille Modiano

OCP Oracle DBA in Montreal at DBSoft

Latest posts by Cyrille Modiano (see all)

I was looking today, for the list of these Diagnostic and Tuning packs components to be sure to not use licensed views in in databases that don’t have those packs.
It was not an easy search so I decided to share it with you, if you get lucky you’ll find this page and it will save you time.

Objects included in the diagnostic and tuning packs

OBJECT_NAME OBJECT_TYPE PACK VERSION
DBA_ADVISOR_ACTIONS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_COMMANDS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_DEFINITIONS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_DEF_PARAMETERS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_FINDINGS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_JOURNAL VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_LOG VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_OBJECTS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_OBJECT_TYPES VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_PARAMETERS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_PARAMETERS_PROJ VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_RATIONALE VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_RECOMMENDATIONS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLA_REC_SUM VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLA_WK_MAP VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLA_WK_STMTS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLW_COLVOL VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLW_JOURNAL VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLW_PARAMETERS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLW_STMTS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLW_SUM VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLW_TABLES VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLW_TABVOL VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_SQLW_TEMPLATES VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_TASKS VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_TEMPLATES VIEW DIAGNOSTIC 10g,11g,12c
DBA_ADVISOR_USAGE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_ACTIVE_SESS_HISTORY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_BASELINE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_BG_EVENT_SUMMARY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_BUFFERED_QUEUES VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_BUFFERED_SUBSCRIBERS VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_BUFFER_POOL_STAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_COMP_IOSTAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_CR_BLOCK_SERVER VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_CURRENT_BLOCK_SERVER VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_DATAFILE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_DB_CACHE_ADVICE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_DLM_MISC VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_ENQUEUE_STAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_EVENT_NAME VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_FILEMETRIC_HISTORY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_FILESTATXS VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_INSTANCE_RECOVERY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_INST_CACHE_TRANSFER VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_JAVA_POOL_ADVICE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_LATCH VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_LATCH_CHILDREN VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_LATCH_MISSES_SUMMARY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_LATCH_NAME VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_LATCH_PARENT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_LIBRARYCACHE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_LOG VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_METRIC_NAME VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_MTTR_TARGET_ADVICE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_OPTIMIZER_ENV VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_OSSTAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_OSSTAT_NAME VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_PARAMETER VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_PARAMETER_NAME VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_PGASTAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_PGA_TARGET_ADVICE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_PROCESS_MEM_SUMMARY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_RESOURCE_LIMIT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_ROWCACHE_SUMMARY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_RULE_SET VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SERVICE_NAME VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SERVICE_STAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SERVICE_WAIT_CLASS VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SESSMETRIC_HISTORY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SESS_TIME_STATS VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SGA VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SGASTAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SGA_TARGET_ADVICE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SHARED_POOL_ADVICE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SQLBIND VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SQLSTAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SQLTEXT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SQL_BIND_METADATA VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SQL_PLAN VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SQL_SUMMARY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SQL_WORKAREA_HSTGRM VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_STAT_NAME VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_STREAMS_APPLY_SUM VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_STREAMS_CAPTURE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_STREAMS_POOL_ADVICE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SYSMETRIC_HISTORY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SYSMETRIC_SUMMARY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SYSSTAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SYSTEM_EVENT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_SYS_TIME_MODEL VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_TABLESPACE_STAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_TBSPC_SPACE_USAGE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_TEMPFILE VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_TEMPSTATXS VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_THREAD VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_WAITCLASSMET_HISTORY VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_WAITSTAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_HIST_WR_CONTROL VIEW DIAGNOSTIC 10g,11g,12c
DBA_STREAMS_TP_COMPONENT_STAT VIEW DIAGNOSTIC 10g,11g,12c
DBA_STREAMS_TP_PATH_BOTTLENECK VIEW DIAGNOSTIC 10g,11g,12c
DBMS_ADDM PACKAGE DIAGNOSTIC 10g,11g,12c
DBMS_ADVISOR PACKAGE BOTH 10g,11g,12c
DBMS_SQLTUNE PACKAGE TUNING 10g,11g,12c
DBMS_WORKLOAD_REPLAY PACKAGE DIAGNOSTIC 10g,11g,12c
DBMS_WORKLOAD_REPOSITORY PACKAGE DIAGNOSTIC 10g,11g,12c
V$ACTIVE_SESSION_HISTORY SYNONYM DIAGNOSTIC 10g,11g,12c
V$SQL_MONITOR SYNONYM TUNING 10g,11g,12c
V$SQL_PLAN_MONITOR SYNONYM TUNING 10g,11g,12c
V_$ACTIVE_SESSION_HISTORY VIEW DIAGNOSTIC 10g,11g,12c
V_$SQL_MONITOR VIEW TUNING 10g,11g,12c
V_$SQL_PLAN_MONITOR VIEW TUNING 10g,11g,12c
DBA_ADVISOR_DIRECTIVES VIEW DIAGNOSTIC 10g
DBA_ADDM_FDG_BREAKDOWN VIEW DIAGNOSTIC 11g,12c
DBA_ADDM_FINDINGS VIEW DIAGNOSTIC 11g,12c
DBA_ADDM_INSTANCES VIEW DIAGNOSTIC 11g,12c
DBA_ADDM_SYSTEM_DIRECTIVES VIEW DIAGNOSTIC 11g,12c
DBA_ADDM_TASKS VIEW DIAGNOSTIC 11g,12c
DBA_ADDM_TASK_DIRECTIVES VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_DIR_DEFINITIONS VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_DIR_INSTANCES VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_DIR_TASK_INST VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_EXECUTIONS VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_EXECUTION_TYPES VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_EXEC_PARAMETERS VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_FDG_BREAKDOWN VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_FINDING_NAMES VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_SQLA_COLVOL VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_SQLA_TABLES VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_SQLA_TABVOL VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_SQLA_WK_SUM VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_SQLPLANS VIEW DIAGNOSTIC 11g,12c
DBA_ADVISOR_SQLSTATS VIEW DIAGNOSTIC 11g,12c
DBA_HIST_ASH_SNAPSHOT VIEW DIAGNOSTIC 11g,12c
DBA_HIST_BASELINE_DETAILS VIEW DIAGNOSTIC 11g,12c
DBA_HIST_BASELINE_METADATA VIEW DIAGNOSTIC 11g,12c
DBA_HIST_BASELINE_TEMPLATE VIEW DIAGNOSTIC 11g,12c
DBA_HIST_CLUSTER_INTERCON VIEW DIAGNOSTIC 11g,12c
DBA_HIST_COLORED_SQL VIEW DIAGNOSTIC 11g,12c
DBA_HIST_DISPATCHER VIEW DIAGNOSTIC 11g,12c
DBA_HIST_DYN_REMASTER_STATS VIEW DIAGNOSTIC 11g,12c
DBA_HIST_EVENT_HISTOGRAM VIEW DIAGNOSTIC 11g,12c
DBA_HIST_IC_CLIENT_STATS VIEW DIAGNOSTIC 11g,12c
DBA_HIST_IC_DEVICE_STATS VIEW DIAGNOSTIC 11g,12c
DBA_HIST_INTERCONNECT_PINGS VIEW DIAGNOSTIC 11g,12c
DBA_HIST_IOSTAT_DETAIL VIEW DIAGNOSTIC 11g,12c
DBA_HIST_IOSTAT_FILETYPE VIEW DIAGNOSTIC 11g,12c
DBA_HIST_IOSTAT_FILETYPE_NAME VIEW DIAGNOSTIC 11g,12c
DBA_HIST_IOSTAT_FUNCTION VIEW DIAGNOSTIC 11g,12c
DBA_HIST_IOSTAT_FUNCTION_NAME VIEW DIAGNOSTIC 11g,12c
DBA_HIST_MEMORY_RESIZE_OPS VIEW DIAGNOSTIC 11g,12c
DBA_HIST_MEMORY_TARGET_ADVICE VIEW DIAGNOSTIC 11g,12c
DBA_HIST_MEM_DYNAMIC_COMP VIEW DIAGNOSTIC 11g,12c
DBA_HIST_MUTEX_SLEEP VIEW DIAGNOSTIC 11g,12c
DBA_HIST_MVPARAMETER VIEW DIAGNOSTIC 11g,12c
DBA_HIST_PERSISTENT_QMN_CACHE VIEW DIAGNOSTIC 11g,12c
DBA_HIST_PERSISTENT_QUEUES VIEW DIAGNOSTIC 11g,12c
DBA_HIST_PERSISTENT_SUBS VIEW DIAGNOSTIC 11g,12c
DBA_HIST_PLAN_OPERATION_NAME VIEW DIAGNOSTIC 11g,12c
DBA_HIST_PLAN_OPTION_NAME VIEW DIAGNOSTIC 11g,12c
DBA_HIST_RSRC_CONSUMER_GROUP VIEW DIAGNOSTIC 11g,12c
DBA_HIST_RSRC_PLAN VIEW DIAGNOSTIC 11g,12c
DBA_HIST_SHARED_SERVER_SUMMARY VIEW DIAGNOSTIC 11g,12c
DBA_HIST_SQLCOMMAND_NAME VIEW DIAGNOSTIC 11g,12c
DBA_HIST_TABLESPACE VIEW DIAGNOSTIC 11g,12c
DBA_HIST_TOPLEVELCALL_NAME VIEW DIAGNOSTIC 11g,12c
DBA_HIST_APPLY_SUMMARY VIEW DIAGNOSTIC 12c
DBA_HIST_CAPTURE VIEW DIAGNOSTIC 12c
DBA_HIST_PDB_INSTANCE VIEW DIAGNOSTIC 12c
DBA_HIST_REPLICATION_TBL_STATS VIEW DIAGNOSTIC 12c
DBA_HIST_REPLICATION_TXN_STATS VIEW DIAGNOSTIC 12c
DBA_HIST_REPORTS VIEW DIAGNOSTIC 12c
DBA_HIST_REPORTS_CONTROL VIEW DIAGNOSTIC 12c
DBA_HIST_REPORTS_DETAILS VIEW DIAGNOSTIC 12c
DBA_HIST_REPORTS_TIMEBANDS VIEW DIAGNOSTIC 12c
DBA_HIST_SESS_SGA_STATS VIEW DIAGNOSTIC 12c

I found this useful information on the Mike Smithers blog.
His blog post contains all the scripts to build this list.

Leave a Reply