– Console URL
– User name
– User password
– Only services
– Only services matching a wildcard
– Only not empty
– Only for last 10 minutes
– Fields to output
– Collect all statistics from a domain
– Collect only service-level statistics
– Collect only from services that have messages
– Check that the domain has no traffic before deployment
– Merge a few files into one report
– Output a subset of fields
ReadOsbStats is a command-line Java application to export Oracle OSB statistics into a CSV file.
The application collects both service-level and operations-level statistics. All statistics is collected from the last reset time.
ReadOsbStats doesn’t need administrative privileges.
It can work over HTTP or HTTPS, including the domains with self-signed certificates.
- JRE 1.6 or later.
- Oracle OSB 11g.
- An account on the target OSB domain with monitor (or higher) privileges.
java -jar readosbstats.jar [(-c|--console) <console>] [(-u|--user) <user>] [(-p|--pass) <pass>] [-m|--merge] [(-f|--fields) <fields>] [-s|--servicelevel] [-z|--nonzero] [(-o|--output) <output>] [-h|--help] [file1 file2 ... fileN]
|-c URL||OSB console URL, e.g. -c http://22.214.171.124:7001/sbconsole|
|-u username||OSB user name. Must have at least monitor permissions. NB: Please do not use admin users for collecting stats, it is not secure! If the username starts with @, it is interpreted as a file name containing colon-separated username and password, e.g. -u @admin.credentials.txt, where admin.credentials.txt file would contains a single line such as weblogic:weblogic1|
|-p password||OSB user password.|
|-s||Only collect service-level statistics, omitting operation-level values.|
|-i wildcard||Only collect statistics for services that match the provided wildcard, e.g. -i Wireless*|
|-z||Only output statistics for resources and operations that have non-zero messages count.|
|-t||Only output statistics for the current interval (usually last 10 minutes).|
|-f fields|| Comma-separated list of fields to output:
msgs: Number of messages
errs: Number of errors
min: Minumum response time, ms
avg: Average response time, ms
max: Maximum response time, ms
succ: Success, %
fail: Failures, %
chit: Cache hits
crat: Cache hits ratio
mint: Minumum time in throttling queue, ms
avgt: Average time in throttling queue, ms
maxt: Maximum time in throttling queue, ms
Example: -f msgs,errs,avg
|-o||Output file or directory name.|
Getting all statistics from a domain
java -jar readosbstats.jar -c https://loadtest4/sbconsole -u monitor -p welcome1
Getting only service-level statistics into a provided file
java -jar readosbstats.jar -c https://loadtest4/sbconsole -u monitor -p welcome1 -s -o services.csv
Getting only resources and operations that have messages
java -jar readosbstats.jar -c https://loadtest4/sbconsole -u monitor -p welcome1 -z
Check that the domain has no traffic before deployment
java -jar readosbstats.jar -c https://loadtest4/sbconsole -u monitor -p welcome1 -t -z
Merging a number of snapshots into one CSV
java -jar readosbstats.jar -m services20150101.csv services20150102.cvs services20150103.csv
Only recording number of messages and the average response time
java -jar readosbstats.jar -c https://loadtest4/sbconsole -u monitor -p welcome1 -f msgs,avg