Sunday, 25 June 2017

Exploring the OCI 7.3 Data Warehouse Data Marts with DbVisualizer: Part 2 of 2

... continuing from part 1.

Part 2: Exploring the OCI 7.3 Data Warehouse Database

DbVisualiser displays the DWH Data Marts as listed below:

- dwh_capacity
- dwh_capacity_efficiency
- dwh_custom
- dwh_fs_util
- dwh_inventory
- dwh_performance
- dwh_ports
- dwh_reports
- information_schema
- tmp

Image: Data Warehouse Data Marts in DbVisualizer

And here’s a listing of all the tables in each dwh* Data Mart, with TABLE_NAME and TABLE_TYPE.

Listing of Tables in Data Warehouse Data Marts

dwh_capacity (32 tables)

TABLE_NAME ---------------------------- TABLE_TYPE
application_dimension                         VIEW
application_group_bridge                      VIEW
application_group_dimension                   VIEW
business_entity_dimension                     VIEW
capacity_type                                 TABLE
cardinals                                     VIEW
chargeback_fact                               TABLE
datastore_dimension                           VIEW
date_dimension                                VIEW
disk_group_capacity_fact                      TABLE
disk_group_capacity_future_fact               TABLE
disk_group_dimension                          VIEW
host_dimension                                VIEW
host_group_bridge                             VIEW
host_group_dimension                          VIEW
internal_volume_capacity_fact                 TABLE
internal_volume_dimension                     VIEW
qtree_capacity_fact                           TABLE
qtree_dimension                               VIEW
service_level_dimension                       VIEW
sp_time_to_fill                               TABLE
storage_and_storage_pool_capacity_fact        TABLE
storage_and_storage_pool_capacity_future_fact TABLE
storage_dimension                             VIEW
storage_pool_dimension                        VIEW
tier_dimension                                VIEW
vm_capacity_fact                              TABLE
vm_dimension                                  VIEW
volume_capacity_fact                          VIEW
volume_dimension                              VIEW
volume_fact_current                           TABLE
volume_history_capacity_fact                  TABLE

dwh_capacity_efficiency (3 tables)

TABLE_NAME ---------------------------- TABLE_TYPE
date_dimension                                VIEW
efficiency_fact                               TABLE
storage_dimension                             VIEW

dwh_custom (1 table)

TABLE_NAME ---------------------------- TABLE_TYPE
esx_subscription_history_fact                 TABLE

dwh_fs_util (8 tables)

TABLE_NAME ---------------------------- TABLE_TYPE
compute_resource_dimension                    VIEW
date_dimension                                VIEW
file_system_dimension                         VIEW
fs_util_fact                                  TABLE
host_dimension                                VIEW
storage_dimension                             VIEW
tier_dimension                                VIEW
vm_dimension                                  VIEW

dwh_inventory (99 tables)

