Monthly Archives: February 2012

Oracle 11gR2 new AWR views and columns as compared to 10gR2

New AWR views: VIEW_NAME DBA_HIST_ASH_SNAPSHOT DBA_HIST_BASELINE_DETAILS DBA_HIST_BASELINE_METADATA DBA_HIST_BASELINE_TEMPLATE DBA_HIST_CLUSTER_INTERCON DBA_HIST_COLORED_SQL DBA_HIST_DISPATCHER DBA_HIST_DYN_REMASTER_STATS DBA_HIST_EVENT_HISTOGRAM DBA_HIST_IC_CLIENT_STATS DBA_HIST_IC_DEVICE_STATS DBA_HIST_INTERCONNECT_PINGS DBA_HIST_IOSTAT_DETAIL DBA_HIST_IOSTAT_FILETYPE DBA_HIST_IOSTAT_FILETYPE_NAME DBA_HIST_IOSTAT_FUNCTION DBA_HIST_IOSTAT_FUNCTION_NAME DBA_HIST_MEMORY_RESIZE_OPS DBA_HIST_MEMORY_TARGET_ADVICE DBA_HIST_MEM_DYNAMIC_COMP DBA_HIST_MUTEX_SLEEP DBA_HIST_MVPARAMETER DBA_HIST_PERSISTENT_QMN_CACHE DBA_HIST_PERSISTENT_QUEUES DBA_HIST_PERSISTENT_SUBS DBA_HIST_PLAN_OPERATION_NAME DBA_HIST_PLAN_OPTION_NAME DBA_HIST_RSRC_CONSUMER_GROUP DBA_HIST_RSRC_PLAN DBA_HIST_SHARED_SERVER_SUMMARY DBA_HIST_SQLCOMMAND_NAME DBA_HIST_TABLESPACE DBA_HIST_TOPLEVELCALL_NAME New AWR view … Continue reading

Posted in Uncategorized | 3 Comments

Oracle 11gR2 new v$ views and columns as compared to 10gR2

New V$ views: VIEW_NAME V_$ADVISOR_CURRENT_SQLPLAN V_$ASH_INFO V_$ASM_ACFSSNAPSHOTS V_$ASM_ACFSVOLUMES V_$ASM_ACFS_ENCRYPTION_INFO V_$ASM_ACFS_SECURITY_INFO V_$ASM_ATTRIBUTE V_$ASM_DISK_IOSTAT V_$ASM_FILESYSTEM V_$ASM_USER V_$ASM_USERGROUP V_$ASM_USERGROUP_MEMBER V_$ASM_VOLUME V_$ASM_VOLUME_STAT V_$CALLTAG V_$CELL V_$CELL_CONFIG V_$CELL_REQUEST_TOTALS V_$CELL_STATE V_$CELL_THREAD_HISTORY V_$CORRUPT_XID_LIST V_$CPOOL_CC_INFO V_$CPOOL_CC_STATS V_$CPOOL_CONN_INFO V_$CPOOL_STATS V_$DATABASE_KEY_INFO V_$DETACHED_SESSION V_$DIAG_ADR_CONTROL V_$DIAG_ADR_INVALIDATION V_$DIAG_ALERT_EXT V_$DIAG_AMS_XACTION V_$DIAG_CRITICAL_ERROR V_$DIAG_DDE_USER_ACTION V_$DIAG_DDE_USER_ACTION_DEF V_$DIAG_DDE_USR_ACT_PARAM V_$DIAG_DDE_USR_ACT_PARAM_DEF … Continue reading

Posted in Uncategorized | 1 Comment