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 MBs. |
|
Program Global Area (PGA) Max |
Shown in MBs. |
|
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_MBs_max |
|
95th% Physical Write Total |
95th percentile phy__wrt_MBs |
|
Peak MB/sec |
bandwidth_MBs_max |
|
95th% MB/sec |
95th percentile bandwidth_MBs |
|
DB Block Change 95th% |
dbblk_change_MBs_95 |
|
DG MB/sec 95th% |
db_bandwidth-MBs_95 |
|
Exadata Real IO |
exarealio_MBs_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 GBs |
|
Encrypted Capacity |
The encrypted capacity shown in GBs |
|
Compressed Capacity |
The compressed capacity shown in GBs |
|
Unused Capacity |
The unused capacity shown in GBs |
|
Log Generation |
The log generated capacity for this database in GBs |
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 GB |
|
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 |