Oracle Exadata Storage Server Configuration Metrics
The following configuration metrics are available for Oracle Exadata Storage Server:
Cell Configuration
Description: This metric provides Cell Configuration information.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| ID | Cell ID |
| Cell Name | Cell Name |
| BMC Type | BMC Type |
| Cell Version | Cell Version |
| Release Version | Release Version |
| CPU Count | Number of CPUs |
| Working Fan Count | Number of Working Fans |
| Total Fan Count | Total Fans |
| Interconnect Count | Interconnect Count |
| Interconnect Type | Interconnect type between the Database servers and Storage servers |
| IORM Boost | IORM Boost |
| IP Address 1 | IP Address 1 |
| CIDR Prefix Size 1 | CIDR Prefix Size 1 |
| IP Address 2 | IP Address 2 |
| CIDR Prefix Size 1 | CIDR Prefix Size 2 |
| IP Address 3 | IP Address 3 |
| CIDR Prefix Size 3 | CIDR Prefix Size 3 |
| IP Address 4 | IP Address 4 |
| CIDR Prefix Size 4 | CIDR Prefix Size 4 |
| Kernel Version | Kernel Version |
| Make Model | Make Model |
| Metric Retention (in Days) | Metric data retention in number of days |
| Working Power Count | Working Power Count |
| Total Power Count | Total Power Count |
| SNMP Subscriber | SNMP Subscriber |
| SMTP Server | Configured SMTP Server |
| SMTP Port | Configured SMPT Port |
| Flash Cache Mode | Flash Cache Configuration |
| Maximum Physical Disk IOPS | Maximum supported Physical Disk IOPS |
| Maximum Flash Disk IOPS | Maximum supported Flash Disk IOPS |
| Maximum Physical Disk MBPS | Maximum supported Physical Disk Throughput |
| Maximum Flash Disk MBPS | Maximum supported Flash Disk Throughput |
| Maximum DW Physical Disk IO Load | Maximum supported Data warehouse Physical Disk IO Load |
| Maximum DW Flash Disk IO Load | Maximum supported Data warehouse Flash Disk IO Load |
| Maximum OLTP Physical Disk IO Load | Maximum supported OLTP Physical Disk IO Load |
| Maximum OLTP Flash Disk IO Load | Maximum supported OLTP Flash Disk IO Load |
| Full Release Version | Full Release Version |
| PMEM Cache Mode | PMEM Cache Configuration |
| XRMEM Cache Mode | XRMEM Cache Configuration |
| Maximum Capacity-Optimized Flash Disk IOPS | Maximum supported capacity-optimized flash disks IOPS |
| Maximum Capacity-Optimized Flash Disk MBPS | Maximum supported capacity-optimized flash disks MBPS |
Cell Configuration Patches
Description: This metric provides cell configuration patches
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Bug Number | patch applied as a Bug Number |
Cell Disk Configuration
Description: This metric provides configuration details of cell disks of storage server.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Cell ID | Unique ID of Cell |
| Name | Celldisk name |
| Cell Name | Cell Name |
| Celldisk Comment | Celldisk Comment, if any |
| Creation Time | Celldisk creation time |
| Device Name | Device Name |
| Device Partition | Device Partition |
| ID | Celldisk ID |
| LUN | LUN formed from Celldisk |
| Raid Level | Raid Level |
| Celldisk Size (GB) | Celldisk size in GB |
Cell Flash Cache Cell Disks Configuration
Description: This metric provides cell disks configured as Flash Cache.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Cell ID | Cell ID |
| Cell Disk | Cell Disk Name |
| Flash Cache Name | Flash Cache Name |
| Degraded Cell Disks | Cell disks that are degraded are part of Flash Cache |
Cell Flash Cache Configuration
Description: This metric provides details of configured Flash Cache on storage server.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Cell ID | Cell ID |
| Flash Cache Name | Flash Cache Name |
| Cell Name | Cell Name |
| Creation Time | Flash Cache created time |
| Effective Size (GB) | Total usable size in GB |
| ID | Flash Cache ID |
| Size (GB) | Total size of Flash Cache in GB |
Cell Grid Disk Clients Configuration
Description: This metric provides grid disks client configuration
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Available To | Client that can access grid disk |
| Cell Name | Cell Name |
| Griddisk Name | Griddisk Name |
Cell Grid Disk Configuration
Description: This metric provides storage grid disks configuration
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Cell ID | Unique Cell ID |
| Cell Name | Cell Name |
| ASM Instance | ASM Instance Name |
| Disk Group | Grid Disk part of group |
| Cell Disk | Grid Disk part of Cell Disk |
| Griddisk Comment | Comment, if any added |
| Creation Time | Disk creation time |
| ID | Disk ID |
| Lowest Offset (MB) | Lowest Offset (MB) |
| Is Sparse | Is disk a spare or not ? |
| Griddisk Size(MB) | Griddisk Size in MB |
| Virtual Size (MB) | Virtual Size in MB |
Cell IORM Configuration
Description: This metric provides I/O Resource Management Configuration.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Cell ID | Cell ID |
| IO Resource Plan Name | IO Resource Plan Name |
| Cell Name | Cell Name |
| Category Plan | Category plan directives are concatenated |
| DB Plan | Inter-database plan directives are concatenated |
| IORM Objective | Objective of I/O management |
| IORM Status | IORM Status is active or not |
Cell LUN Configuration
Description: This metric provides configuration information of LUNs.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| LUN Name | LUN Name |
| Cell ID | Unique ID of cell |
| Name | Cell Name |
| Cell disk | Name of Celldisk |
| Device Name | Device Name |
| ID | Celldisk ID |
| System LUN | System LUN |
| LUN AutoCreate | LUN AutoCreated or not |
| LUN Size (GB) | Size in GB |
| Raid Level | Raid Level |
| LUN UID | LUN Unique ID |
CELL LUN Physical Disks Configuration
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| LUN Name | LUN Name |
| Physical Device | Physical Device used for LUN Creation |
| Cell ID | Cell Unique ID |
Cell Physical Disk Configuration
Description: Configuration details of Physical Devices
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Slot Number | Physical device allocated slot |
| Cell ID | Unique ID of cell |
| Physical Disk Name | Name of Physical Device |
| Cell Name | Name of Cell |
| ID | Physical Device ID |
| Insert Time | Inserted time |
| Disk Size (GB) | Size in GB |
| Disk Type | Type of disk |
| Make Model | Make Model |
| Physical Interface | Physical Interface |
| Physical Firmware | Physical Firmware |
| Physical Serial | Serial ID |
Cell Physical Disk Luns Configuration
Description: This metric provides association between Physical Disk and LUN
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Slot Number | Physical Disk slot number |
| LUN | LUN |
| Cell ID | Unique ID of cell |
| Name | Cell name |
Exadata Cell Databases Metric
Description: This metric provides list of databases and their related info
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Database Name | Full Database name including qualifying prefixes, if applicable |
| Internal Database Name | Database name without any qualifying prefix, unique within a cluster |
| ASM Cluster Name | ASM Cluster Name |
| Profile Name | Profile Name |
| IORM Share | IORM Share |
| IORM Disk Share | IORM Disk Share |
| IORM Flash Share | IORM Flash Share |
| Database Unique ID | Database unique ID |
| IORM Limit | IORM Limit |
| IORM Disk Limit | IORM Disk Limit |
| IORM Flash Limit | IORM Flash Limit |
| Vault Name | Vault name |
Exadata Inter-database Plan
Description: This metric provide configured inter-database plan on storage server.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config key |
| Database/Profile Name | It could be a database name or profile name |
| Cell ID | Cell ID |
| IO Resource Plan Name | IO Resource Plan Name |
| ASM Cluster Name | Database part of a ASM Cluster, if any |
| Level-1 Allocation/Share | Level 1 Allocation in context of Percentage based plan. Share value in case of Share based plan |
| Level-2 Allocation | Level 2 Allocation as part of Percentage based plan |
| Level-3 Allocation | Level 3 Allocation as part of Percentage based plan |
| Level-4 Allocation | Level 4 Allocation as part of Percentage based plan |
| Level-5 Allocation | Level 5 Allocation as part of Percentage based plan |
| Level-6 Allocation | Level 6 Allocation as part of Percentage based plan |
| Level-7 Allocation | Level 7 Allocation as part of Percentage based plan |
| Level-8 Allocation | Level 8 Allocation as part of Percentage based plan |
| Disk I/O Utilization Limit | Disk I/O Utilization Limit |
| Role | Role (available for Data Guard database) |
| Flash Cache | Flash Cache is enabled or not |
| Flash Log | Flash Log is enabled or not |
| Flash Cache Space Usage Minimum (MB) | Flash Cache Space Usage Minimum |
| Flash Cache Space Usage Limit (MB) | Flash Cache Space Usage Limit |
| Flash Cache Space Fixed Allocation (MB) | Flash Cache Space Fixed Allocation |
| Directive Type | Indicates the directive (row) configuration for a database or a profile. |
| Is Percentage based Plan |
Yes - if the plan is Percentage based plan No - if the plan is Share based plan |
| PMEM/XRMEM Cache | PMEM/XRMEM Cache enabled or not |
| PMEM/XRMEM Log | PMEM/XRMEM Log enabled or not |
| PMEM/XRMEM Cache Space Usage Minimum (MB) | PMEM/XRMEM Cache Space Usage Minimum |
| PMEM/XRMEM Cache Space Usage Limit (MB) | PMEM/XRMEM Cache Space Usage Limit |
| PMEM/XRMEM Cache Space Fixed Allocation (MB) | PMEM/XRMEM Cache Space Fixed Allocation |
Exadata Pluggable Databases Metric
Description: This metric provides details of pluggable databases running on storage server.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Full Pluggable Database Name | Pluggable database name including qualifying prefixes, if applicable. |
| Pluggable Database ID | Pluggable Database ID |
| Container Database Name | PDB running in a container database name |
| Pluggable Database Name | Pluggable Database Name |
| ASM Cluster Name | ASM Cluster Name |
| Vault Name | Vault Name (will be available if storage is provided from ExaScale) |
| IORM Share | IORM Share |
| IORM Disk Share | IORM Disk Share |
| IORM Flash Share | IORM Flash Share |
| IORM Limit | IORM Limit in % |
| IORM Disk Limit | IORM Disk Limit in % |
| IORM Flash Limit | IORM Flash Limit in % |
Flash Log Cell Disks Configuration
Description: This metric provides details of cell disks configured as Flash Log.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Cell Disk | Cell Disk Name |
| Cell ID | Cell ID |
| Flash Log Name | Flash Log name |
| Degraded Cell Disks | Degraded cell disks that forms Flash Log |
Flash Log Configuration
Description: This metric provides details of configured Flash Log on storage server.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Cell ID | Cell ID |
| Flash Log Name | Flash Log Name |
| Cell Name | Cell Name |
| Creation Time | Flash Log created time |
| Effective Size (GB) | Total usable Flash Log in GB |
| Object Size (GB) | Total space available Flash Log in GB |
HCA Configuration
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Channel Adapter Display Name | Channel Adapter Display Name |
| HCA Node GUID | GUID of HCA Node |
| Channel Adapter Name | Channel Adapter Name |
| Number of ports | Number of HCA Ports |
| Channel Adapter Type | Channel Adapter Type |
| Firmware version | Firmware version |
| Hardware version | Hardware version |
| IP Address | HCA Node IP Address |
| IP Address 2 | HCA Node IP Address 2 |
HCA Port Connections and Configuration
Description: This metric collects configuration of HCA Port
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Channel Adapter Display Name | Channel Adapter Display Name |
| Port Number | Port Number |
| HCA Node GUID | HCA Node GUID |
| Port GUID | Port GUID |
| Switch GUID on the other end of the link | Connected Switch GUID |
| Switch Port number on the other end of the link | Switch Port number on the other end of the link |
| Supported link speed (Gbps) | Maximum speed in Gbps |
| Supported link width | Supported link width (Eg 1x or 4x) |
| Enabled link speed (Gbps) | Enabled link speed in Gbps |
| Enabled link width | Enabled link width (Eg 1x or 4x) |
IORM Category Plan
Description: This metric collects Category plan configured on storage server.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Config Key | Config Key |
| Category Name | Category Name |
| Cell ID | Cell ID |
| IO Resource Plan Name | I/O Resource Plan Name |
| Level-1 Allocation | Level-1 Allocation |
| Level-2 Allocation | Level-2 Allocation |
| Level-3 Allocation | Level-3 Allocation |
| Level-4 Allocation | Level-4 Allocation |
| Level-5 Allocation | Level-5 Allocation |
| Level-6 Allocation | Level-6 Allocation |
| Level-7 Allocation | Level-7 Allocation |
| Level-8 Allocation | Level-8 Allocation |
Network Ports
Description: This config metric provides network ports.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Name | Identity of the port. Unique within the Target, whether switch or host or cell |
| Address | Address of the port. For Ethernet - MACAddress, IB - GUID, FC - WWN |
| Port Address | The physical address of the port |
| Port Number | The port number |
| Peer Address | The physical address of the peer |
| Peer Port Address | The physical address of the peer port |
| Peer Port Number | The port number of the peer port |
| Peer Port Type | Peer port type |
| Description | The description, if any, of the port |
| Device Path | The device path of the port |
| Device ID | The port device id of the port |
| Location | The location of the port |
| Media Type | Port Media Type |
| Port Type | The Port Type |
| Management Port? | Indicate if this is a management port |
| Containing Device ID | The ports controller ID |
| Role (Physical/Logical) | The role of the port |
| Serial Number | Port serial number |
Network Ports Extended Information
Description: This config metric provides extended information for ports.
Collection Frequency: 24 hours
| Metric Column | Description |
|---|---|
| Name | Identifier for the port. Unique within the Target, whether switch or host |
| Port Number | The Port Number |
| Port Version | The port version |
| Local IP Address | The IP address associated with the local port |
| Local Subnet Mask | The subnet mask associated with the local port |
| Remote IP Address | The IP address associated with the remote port |
| Peer Port Number | The port number of the peer connected |
| Local DNS | The dns name of the asset associated with the local port |
| Remote DNS | The dns name of the asset associated with the remote port |
| Connector Type | The port connector type |
| Connector ID | The port connector ID |
| Connector Position | The port connector position |
| Connector Description | The port connector description |
PMEM Cache Cell Disks Configuration
Description: This config metric provides information of Cell Disks that provides PMEM Cache.
Collection Frequency: 24 hours
This config metric is available for:
- Storage Servers of version 21.* and 22.*
- Network of type RoCE
| Metric Column | Description |
|---|---|
| Config Key | PMEM Cache cell cisk configuration key |
| Cell Disk | Cell disk used for PMEM Cache |
| Cell ID | Exadata storage server unique ID |
| PMEM Cache Name | Unique name for the PMEM cache |
| Degraded Cell Disk | PMEM cache cell disk is degraded |
PMEM Cache Configuration
Description: This config metric collects information related to PMEM Cache.
Collection Frequency: 24 hours
This config metric is available for:
- Storage Servers of version 21.* and 22.*
- Network of type RoCE
| Metric Column | Description |
|---|---|
| Config Key | PMEM cache configuration key |
| PMEM Cache ID | GUID that is generated when the PMEM cache is created |
| Cell ID | Exadata storage server unique ID |
| Cell Name | Unique name for the cell |
| PMEM Cache Name | Unique name for the PMEM cache |
| Creation Time | Time when the PMEM cache was created |
| Effective Cache Size (GB) | Usable PMEM cache size after deducting space on unavailable cell disks. |
| Total Size (GB) | Total size of the PMEM cache. |
| Status | PMEM sache status |
PMEM Log Cell Disks Configuration
Description: This config metric provides information of Cell Disks that provides PMEM Log
Collection Frequency: 24 hours
This config metric is available for:
- Storage Servers of version 21.* and 22.*
- Network of type RoCE
| Metric Column | Description |
|---|---|
| Config Key | PMEM log cell disk configuration key |
| Cell Disk | Cell disk used for PMEM |
| Cell ID | Exadata storage server unique ID |
| PMEM Log Name | Unique name for the PMEM log |
| Degraded Cell Disk | PMEM log cell disk is degraded |
PMEM Log Configuration
Description: This config metric provides PMEM Log configuration information.
Collection Frequency: 24 hours
This config metric is available for:
- Storage Servers of version 21.* and 22.*
- Network of type RoCE
| Metric Column | Description |
|---|---|
| Config Key | PMEM log configuration key |
| PMEM Log ID | GUID that is generated when the PMEM log is created |
| Cell ID | Exadata storage server unique ID |
| Cell Name | Unique name for the cell |
| PMEM Log Name | Unique name for the PMEM log |
| Creation Time | Time when the PMEM log was created |
| Total Size (MB) | Total size of the PMEM log |
| Effective Cache Size (MB) | Usable PMEM log size after deducting space on unavailable cell disks |
| Efficiency (%) | Efficiency of PMEM log (%) |
| Status | PMEM log status |
XRMEM Cache Cell Disks Configuration
Description: This metric provides cell disks information that forms XRMEM Cache
Collection Frequency: 24 hours
This config metric is available for
- Storage Servers of version 23.* and above
- Network of type RoCE
| Metric Column | Description |
|---|---|
| Config Key | XRMEM Cache cell cisk configuration key |
| Cell Disk | Cell disk used for XRMEM |
| Cell ID | Exadata storage server unique ID |
| XRMEM Cache Name | Unique name for the XRMEM cache |
| Degraded Cell Disk | XRMEM cache cell disk is degraded |
XRMEM Cache Configuration
Description: This metric provides configuration of XRMEM Cache.
Collection Frequency: 24 hours
This config metric is available for
- Storage Servers of version 23.* and above
- Network of type RoCE
| Metric Column | Description |
|---|---|
| Config Key | XRMEM cache configuration key |
| XRMEM Cache ID | GUID that is generated when the XRMEM cache is created |
| Cell ID | Exadata storage server unique ID |
| Cell Name | Unique name for the cell |
| XRMEM Cache Name | Unique name for the XRMEM cache |
| Creation Time | Time when the XRMEM cache was created |
| Effective Cache Size (GB) | Usable XRMEM cache size after deducting space on unavailable cell disks |
| Total Size (GB) | Total size of the XRMEM cache |
| Status | XRMEM cache status |
XRMEM Log Cell Disks Configuration
Description: This metric provides details of cell disks that forms XRMEM Log
Collection Frequency: 24 hours
This config metric is available for:
- Storage Servers of version 23.* and above
- Network of type RoCE
| Metric Column | Description |
|---|---|
| Config Key | XRMEM log cell disk configuration key |
| Cell Disk | Cell disk used for XRMEM |
| Cell ID | Exadata storage server unique ID |
| XRMEM Log Name | Unique name for the XRMEM log |
| Degraded Cell Disk | XRMEM log cell disk is degraded |
XRMEM Log Configuration
Description: This metric provides configuration details about XRMEM Log.
Collection Frequency: 24 hours
This config metric is available for:
- Storage Servers of version 23.* and above
- Network of type RoCE
| Metric Column | Description |
|---|---|
| Config Key | XRMEM log configuration key |
| XRMEM Log ID | GUID that is generated when the XRMEM log is created |
| Cell ID | Exadata storage server unique ID |
| Cell Name | Unique name for the cell |
| XRMEM Log Name | Unique name for the XRMEM log |
| Creation Time | Time when the XRMEM log was created |
| Total Size (MB) | Total size of the XRMEM log |
| Effective Cache Size (MB) | Usable XRMEM log size after deducting space on unavailable cell disks |
| Efficiency (%) | Efficiency of XRMEM log (%) |
| Status | XRMEM log status |