Functions and Views for All Products > apt_v_datacoll_exec_aggr
  
Version 10.0.01
apt_v_datacoll_exec_aggr
The apt_v_datacoll_exec_aggr view contains aggregated logging details for a persistence related database Stored Procedure/Query processing every hour.
 
Table 2 apt_v_datacoll_exec_aggr
Column Name
Data Type
Description
component
STRING
Abbreviation of the subsystem for which logging details are captured. Possible values:
BASE - Base, common to all backup collection
NBU - NetBackup
BUE - Backup Exec
LEG - Legato/NetWorker
TSM - Tivoli Storage Manager
HPD - HP Data Protector
AVM - Avamar
GEN - Generic Backup
CMV - Commvault Simpana
SRM - Base, common to all capacity collection
SRM HDS - Hitachi Data Systems
SRM HDS HNAS - HDS H-NAS
SRM EMC - EMC common
SRM EMC CLA - EMC CLARiiON
SRM EMC SYM - EMC Symmetrix
SRM EMC VNX - EMC Celerra
SRM EMC ISI - EMC Isilon
SRM EMC VPL - EMC Vplex
SRM NAP - NetApp common
SRM NAP NTC - NetApp Cluster-Mode
SRM HP - Hewlett-Packard
SRM HP 3PAR - HP 3PAR
SRM IBM - IBM common
SRM IBM SVC - IBM SVC
SRM IBM XIV - IBM XIV
SRM DLL CPL - Dell Compellent
SRM EVA - HP EVA
SRM OSS - OpenStack Swift
SRM SDK - Generic Storage Array
SRM HOST - Host
SRM BROCADE LT - Brocade Zone Alias
SRM CISCO LT - Cisco Zone Alias
DATA DOMAIN - Data Domain
VMM - Virtualization base
VMM VMW - VMware
VMM VIO - IBM VIO
VMM SOL - Oracle Container/Zone
SNAPMIRROR - NetApp SnapMirror
SNAPVAULT - NetApp SnapVault
SDK - SDK Generic Storage Array
SWI - Switch base
AFA - File Analytics
package_name
STRING
Name of database package for which logging details are captured.
procedure_name
STRING
Name of database procedure for which logging details are captured.
sum_nbr_of_records
NUMBER
Total number of records processed for this database procedure call in this log hour.
sum_db_elapsed_time_sec
NUMBER
Sum of the time spent in this log hour for this database procedure call.
min_db_time_per_rec_sec
NUMBER
Minimum time spent in this log hour for this database procedure call.
max_db_time_per_rec_sec
NUMBER
Maximum time spent in this log hour for this database procedure call.
max_db_time_per_rec_date
DATE
Exact time at which this database call took maximum time to complete in this log hour.
log_hour
NUMBER
The hour of the day for which data is saved in this table.
last_updated
DATE
Date/Time when the data was captured for this procedure.