Overview
This article outlines how to run an Oracle Workloads collection on the Live Optics Linux collector and view Oracle projects in the Live Optics portal.
Running an Oracle Workloads Collection
- 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 Tar.gz. 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 user will specify the top folder where their oracle files are located (--oracle=<your oracle file path>)
3. The collector will gather the relevant files and validate that at least one AWR file and one Disk report are available.
4. First the user must accept the EULA.
5. The user is then prompted:
Would you like to upload the data now to Live Optics via an encrypted, secure connection over HTTPS/SSL (TCP port 443)?
Or, type no if you wish to package the data into a compressed, encrypted SIOKIT package file. (yes/no):
- If the user chooses no, then the SIOKIT file is generated based on the hostname an appending # if necessary to make a unique filename.
- If the user chooses yes, then the collector uploads the files to the Live Optics portal.
-
- 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 |
- 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.