Diagnostic and Tuning Pack Components

Cyrille Modiano

OCP Oracle DBA in Montreal at Desjardins

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_NAMEOBJECT_TYPEPACKVERSION
DBA_ADVISOR_ACTIONSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_COMMANDSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_DEFINITIONSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_DEF_PARAMETERSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_FINDINGSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_JOURNALVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_LOGVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_OBJECTSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_OBJECT_TYPESVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_PARAMETERSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_PARAMETERS_PROJVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_RATIONALEVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_RECOMMENDATIONSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLA_REC_SUMVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLA_WK_MAPVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLA_WK_STMTSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLW_COLVOLVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLW_JOURNALVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLW_PARAMETERSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLW_STMTSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLW_SUMVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLW_TABLESVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLW_TABVOLVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_SQLW_TEMPLATESVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_TASKSVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_TEMPLATESVIEWDIAGNOSTIC10g,11g,12c
DBA_ADVISOR_USAGEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_ACTIVE_SESS_HISTORYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_BASELINEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_BG_EVENT_SUMMARYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_BUFFERED_QUEUESVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_BUFFERED_SUBSCRIBERSVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_BUFFER_POOL_STATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_COMP_IOSTATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_CR_BLOCK_SERVERVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_CURRENT_BLOCK_SERVERVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_DATAFILEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_DB_CACHE_ADVICEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_DLM_MISCVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_ENQUEUE_STATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_EVENT_NAMEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_FILEMETRIC_HISTORYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_FILESTATXSVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_INSTANCE_RECOVERYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_INST_CACHE_TRANSFERVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_JAVA_POOL_ADVICEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_LATCHVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_LATCH_CHILDRENVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_LATCH_MISSES_SUMMARYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_LATCH_NAMEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_LATCH_PARENTVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_LIBRARYCACHEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_LOGVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_METRIC_NAMEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_MTTR_TARGET_ADVICEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_OPTIMIZER_ENVVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_OSSTATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_OSSTAT_NAMEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_PARAMETERVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_PARAMETER_NAMEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_PGASTATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_PGA_TARGET_ADVICEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_PROCESS_MEM_SUMMARYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_RESOURCE_LIMITVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_ROWCACHE_SUMMARYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_RULE_SETVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SERVICE_NAMEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SERVICE_STATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SERVICE_WAIT_CLASSVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SESSMETRIC_HISTORYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SESS_TIME_STATSVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SGAVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SGASTATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SGA_TARGET_ADVICEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SHARED_POOL_ADVICEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SQLBINDVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SQLSTATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SQLTEXTVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SQL_BIND_METADATAVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SQL_PLANVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SQL_SUMMARYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SQL_WORKAREA_HSTGRMVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_STAT_NAMEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_STREAMS_APPLY_SUMVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_STREAMS_CAPTUREVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_STREAMS_POOL_ADVICEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SYSMETRIC_HISTORYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SYSMETRIC_SUMMARYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SYSSTATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SYSTEM_EVENTVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_SYS_TIME_MODELVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_TABLESPACE_STATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_TBSPC_SPACE_USAGEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_TEMPFILEVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_TEMPSTATXSVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_THREADVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_WAITCLASSMET_HISTORYVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_WAITSTATVIEWDIAGNOSTIC10g,11g,12c
DBA_HIST_WR_CONTROLVIEWDIAGNOSTIC10g,11g,12c
DBA_STREAMS_TP_COMPONENT_STATVIEWDIAGNOSTIC10g,11g,12c
DBA_STREAMS_TP_PATH_BOTTLENECKVIEWDIAGNOSTIC10g,11g,12c
DBMS_ADDMPACKAGEDIAGNOSTIC10g,11g,12c
DBMS_ADVISORPACKAGEBOTH10g,11g,12c
DBMS_SQLTUNEPACKAGETUNING10g,11g,12c
DBMS_WORKLOAD_REPLAYPACKAGEDIAGNOSTIC10g,11g,12c
DBMS_WORKLOAD_REPOSITORYPACKAGEDIAGNOSTIC10g,11g,12c
V$ACTIVE_SESSION_HISTORYSYNONYMDIAGNOSTIC10g,11g,12c
V$SQL_MONITORSYNONYMTUNING10g,11g,12c
V$SQL_PLAN_MONITORSYNONYMTUNING10g,11g,12c
V_$ACTIVE_SESSION_HISTORYVIEWDIAGNOSTIC10g,11g,12c
V_$SQL_MONITORVIEWTUNING10g,11g,12c
V_$SQL_PLAN_MONITORVIEWTUNING10g,11g,12c
DBA_ADVISOR_DIRECTIVESVIEWDIAGNOSTIC10g
DBA_ADDM_FDG_BREAKDOWNVIEWDIAGNOSTIC11g,12c
DBA_ADDM_FINDINGSVIEWDIAGNOSTIC11g,12c
DBA_ADDM_INSTANCESVIEWDIAGNOSTIC11g,12c
DBA_ADDM_SYSTEM_DIRECTIVESVIEWDIAGNOSTIC11g,12c
DBA_ADDM_TASKSVIEWDIAGNOSTIC11g,12c
DBA_ADDM_TASK_DIRECTIVESVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_DIR_DEFINITIONSVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_DIR_INSTANCESVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_DIR_TASK_INSTVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_EXECUTIONSVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_EXECUTION_TYPESVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_EXEC_PARAMETERSVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_FDG_BREAKDOWNVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_FINDING_NAMESVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_SQLA_COLVOLVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_SQLA_TABLESVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_SQLA_TABVOLVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_SQLA_WK_SUMVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_SQLPLANSVIEWDIAGNOSTIC11g,12c
DBA_ADVISOR_SQLSTATSVIEWDIAGNOSTIC11g,12c
DBA_HIST_ASH_SNAPSHOTVIEWDIAGNOSTIC11g,12c
DBA_HIST_BASELINE_DETAILSVIEWDIAGNOSTIC11g,12c
DBA_HIST_BASELINE_METADATAVIEWDIAGNOSTIC11g,12c
DBA_HIST_BASELINE_TEMPLATEVIEWDIAGNOSTIC11g,12c
DBA_HIST_CLUSTER_INTERCONVIEWDIAGNOSTIC11g,12c
DBA_HIST_COLORED_SQLVIEWDIAGNOSTIC11g,12c
DBA_HIST_DISPATCHERVIEWDIAGNOSTIC11g,12c
DBA_HIST_DYN_REMASTER_STATSVIEWDIAGNOSTIC11g,12c
DBA_HIST_EVENT_HISTOGRAMVIEWDIAGNOSTIC11g,12c
DBA_HIST_IC_CLIENT_STATSVIEWDIAGNOSTIC11g,12c
DBA_HIST_IC_DEVICE_STATSVIEWDIAGNOSTIC11g,12c
DBA_HIST_INTERCONNECT_PINGSVIEWDIAGNOSTIC11g,12c
DBA_HIST_IOSTAT_DETAILVIEWDIAGNOSTIC11g,12c
DBA_HIST_IOSTAT_FILETYPEVIEWDIAGNOSTIC11g,12c
DBA_HIST_IOSTAT_FILETYPE_NAMEVIEWDIAGNOSTIC11g,12c
DBA_HIST_IOSTAT_FUNCTIONVIEWDIAGNOSTIC11g,12c
DBA_HIST_IOSTAT_FUNCTION_NAMEVIEWDIAGNOSTIC11g,12c
DBA_HIST_MEMORY_RESIZE_OPSVIEWDIAGNOSTIC11g,12c
DBA_HIST_MEMORY_TARGET_ADVICEVIEWDIAGNOSTIC11g,12c
DBA_HIST_MEM_DYNAMIC_COMPVIEWDIAGNOSTIC11g,12c
DBA_HIST_MUTEX_SLEEPVIEWDIAGNOSTIC11g,12c
DBA_HIST_MVPARAMETERVIEWDIAGNOSTIC11g,12c
DBA_HIST_PERSISTENT_QMN_CACHEVIEWDIAGNOSTIC11g,12c
DBA_HIST_PERSISTENT_QUEUESVIEWDIAGNOSTIC11g,12c
DBA_HIST_PERSISTENT_SUBSVIEWDIAGNOSTIC11g,12c
DBA_HIST_PLAN_OPERATION_NAMEVIEWDIAGNOSTIC11g,12c
DBA_HIST_PLAN_OPTION_NAMEVIEWDIAGNOSTIC11g,12c
DBA_HIST_RSRC_CONSUMER_GROUPVIEWDIAGNOSTIC11g,12c
DBA_HIST_RSRC_PLANVIEWDIAGNOSTIC11g,12c
DBA_HIST_SHARED_SERVER_SUMMARYVIEWDIAGNOSTIC11g,12c
DBA_HIST_SQLCOMMAND_NAMEVIEWDIAGNOSTIC11g,12c
DBA_HIST_TABLESPACEVIEWDIAGNOSTIC11g,12c
DBA_HIST_TOPLEVELCALL_NAMEVIEWDIAGNOSTIC11g,12c
DBA_HIST_APPLY_SUMMARYVIEWDIAGNOSTIC12c
DBA_HIST_CAPTUREVIEWDIAGNOSTIC12c
DBA_HIST_PDB_INSTANCEVIEWDIAGNOSTIC12c
DBA_HIST_REPLICATION_TBL_STATSVIEWDIAGNOSTIC12c
DBA_HIST_REPLICATION_TXN_STATSVIEWDIAGNOSTIC12c
DBA_HIST_REPORTSVIEWDIAGNOSTIC12c
DBA_HIST_REPORTS_CONTROLVIEWDIAGNOSTIC12c
DBA_HIST_REPORTS_DETAILSVIEWDIAGNOSTIC12c
DBA_HIST_REPORTS_TIMEBANDSVIEWDIAGNOSTIC12c
DBA_HIST_SESS_SGA_STATSVIEWDIAGNOSTIC12c

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.