Overview
This article outlines the Oracle Workloads Excel report and corresponding definitions.
Instances
This tab displays a simple table of all of the database instances.
Column Name |
Definition |
Version |
The instance version |
Hostname |
The instance hostname |
Instance |
The instance name |
RAC |
Either yes or no based on whether this instance is RAC |
CPU |
The total number of CPUs as reported by the OS for the instance. Note: this often include hyper-threading or SMT |
Cores |
The total number of CPU cores for this instance |
Sockets |
The total number of CPU socket packages on this instance |
Block Size |
The block size shown in bytes for this instance |
System Global Area (SGA) Max Size |
Shown in MIBs. |
Program Global Area (PGA) Max |
Shown in MIBs. |
AWR File Count |
The number of AWR files provided for this instance |
Peak Read IOPS |
riops_max |
Peak Write IOPS |
wriops_max |
Peak IOPS |
aiops_max |
Peak Physical Write Total |
phy_wrt_MIBs_max |
95th% Physical Write Total |
95th percentile phy__wrt_MIBs |
Peak MB/sec |
bandwidth_MIBs_max |
95th% MB/sec |
95th percentile bandwidth_MIBs |
DB Block Change 95th% |
dbblk_change_MIBs_95 |
DG MB/sec 95th% |
db_bandwidth-MIBs_95 |
Exadata Real IO |
exarealio_MIBs_95 |
Read Percentage |
avg_rd_pct |
Peak Read Percentage |
peak of the avg_rd_pct |
Databases
This tab lists each database as a row.
Column Name |
Definition |
Database ID |
The database ID |
Database Name |
The database name |
RAC |
Either yes or no whether or not this database is RAC or not |
Total Capacity |
The total capacity shown in GIBs |
Encrypted Capacity |
The encrypted capacity shown in GIBs |
Compressed Capacity |
The compressed capacity shown in GBs |
Unused Capacity |
The unused capacity shown in GIBs |
Log Generation |
The log generated capacity for this database in GIBs |
Hosts
This tab has a table with one row for each host.
Column Name |
Definition |
Hostname |
The host name |
Host Platform |
The platform string for the host. |
Instance Count |
The number of instances on this host. |
CPU |
The total number of CPUs as reported by the OS for the instance. Note: this often include hyper-threading or SMT |
Cores |
The total number of CPU cores for this host |
Sockets |
The total number of CPU socket packages on this host |
Memory |
The memory for the host in GIB |
Peak Load |
The max_load |
Peak User % |
The max_usr shown as a percentage |
Peak System % |
The max_sys shown as a percentage |
Peak Idle % |
The max_idl shown as a percentage |
Peak IO Wait % |
The max_iowait shown as a percentage |
AWR File Count |
The number of AWR report files associated with this host |