Unlike with WFA and OCI, in the install of OCUM 7.2 you
get to pick the MySQL root password. Using the MySQL root password we can
explore the databases and tables that exist with a new install of OCUM 7.2.
cd C:\Program
Files\MySQL\MySQL Server 5.7\bin
mysql -u root -p
Image: OCUM 7.2 Databases
OCUM 7.2 Databases
mysql>
show databases;
+---------------------+
|
Database |
+---------------------+
|
information_schema |
|
acquisition |
|
management |
|
mysql |
|
netapp_model |
|
netapp_model_view |
|
netapp_performance |
|
ocum |
|
ocum_data_collector |
|
ocum_report |
|
ocum_report_birt |
|
ocum_view |
|
opm |
|
performance_schema |
|
sanscreen |
|
scalemonitor |
|
sys |
+---------------------+
Database: information_schema
mysql>
use information_schema;
Database
changed
mysql>
show tables;
+---------------------------------------+
|
Tables_in_information_schema |
+---------------------------------------+
|
CHARACTER_SETS |
|
COLLATIONS |
|
COLLATION_CHARACTER_SET_APPLICABILITY |
|
COLUMNS |
|
COLUMN_PRIVILEGES |
|
ENGINES |
|
EVENTS |
|
FILES |
|
GLOBAL_STATUS |
|
GLOBAL_VARIABLES |
|
KEY_COLUMN_USAGE |
|
OPTIMIZER_TRACE |
|
PARAMETERS |
|
PARTITIONS |
|
PLUGINS |
|
PROCESSLIST |
|
PROFILING |
|
REFERENTIAL_CONSTRAINTS |
|
ROUTINES |
|
SCHEMATA |
|
SCHEMA_PRIVILEGES |
|
SESSION_STATUS |
|
SESSION_VARIABLES |
|
STATISTICS |
|
TABLES |
|
TABLESPACES |
|
TABLE_CONSTRAINTS |
|
TABLE_PRIVILEGES |
|
TRIGGERS |
|
USER_PRIVILEGES |
|
VIEWS |
|
INNODB_LOCKS |
|
INNODB_TRX |
|
INNODB_SYS_DATAFILES |
|
INNODB_FT_CONFIG |
|
INNODB_SYS_VIRTUAL |
|
INNODB_CMP |
|
INNODB_FT_BEING_DELETED |
|
INNODB_CMP_RESET |
|
INNODB_CMP_PER_INDEX |
|
INNODB_CMPMEM_RESET |
|
INNODB_FT_DELETED |
|
INNODB_BUFFER_PAGE_LRU |
|
INNODB_LOCK_WAITS |
|
INNODB_TEMP_TABLE_INFO |
|
INNODB_SYS_INDEXES |
|
INNODB_SYS_TABLES |
|
INNODB_SYS_FIELDS |
|
INNODB_CMP_PER_INDEX_RESET |
|
INNODB_BUFFER_PAGE |
|
INNODB_FT_DEFAULT_STOPWORD |
|
INNODB_FT_INDEX_TABLE |
|
INNODB_FT_INDEX_CACHE |
|
INNODB_SYS_TABLESPACES |
|
INNODB_METRICS |
|
INNODB_SYS_FOREIGN_COLS |
|
INNODB_CMPMEM |
|
INNODB_BUFFER_POOL_STATS |
|
INNODB_SYS_COLUMNS |
|
INNODB_SYS_FOREIGN |
|
INNODB_SYS_TABLESTATS |
+---------------------------------------+
Database: acquisition
mysql>
use acquisition;
Database
changed
mysql>
show tables;
+------------------------------+
|
Tables_in_acquisition |
+------------------------------+
|
acquisition_storage_identify |
|
acquisition_volume_identify |
|
au |
|
au_attrs |
|
au_audit |
|
ds |
|
ds_attrs |
|
ds_audit |
|
ds_audit_details |
|
ds_type |
|
ds_type_attrs |
|
ds_type_vendormodel |
|
originator |
+------------------------------+
Database: management
mysql>
use management;
Database
changed
mysql>
show tables;
+----------------------+
|
Tables_in_management |
+----------------------+
|
id |
|
info |
|
scale |
|
version |
+----------------------+
Database: mysql
mysql>
use mysql;
Database
changed
mysql>
show tables;
+---------------------------+
|
Tables_in_mysql |
+---------------------------+
|
columns_priv |
|
db |
|
engine_cost |
|
event |
|
func |
|
general_log |
|
gtid_executed |
|
help_category |
|
help_keyword |
|
help_relation |
|
help_topic |
|
innodb_index_stats |
|
innodb_table_stats |
|
ndb_binlog_index |
|
plugin |
|
proc |
|
procs_priv |
|
proxies_priv |
|
server_cost |
|
servers |
|
slave_master_info |
|
slave_relay_log_info |
|
slave_worker_info |
|
slow_log |
|
tables_priv |
|
time_zone |
|
time_zone_leap_second |
|
time_zone_name |
|
time_zone_transition |
|
time_zone_transition_type |
|
user |
+---------------------------+
Database: netapp_model
mysql>
use netapp_model;
Database
changed
mysql>
show tables;
+--------------------------------------------------+
|
Tables_in_netapp_model
|
+--------------------------------------------------+
|
aggregate
|
|
aggregate_objectstore_config_mapping
|
|
application_record
|
|
change_delete_detail
|
|
change_record
|
|
changed_attribute |
|
cifs_share
|
|
cifs_share_acl
|
|
cluster
|
|
cluster_peer
|
|
disk |
|
disk_aggregate_relationship
|
|
disk_path
|
|
export_policy
|
|
export_rule
|
|
fcp_lif
|
|
fcp_port
|
|
flash_device
|
|
ha_pair
|
|
igroup
|
|
igroup_initiator
|
|
iscsi_portal_group
|
|
iscsi_portal_group_lif
|
|
iscsi_security_entry
|
|
iscsi_session |
|
iscsi_session_connection
|
|
job_schedule
|
|
license
|
|
license_v2_entitlement_risk
|
|
lif |
|
lun
|
|
lun_import
|
|
lun_map
|
|
lun_map_reporting_node
|
|
metrocluster_operation
|
|
network_failover_group
|
|
network_failover_group_network_port_relationship |
|
network_ip_space
|
|
network_lif
|
|
network_port
|
|
network_port_broadcast_domain
|
|
network_port_relationship
|
|
network_route
|
|
network_route_lif
|
|
network_subnet
|
|
nis_domain
|
|
node
|
|
node_license_usage
|
|
objectstore_config
|
|
objectstore_space_detail
|
|
param
|
|
plex
|
|
portset |
|
portset_port
|
|
portset_to_igroup
|
|
processor
|
|
qos_policy_group
|
|
qos_policy_group_vserver_relationship
|
|
qos_service_center
|
|
qos_service_center_relationship
|
|
qos_volume_workload
|
|
qos_workload_detail
|
|
qos_workload_node_relationship
|
|
qtree
|
|
qtree_quota
|
|
quota_user
|
|
raid_group
|
|
resource_aggregate
|
|
routing_group
|
|
routing_group_destination
|
|
service_processor
|
|
sis_policy
|
|
snap_mirror
|
|
snap_mirror_history
|
|
snap_mirror_policy
|
|
snap_mirror_policy_rule
|
|
snap_mirror_self_relationship
|
|
snaplock
|
|
snapshot
|
|
snapshot_policy
|
|
snapshot_policy_schedule |
|
snapshot_policy_vserver_relationship
|
|
storage_adapter
|
|
storage_pool
|
|
storage_pool_aggregate_relationship
|
|
storage_pool_available |
|
storage_service
|
|
storage_service_volume_relationship
|
|
storage_shelf
|
|
storage_shelf_cable
|
|
storage_switch |
|
system_health_alert
|
|
update_history
|
|
upgrade_history
|
|
user_quota
|
|
version
|
|
volume
|
|
volume_flexcache
|
|
volume_flexgroup_constituent_relationship
|
|
volume_move_job
|
|
volume_self_relationship
|
|
vserver
|
|
vserver_name_mapping
|
|
vserver_peer
|
|
vserver_to_aggregate
|
+--------------------------------------------------+
Database: netapp_model_view
mysql>
use netapp_model_view;
Database
changed
mysql>
show tables;
+-------------------------------------------------------+
|
Tables_in_netapp_model_view |
+-------------------------------------------------------+
|
aggregate |
|
aggregate_full |
|
aggregate_objectstore_config_mapping |
|
aggregate_objectstore_config_mapping_full |
|
application_record |
|
application_record_full |
|
change_delete_detail |
|
change_record |
|
changed_attribute |
|
cifs_share |
|
cifs_share_acl |
|
cifs_share_acl_full |
|
cifs_share_full |
|
cluster
|
|
cluster_full |
|
cluster_peer |
|
cluster_peer_full |
|
disk
|
|
disk_aggregate_relationship |
|
disk_aggregate_relationship_full |
|
disk_full |
|
disk_path |
|
disk_path_full |
|
export_policy |
|
export_policy_full |
|
export_rule |
|
export_rule_full |
|
fcp_lif
|
|
fcp_lif_derived
|
|
fcp_lif_derived_full |
|
fcp_lif_full |
|
fcp_port |
|
fcp_port_full |
|
flash_device |
|
flash_device_full |
|
ha_pair
|
|
ha_pair_full |
|
igroup |
|
igroup_full |
|
igroup_initiator |
|
igroup_initiator_full |
|
iscsi_portal_group |
|
iscsi_portal_group_full |
|
iscsi_portal_group_lif |
|
iscsi_portal_group_lif_full |
|
iscsi_security_entry |
|
iscsi_security_entry_full |
|
iscsi_session |
|
iscsi_session_connection |
|
iscsi_session_connection_full |
|
iscsi_session_full |
|
job_schedule |
|
job_schedule_full |
|
license
|
|
license_full
|
|
license_v2_entitlement_risk |
|
license_v2_entitlement_risk_full |
|
lif
|
|
lif_full |
|
lun |
|
lun_full |
|
lun_import |
|
lun_import_full |
|
lun_map |
|
lun_map_full |
|
lun_map_reporting_node |
|
lun_map_reporting_node_full |
|
metrocluster_operation |
|
metrocluster_operation_full |
|
network_failover_group |
|
network_failover_group_full |
|
network_failover_group_network_port_relationship |
|
network_failover_group_network_port_relationship_full |
|
network_ip_space |
|
network_ip_space_full |
|
network_lif |
|
network_lif_derived |
|
network_lif_derived_full |
|
network_lif_full |
|
network_port |
|
network_port_broadcast_domain |
|
network_port_broadcast_domain_full |
|
network_port_full |
|
network_route |
|
network_route_full
|
|
network_route_lif |
|
network_route_lif_full |
|
network_subnet |
|
network_subnet_full |
|
nis_domain |
|
nis_domain_full |
|
node
|
|
node_full |
|
node_license_usage |
|
node_license_usage_full |
|
objectstore_config |
|
objectstore_config_full |
|
objectstore_space_detail |
|
objectstore_space_detail_full |
|
plex
|
|
plex_full |
|
portset
|
|
portset_full |
|
portset_to_igroup |
|
portset_to_igroup_full |
|
portset_to_port |
|
portset_to_port_full |
|
processor |
|
processor_full |
|
qos_policy_group |
|
qos_policy_group_full |
|
qos_service_center |
|
qos_service_center_full |
|
qos_volume_workload |
|
qos_volume_workload_full
|
|
qos_workload_detail |
|
qos_workload_detail_full |
|
qos_workload_node_relationship |
|
qos_workload_node_relationship_full |
|
qtree |
|
qtree_full |
|
qtree_quota |
|
qtree_quota_full |
|
quota_user |
|
quota_user_full |
|
raid_group |
|
raid_group_full |
|
resource_aggregate |
|
resource_aggregate_full |
|
routing_group |
|
routing_group_destination |
|
routing_group_destination_full |
|
routing_group_full |
|
service_processor |
|
service_processor_full |
|
sis_policy |
|
sis_policy_full |
|
snap_mirror |
|
snap_mirror_full |
|
snap_mirror_history |
|
snap_mirror_history_full |
|
snap_mirror_policy |
|
snap_mirror_policy_full |
|
snap_mirror_policy_rule |
|
snap_mirror_policy_rule_full
|
|
snaplock |
|
snaplock_full |
|
snapshot |
|
snapshot_full |
|
snapshot_policy |
|
snapshot_policy_full |
|
snapshot_policy_schedule |
|
snapshot_policy_schedule_full |
|
storage_adapter |
|
storage_adapter_full |
|
storage_pool |
|
storage_pool_aggregate_relationship |
|
storage_pool_aggregate_relationship_full |
|
storage_pool_available |
|
storage_pool_available_full |
|
storage_pool_full |
|
storage_service |
|
storage_service_full |
|
storage_shelf |
|
storage_shelf_cable |
|
storage_shelf_cable_full |
|
storage_shelf_full |
|
storage_switch |
|
storage_switch_full |
|
system_health_alert |
|
system_health_alert_full
|
|
user_quota |
|
user_quota_full |
|
volume
|
|
volume_full |
|
volume_move_job |
|
volume_move_job_full |
|
vserver
|
|
vserver_full |
|
vserver_name_mapping |
|
vserver_name_mapping_full |
|
vserver_peer |
|
vserver_peer_full |
|
vserver_to_aggregate |
|
vserver_to_aggregate_full |
+-------------------------------------------------------+
Database: netapp_performance
mysql>
use netapp_performance;
Database
changed
mysql>
show tables;
+------------------------------+
|
Tables_in_netapp_performance |
+------------------------------+
|
update_history |
+------------------------------+
Database: ocum
mysql>
use ocum;
Database
changed
mysql>
show tables;
+--------------------------------------------+
|
Tables_in_ocum
|
+--------------------------------------------+
|
aggregate
|
|
aggregatecalculationsview
|
|
aggregategrowthrateinfo
|
|
aggregatehistorymonth
|
|
aggregatehistoryweek
|
|
aggregatehistoryyear
|
|
aggregatelivelistdtoview
|
|
aggregateregressioninfo
|
|
aggregatestoragepoollivelistdtoview
|
|
alert |
|
alert_emailaddressrecipients
|
|
alert_emailadminrecipients
|
|
alert_eventseverities
|
|
alerteventtypevalues
|
|
alertresourceobjects
|
|
annotation |
|
annotationmanualresourcemapping
|
|
annotationofcluster
|
|
annotationofvolume
|
|
annotationofvserver
|
|
annotationresourceobject |
|
annotationresourceobjectlivelistdtoview
|
|
annotationrule
|
|
annotationrulelivelistdtoview
|
|
annotationtype
|
|
annotationtypevalueview
|
|
annotationvaluebreakdownlivelistdtoview
|
|
authorizationunit
|
|
backupfileinfo
|
|
bridge
|
|
bridgestackconnection
|
|
bridgestacklink |
|
cifsshare
|
|
cifssharelivelistdtoview
|
|
clienteventdetails
|
|
cluster
|
|
clusterhistorymonth |
|
clusterhistoryweek
|
|
clusterhistoryyear
|
|
clusterlivelistdtoview
|
|
clusternode
|
|
clusternodededicatesparecapacityview
|
|
clusternodedowneventsview
|
|
clusternodehighavailabilitystateview
|
|
clusternodehistorymonth
|
|
clusternodehistoryweek
|
|
clusternodehistoryyear
|
|
clusternoderawsparecapacityview |
|
clusternoderawsparesharedcachecapacityview |
|
clusternoderawspareshareddatacapacityview
|
|
conditiongroup
|
|
conditiontable
|
|
customeventtype
|
|
customeventtypevalue
|
|
databaseproperty
|
|
datapolicy
|
|
datasource
|
|
datasourcelivelistdtoview
|
|
deferredmccresource
|
|
deferredontapalert
|
|
deletedvolume
|
|
diskaggregaterelationship
|
|
diskaggregaterelationshipaggrcountview
|
|
disklivelistdtoview |
|
efficiencypolicy
|
|
event
|
|
eventnote
|
|
eventontapsystemhealthalertmapping
|
|
eventtype
|
|
eventtypecategoryclosureassociation
|
|
eventtypecategorycontainer
|
|
eventtypesourcetypes
|
|
eventtypevalue
|
|
exportpolicy
|
|
exportrule |
|
exportrulelivelistdtoview
|
|
externalcache
|
|
externalcachehistorymonth
|
|
externalcachehistoryweek
|
|
externalcachehistoryyear
|
|
favorite
|
|
fcptarget
|
|
flashcard
|
|
flexvolcalculationsview
|
|
groupaction
|
|
groupactionargument
|
|
groupactionlivelistdtoview
|
|
grouplivelistdtoview
|
|
groupmembership
|
|
groupmembershiprule
|
|
groupmembershiprulelivelistdtoview |
|
groups
|
|
hibernate_sequences
|
|
igrouplivelistdtoview
|
|
infinitevolhistorymonth
|
|
infinitevolhistoryweek
|
|
infinitevolhistoryyear
|
|
initiator
|
|
initiatorcountperigroupdtoview
|
|
initiatordtoviewlist
|
|
initiatorgroup
|
|
internodeconnection |
|
internodelink
|
|
interswitchconnection
|
|
interswitchlink
|
|
job
|
|
jobreportview
|
|
ldapserver
|
|
lifcountperigrouplistdtoview
|
|
logicalinterface
|
|
logicalinterfacelivelistdtoview
|
|
lun
|
|
luncountperigrouplistdtoview
|
|
lunlivelistdtoview
|
|
lunmapidperigroupdtoview
|
|
managedvolumecalculationsview
|
|
managementstation
|
|
manualannotationbreakdownlivelistdto
|
|
metroclusterrelationship
|
|
networkport
|
|
nfsexportlivelistdtoview
|
|
nodebridgeconnection
|
|
nodebridgelink |
|
nodestackconnection
|
|
nodestacklink
|
|
nodeswitchconnection
|
|
nodeswitchlink
|
|
objectstore_config
|
|
ocummonitoringstatus
|
|
ontapalert
|
|
ontapems
|
|
ontapemsparameter
|
|
ontapfaultinfo
|
|
optionchainvalue |
|
persistentproperty
|
|
plex
|
|
portlivelistdtoview
|
|
portset
|
|
portsetnamesperlogicalinterfacedtoview
|
|
qrtz_blob_triggers
|
|
qrtz_calendars
|
|
qrtz_cron_triggers
|
|
qrtz_fired_triggers
|
|
qrtz_job_details
|
|
qrtz_locks |
|
qrtz_paused_trigger_grps
|
|
qrtz_scheduler_state
|
|
qrtz_simple_triggers
|
|
qrtz_simprop_triggers
|
|
qrtz_triggers |
|
qtree
|
|
qtreelivelistdtoview
|
|
readytaskworkitemqueueentry
|
|
report
|
|
reportschedule
|
|
reportschedulerelationship
|
|
resourcepool
|
|
resourcepoolaggregates
|
|
resourcepoollivelistdtoview
|
|
role
|
|
routinggrouproutesview |
|
ruletemplate
|
|
script
|
|
scriptlivelistdtoview
|
|
selectioncriterion
|
|
serviceworkflow
|
|
snapmirrorrelationship
|
|
snapmirrortransfer
|
|
snapshotexpirerecord
|
|
snapshotmetadata
|
|
snapshotpolicy
|
|
storagearray
|
|
storagearrayclusterassociation
|
|
storagearraylunpath
|
|
storagearrayport
|
|
storagearrayportclusterassociation
|
|
storageclass |
|
storageservice
|
|
storageservice_contacts
|
|
storageserviceconnection
|
|
storageserviceconnectionmember
|
|
storageservicenode |
|
storageservicenodemember
|
|
storageservicenoderesourcepool
|
|
storageservicerootmemberinfo
|
|
storageservicesubscription
|
|
storageservicesubscription_metadatafields
|
|
storageservicesubscriptionrootmember
|
|
storageservicevserverdestination
|
|
storageshelf
|
|
subscribedems
|
|
svmrelationshiplivelistdtoview
|
|
switch |
|
switchbridgeconnection
|
|
switchbridgelink
|
|
switchinterswitchrelationship
|
|
targetportalgroup
|
|
task
|
|
taskmessage
|
|
taskobjectinteraction
|
|
taskpredecessor
|
|
taskreportview
|
|
taskretry
|
|
taskstatuschange |
|
taskstatuschangeview
|
|
thresholdobjectstocheck
|
|
trap
|
|
trapvarbinding
|
|
userquota |
|
userquotalivelistdtoview
|
|
volume
|
|
volumeaggregatemappingview
|
|
volumecalculationsview
|
|
volumeflexgroupaggregaterelationshipview
|
|
volumegrowthrateinfo
|
|
volumehistorymonth
|
|
volumehistoryweek
|
|
volumehistoryyear
|
|
volumejunctionpathhistory
|
|
volumelivelistdtoview |
|
volumelivelistmaxvolumemovejobview
|
|
volumemovehistory
|
|
volumeoutgoingrelationshipview
|
|
volumeregressioninfo
|
|
volumerelationshiplivelistdtoview
|
|
volumesnapshot_metadatafields
|
|
vserver
|
|
vserverassociationlivelistdtoview
|
|
vserverhistorymonth
|
|
vserverhistoryweek
|
|
vserverhistoryyear |
|
vserverlivelistdtoview
|
|
wafldisk
|
+--------------------------------------------+
Database: ocum_data_collector
mysql>
use ocum_data_collector;
Database
changed
mysql>
show tables;
Empty
set (0.00 sec)
Database: ocum_report
mysql>
use ocum_report;
Database
changed
mysql>
show tables;
+------------------------------------------+
|
Tables_in_ocum_report
|
+------------------------------------------+
|
aggregate
|
|
aggregatecapacityhistorymonthview
|
|
aggregatecapacityhistoryweekview
|
|
aggregatecapacityhistoryyearview
|
|
aggregateobjectstoremapping
|
|
annotation
|
|
annotationofclusterview
|
|
annotationofvolumeview
|
|
annotationofvserverview
|
|
cifsshare
|
|
cifsshareacl
|
|
cluster
|
|
clusterlicensedetailview
|
|
clusterlicenseview
|
|
clusternode
|
|
disk
|
|
diskaggregatemapping
|
|
exportpolicy |
|
exportrule
|
|
fcpport
|
|
lif
|
|
lun
|
|
networkport
|
|
objectstore |
|
objectstorespacedetails
|
|
protectunprotectvolumeview
|
|
qtree
|
|
qtreequota
|
|
storagepool
|
|
storagepoolaggregatemapping
|
|
svm
|
|
svmaggregatemapping
|
|
unprotectvolumeview
|
|
userquota
|
|
volume |
|
volumecapacityhistorymonthview
|
|
volumecapacityhistoryweekview
|
|
volumecapacityhistoryyearview
|
|
volumeoutgoingrelationshipview
|
|
volumeprotectionview
|
|
volumerelationshiphistoryaggweekhourview |
|
volumerelationshiphistorychartcountview
|
|
volumerelationshiphistorychartview
|
|
volumerelationshiphistorydayview
|
|
volumerelationshiphistorymonthview
|
|
volumerelationshiphistoryview
|
|
volumerelationshiphistoryweekview
|
|
volumerelationshiphistoryyearview
|
|
volumerelationshipinventoryview
|
|
volumerelationships
|
+------------------------------------------+
Database: ocum_report_birt
mysql>
use ocum_report_birt;
Database
changed
mysql>
show tables;
+------------------------------------------+
|
Tables_in_ocum_report_birt
|
+------------------------------------------+
|
ackevents
|
|
acktoresolvedandobsoleteevents |
|
aggregatecapacityutilization
|
|
aggregatecapacityutilizationhistory
|
|
basicevents
|
|
clusterinventoryreport
|
|
clusterlicenseview
|
|
clusterunconfiguredcapacitymapping
|
|
daywiseeventstatustrendchart
|
|
diskcapacitymapping
|
|
eventseveritytrendchart
|
|
eventseveritytrendhelper
|
|
eventstatecharthelper
|
|
eventupdatedates
|
|
halevelmapping
|
|
hapairview
|
|
lunnodecapacitymapping
|
|
newevents
|
|
newtoresolvedandobsoleteevents
|
|
nfsexport
|
|
nodelevelcapacitymapping
|
|
protectunprotectvolumeview
|
|
qtreecapacityutilization
|
|
storagesummary
|
|
storagesystemhealthtable |
|
svminventoryreport
|
|
unprotectvolumeview
|
|
volumecapacityutilization
|
|
volumecapacityutilizationhistory
|
|
volumenodecapacitymapping
|
|
volumerelationshiphistoryaggweekhourview |
|
volumerelationshiphistorychartcountview
|
|
volumerelationshiphistorychartview
|
|
volumerelationshiphistorydayview
|
|
volumerelationshiphistorymonthview
|
|
volumerelationshiphistoryview
|
|
volumerelationshiphistoryweekview
|
|
volumerelationshiphistoryyearview
|
|
volumerelationshipinventoryview
|
+------------------------------------------+
Database: ocum_view
mysql>
use ocum_view;
Database
changed
mysql>
show tables;
+------------------------------------+
|
Tables_in_ocum_view |
+------------------------------------+
|
aggregate |
|
annotation |
|
annotationresourceobjectview |
|
annotationtype |
|
event |
|
eventnote |
|
metadatavolume |
|
resource_pool |
|
resource_pool_aggregates |
|
volume |
|
volumelivelistdtoview |
|
volumelivelistmaxvolumemovejobview |
|
vserver_destination |
+------------------------------------+
Database: opm
mysql>
use opm;
Database
changed
mysql>
show tables;
+----------------------------------------------+
|
Tables_in_opm |
+----------------------------------------------+
|
acquisition_info
|
|
bp_event
|
|
change_event
|
|
change_event_attribute |
|
change_event_workload
|
|
change_type_definition
|
|
config
|
|
contention_analysis_role_definition
|
|
continuous_event_occurrence
|
|
continuous_event_participant
|
|
continuous_event_participant_stats
|
|
dyn_state_definition
|
|
element_type_definition
|
|
event_to_declare_bp
|
|
ext_data_config
|
|
ext_server_config
|
|
forecast
|
|
notification_dynamic_event_option_definition |
|
notification_level_definition
|
|
notification_scope_definition
|
|
notification_type_definition
|
|
notification_umevent_definition
|
|
polling_interval_history
|
|
s_all_aggregates_periodic |
|
s_all_clusters_periodic
|
|
s_all_lifs_periodic
|
|
s_all_luns_periodic
|
|
s_all_nodes_periodic
|
|
s_all_ports_periodic
|
|
s_all_svms_periodic
|
|
s_all_volumes_periodic
|
|
shadow_table_trail
|
|
stat_type_definition
|
|
target_type_definition
|
|
threshold
|
|
threshold_notification
|
|
threshold_policy
|
|
threshold_policy_mapping
|
|
upgrade_history
|
|
version
|
+----------------------------------------------+
Database: performance_schema
mysql>
use performance_schema;
Database
changed
mysql>
show tables;
+------------------------------------------------------+
|
Tables_in_performance_schema |
+------------------------------------------------------+
|
accounts |
|
cond_instances |
|
events_stages_current |
|
events_stages_history |
|
events_stages_history_long |
|
events_stages_summary_by_account_by_event_name |
|
events_stages_summary_by_host_by_event_name |
|
events_stages_summary_by_thread_by_event_name |
|
events_stages_summary_by_user_by_event_name |
|
events_stages_summary_global_by_event_name |
|
events_statements_current |
|
events_statements_history |
|
events_statements_history_long |
|
events_statements_summary_by_account_by_event_name |
|
events_statements_summary_by_digest |
|
events_statements_summary_by_host_by_event_name |
|
events_statements_summary_by_program |
|
events_statements_summary_by_thread_by_event_name |
|
events_statements_summary_by_user_by_event_name |
|
events_statements_summary_global_by_event_name |
|
events_transactions_current |
|
events_transactions_history |
|
events_transactions_history_long |
|
events_transactions_summary_by_account_by_event_name |
|
events_transactions_summary_by_host_by_event_name |
|
events_transactions_summary_by_thread_by_event_name |
|
events_transactions_summary_by_user_by_event_name |
|
events_transactions_summary_global_by_event_name |
|
events_waits_current |
|
events_waits_history |
|
events_waits_history_long |
|
events_waits_summary_by_account_by_event_name |
|
events_waits_summary_by_host_by_event_name |
|
events_waits_summary_by_instance |
|
events_waits_summary_by_thread_by_event_name |
|
events_waits_summary_by_user_by_event_name |
|
events_waits_summary_global_by_event_name |
|
file_instances |
|
file_summary_by_event_name |
|
file_summary_by_instance |
|
global_status |
|
global_variables |
|
host_cache |
|
hosts |
|
memory_summary_by_account_by_event_name |
|
memory_summary_by_host_by_event_name |
|
memory_summary_by_thread_by_event_name |
|
memory_summary_by_user_by_event_name |
|
memory_summary_global_by_event_name |
|
metadata_locks |
|
mutex_instances |
|
objects_summary_global_by_type |
|
performance_timers |
|
prepared_statements_instances |
|
replication_applier_configuration |
|
replication_applier_status |
|
replication_applier_status_by_coordinator |
|
replication_applier_status_by_worker |
|
replication_connection_configuration |
|
replication_connection_status |
|
replication_group_member_stats |
|
replication_group_members |
|
rwlock_instances |
|
session_account_connect_attrs |
|
session_connect_attrs |
|
session_status |
|
session_variables |
|
setup_actors |
|
setup_consumers |
|
setup_instruments |
|
setup_objects |
|
setup_timers |
|
socket_instances |
|
socket_summary_by_event_name |
|
socket_summary_by_instance |
|
status_by_account |
|
status_by_host |
|
status_by_thread |
|
status_by_user |
|
table_handles |
|
table_io_waits_summary_by_index_usage |
|
table_io_waits_summary_by_table |
|
table_lock_waits_summary_by_table |
|
threads |
|
user_variables_by_thread |
|
users
|
|
variables_by_thread |
+------------------------------------------------------+
Database: sanscreen
mysql>
use sanscreen;
Database
changed
mysql>
show tables;
+---------------------+
|
Tables_in_sanscreen |
+---------------------+
|
implicit_commit |
|
user |
|
user_role |
+---------------------+
Database: scalemonitor
mysql>
use scalemonitor;
Database
changed
mysql>
show tables;
+------------------------+
|
Tables_in_scalemonitor |
+------------------------+
|
attribute |
|
config |
|
sample |
|
upgrade_history |
|
value |
|
version |
+------------------------+
Database: sys
mysql>
use sys;
Database
changed
mysql>
show tables;
+-----------------------------------------------+
|
Tables_in_sys
|
+-----------------------------------------------+
|
host_summary
|
|
host_summary_by_file_io
|
|
host_summary_by_file_io_type
|
|
host_summary_by_stages
|
|
host_summary_by_statement_latency
|
|
host_summary_by_statement_type
|
|
innodb_buffer_stats_by_schema
|
|
innodb_buffer_stats_by_table
|
|
innodb_lock_waits
|
|
io_by_thread_by_latency
|
|
io_global_by_file_by_bytes
|
|
io_global_by_file_by_latency
|
|
io_global_by_wait_by_bytes
|
|
io_global_by_wait_by_latency
|
|
latest_file_io |
|
memory_by_host_by_current_bytes
|
|
memory_by_thread_by_current_bytes
|
|
memory_by_user_by_current_bytes
|
|
memory_global_by_current_bytes
|
|
memory_global_total |
|
metrics
|
|
processlist
|
|
ps_check_lost_instrumentation
|
|
schema_auto_increment_columns
|
|
schema_index_statistics
|
|
schema_object_overview
|
|
schema_redundant_indexes
|
|
schema_table_lock_waits
|
|
schema_table_statistics
|
|
schema_table_statistics_with_buffer
|
|
schema_tables_with_full_table_scans
|
|
schema_unused_indexes
|
|
session
|
|
session_ssl_status
|
|
statement_analysis
|
|
statements_with_errors_or_warnings
|
|
statements_with_full_table_scans
|
|
statements_with_runtimes_in_95th_percentile
|
|
statements_with_sorting
|
|
statements_with_temp_tables
|
|
sys_config
|
|
user_summary
|
|
user_summary_by_file_io
|
|
user_summary_by_file_io_type
|
|
user_summary_by_stages
|
|
user_summary_by_statement_latency
|
|
user_summary_by_statement_type
|
|
version
|
|
wait_classes_global_by_avg_latency
|
|
wait_classes_global_by_latency
|
|
waits_by_host_by_latency
|
|
waits_by_user_by_latency
|
|
waits_global_by_latency
|
|
x$host_summary
|
|
x$host_summary_by_file_io
|
|
x$host_summary_by_file_io_type
|
|
x$host_summary_by_stages
|
|
x$host_summary_by_statement_latency
|
|
x$host_summary_by_statement_type
|
|
x$innodb_buffer_stats_by_schema
|
|
x$innodb_buffer_stats_by_table
|
|
x$innodb_lock_waits
|
|
x$io_by_thread_by_latency
|
|
x$io_global_by_file_by_bytes
|
|
x$io_global_by_file_by_latency
|
|
x$io_global_by_wait_by_bytes
|
|
x$io_global_by_wait_by_latency
|
|
x$latest_file_io
|
|
x$memory_by_host_by_current_bytes
|
|
x$memory_by_thread_by_current_bytes
|
|
x$memory_by_user_by_current_bytes
|
|
x$memory_global_by_current_bytes
|
|
x$memory_global_total
|
|
x$processlist
|
|
x$ps_digest_95th_percentile_by_avg_us
|
|
x$ps_digest_avg_latency_distribution
|
|
x$ps_schema_table_statistics_io
|
|
x$schema_flattened_keys
|
|
x$schema_index_statistics
|
|
x$schema_table_lock_waits |
|
x$schema_table_statistics
|
|
x$schema_table_statistics_with_buffer
|
|
x$schema_tables_with_full_table_scans
|
|
x$session
|
|
x$statement_analysis
|
|
x$statements_with_errors_or_warnings
|
|
x$statements_with_full_table_scans
|
|
x$statements_with_runtimes_in_95th_percentile |
|
x$statements_with_sorting
|
|
x$statements_with_temp_tables
|
|
x$user_summary
|
|
x$user_summary_by_file_io
|
|
x$user_summary_by_file_io_type
|
|
x$user_summary_by_stages
|
|
x$user_summary_by_statement_latency
|
|
x$user_summary_by_statement_type
|
|
x$wait_classes_global_by_avg_latency
|
|
x$wait_classes_global_by_latency
|
|
x$waits_by_host_by_latency
|
|
x$waits_by_user_by_latency
|
|
x$waits_global_by_latency
|
+-----------------------------------------------+
Comments
Post a Comment