TABLE_NAME ---------------------------- TABLE_TYPE
acq_acquisition_unit                          TABLE
acq_data_source                               TABLE
annotation_value                              TABLE
application                                   TABLE
auto_tiering_policy                           TABLE
auto_tiering_policy_constraint                TABLE
backend_lun                                   TABLE
backend_lun_to_volume                         TABLE
backend_path                                  TABLE
business_entity                               TABLE
cm_lun_requests                               VIEW
cm_lun_requirement                            TABLE
cm_port_requests                              VIEW
cm_port_requirement                           TABLE
cm_request                                    TABLE
compute_resource                              TABLE
disk                                          TABLE
disk_group                                    TABLE
disk_group_to_disk                            VIEW
disk_group_to_storage_pool                    VIEW
dr_internal_volume_replica                    TABLE
dr_qtree_replica                              TABLE
dr_replica                                    VIEW
dr_volume_replica                             TABLE
fabric                                        TABLE
fc_name_server_entry                          TABLE
file_system                                   TABLE
file_system_to_virtual_disk                   TABLE
file_system_to_volume                         TABLE
generic_device                                TABLE
generic_device_port                           TABLE
host                                          TABLE
host_adapter                                  TABLE
host_port                                     TABLE
host_to_application                           TABLE
hv_data_store                                 TABLE
hv_data_store_to_internal_volume              TABLE
hv_data_store_to_volume                       TABLE
hv_datastore_to_nas_share                     TABLE
hv_host_to_nas_share                          TABLE
hv_lun                                        TABLE
hv_lun_to_volume                              TABLE
hv_nas_share                                  TABLE
hv_nas_share_to_share                         TABLE
hv_path                                       TABLE
hv_server                                     TABLE
hv_virtual_disk                               TABLE
hv_virtual_disk_to_volume                     TABLE
hv_virtual_machine                            TABLE
hv_virtual_machine_to_disk                    TABLE
internal_volume                               TABLE
internal_volume_to_application                TABLE
iscsi_logical                                 TABLE
license_details                               TABLE
logical                                       TABLE
nas_cr_logical                                TABLE
nas_file_share                                TABLE
nas_logical                                   VIEW
nas_share                                     TABLE
nas_share_initiator                           TABLE
object_to_annotation                          TABLE
physical_path                                 TABLE
port_connectivity                             TABLE
qtree                                         TABLE
qtree_to_application                          TABLE
quota                                         TABLE
service_level                                 VIEW
share_to_application                          TABLE
storage                                       TABLE
storage_controller                            TABLE
storage_node                                  TABLE
storage_node_to_internal_volume               VIEW
storage_node_to_port                          VIEW
storage_node_to_storage_pool                  VIEW
storage_node_to_volume                        VIEW
storage_pool                                  TABLE
storage_pool_to_backend_lun                   VIEW
storage_pool_to_disk                          VIEW
storage_port                                  TABLE
storage_to_application                        TABLE
switch                                        TABLE
switch_port                                   TABLE
switch_port_to_application                    TABLE
switch_to_application                         TABLE
tape                                          TABLE
tape_controller                               TABLE
tape_port                                     TABLE
tier                                          VIEW
violation                                     TABLE
virtual_switch                                TABLE
virtual_to_backend_volume                     VIEW
vm_to_application                             TABLE
volume                                        TABLE
volume_in_storage_pool                        VIEW
volume_map                                    TABLE
volume_mask                                   TABLE
volume_to_application                         TABLE
zone                                          TABLE
zone_member                                   TABLE

dwh_performance (46 tables)

TABLE_NAME ---------------------------- TABLE_TYPE
application_dimension                         VIEW
application_group_bridge                      VIEW
application_group_dimension                   VIEW
application_volume_hourly_performance_fact    TABLE
business_entity_dimension                     VIEW
capacity_volume_fact_current                  VIEW
connected_device_dimension                    VIEW
datastore_dimension                           VIEW
date_dimension                                VIEW
disk_daily_performance_fact                   TABLE
disk_dimension                                VIEW
disk_hourly_performance_fact                  TABLE
fabric_dimension                              VIEW
host_dimension                                VIEW
host_group_bridge                             VIEW
host_group_dimension                          VIEW
host_vm_daily_performance_fact                TABLE
host_vm_hourly_performance_fact               TABLE
host_volume_hourly_performance_fact           TABLE
internal_volume_daily_performance_fact        TABLE
internal_volume_dimension                     VIEW
internal_volume_hourly_performance_fact       TABLE
port_dimension                                VIEW
service_level_dimension                       VIEW
storage_dimension                             VIEW
storage_node_daily_performance_fact           TABLE
storage_node_dimension                        VIEW
storage_node_hourly_performance_fact          TABLE
storage_pool_dimension                        VIEW
switch_dimension                              VIEW
switch_performance_for_host_hourly_fact       TABLE
switch_performance_for_port_hourly_fact       TABLE
switch_performance_for_storage_hourly_fact    TABLE
switch_performance_for_tape_hourly_fact       TABLE
tape_dimension                                VIEW
tier_dimension                                VIEW
time_dimension                                TABLE
vm_daily_performance_fact                     TABLE
vm_dimension                                  VIEW
vm_hourly_performance_fact                    TABLE
vmdk_daily_performance_fact                   TABLE
vmdk_dimension                                VIEW
vmdk_hourly_performance_fact                  TABLE
volume_daily_performance_fact                 TABLE
volume_dimension                              VIEW
volume_hourly_performance_fact                TABLE

dwh_ports (7 tables)

TABLE_NAME ---------------------------- TABLE_TYPE
cardinals                                     VIEW
connected_device_dimension                    TABLE
date_dimension                                VIEW
port_dimension                                VIEW
ports_fact                                    TABLE
ports_fact_current                            VIEW
switch_dimension                              VIEW

dwh_reports (2 tables)

TABLE_NAME ---------------------------- TABLE_TYPE
report_orphaned_volumes                       VIEW
report_storage_summary_aux                    VIEW

THE END

No comments:

Post a Comment