Overview
This article outlines how to run an Oracle Workloads collection and view Oracle projects for Live Optics.
Running an Oracle Workloads Collection
1. To create an Oracle Workloads project, first Download the Live Optics Collector. A new folder named “Oracle” will be included in the Live Optics Collector ZIP. In order to collect from Oracle, the user will manually run those scripts to capture the necessary AWR files. Check instructions on how to capture AWR reports.
2. The collector will then request that the user browse to the top folder where their oracle files are located
3. The collector will validate that at least one AWR file and one Disk report are available
4. The collector will show the total number of
- Capacity Report Files (*.txt files) (not required)
- AWR Report Files (*.html files) (required)
- Disk Report Files (*.dsk files) (required)
5. The user needs to confirm that he/she has a valid AWR license.
6. When the user clicks next, he/she’ll be redirected to the standard upload SIOKIT options screens.
Creating an Oracle Workloads Project
Creating an Oracle Workloads project can be done through one of the following upload methods:
- Upload collection data to the Live Optics web portal automatically
- Upload later (requires upload of generated SIOKIT file)
Viewing an Oracle Workloads Project
Once the project upload has been completed by one of the two methods mentioned above, a Live Optics project will be created on the portal. Newly created projects will automatically appear on the dashboard.
1. Summary Panel Left View
This panel will contain the standard project meta data.
Field |
Definition |
Start Time |
The earliest date pulled from the snap begin of any of the AWR files. |
End Time |
The most recent date pulled from the snap end of any of the AWR files. |
Duration |
End Time - Start Time shown in either minutes, hours, or days |
2. Summary Panel Right View
This panel will contain some high-level facts about the entire environment.
Field |
Definition |
Start Time |
The earliest date pulled from the snap begin of any of the AWR files. |
End Time |
The most recent date pulled from the snap end of any of the AWR files. |
Duration |
End Time - Start Time shown in either minutes, hours, or days |
Online Viewer – Details tab
- Instances: This tab displays a simple table of all of the database instances.
- Databases: This tab lists each database as a row.
- Hosts: This tab has a table with one row for each host.
- Graphs: The graphs tab will contain two graphs: IOPS & MB/sec
IOPS Graph
The IOPS graph will plot the aggregate IOPS (read and write) as a stacked area chart. The aggregate is for all database instances.
The 95th percentile line will be shown as a dashed constant line with a label that shows its value.
Throughput Graph
The throughput graph will plot the aggregate MB/sec (read and write) as a stacked area chart. The aggregate is for all database instances.
The 95th percentile line will be shown as a dashed constant line with a label that shows its value.