... 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
Comments
Post a Comment