oltpday − Create a full day report of oltpforever
oltpday [-H] [-f] [-a] [-k key] [-R file] YYYY.MM.DD
Create a daily report for continuous runs
-H
Print short help.
-k key
Set to key that will be used when getting results from the repository database for creating the report. The default is the same as the project name.
-f
In addition to creating the daily report, also updates the report of all days by recreating the file. This is time consuming if you have data from many days available.
-a
In addition to creating the daily report, the fully daily report is updated with new or changed entries.
YYYY.MM.DD
The day for which you want to produce a report.
If you are running oltpforever for extended periods, you will typically want reports consisting of all runs that were during one 24h period; This is what the oltpday command does. The daily report will be put into a file available at the awr directory; it will have a name of YYYY.MM.DD.$key.html. Additionally, if you provide the -f option a html file with all days is generated; the name of this file is provided in the parameter file. Note that this operation can take very long if you have many days; use the -a option instead to only update the file.
To fully automate report generation, you must setup a daily call to oltpday via cron or a similar mechanism.
Rwloadsim itself and therefore also the dates stored in the repository are always UTC based, irrespective of the timezone in which the repository database is found and irrespective of the timezone of system where rwloadsim (and the oltp workload) is executed.
The English language lacks a term for a period of 24 hours.
Copyright
© 2023 Oracle Corporation
Licensed under the Universal Permissive License v 1.0 as
shown at https://oss.oracle.com/licenses/upl
oltp(2rwl), oltprun(2rwl), oltpforever(2rwl)