Sorry, I thought I had pushed 'SEND' on this earlier, and here it is in my
drafts folder.
On Fri, Jan 26, 2018 at 8:11 AM, Jared Still <jkstill@xxxxxxxxx> wrote:
Hi Niall, comments inline:
On Fri, Jan 26, 2018 at 3:45 AM, Niall Litchfield <
niall.litchfield@xxxxxxxxx> wrote:
Hi JaredAgreed. I suspect it may be an AWR report bug.
The AWR reports look a little odd to me. I'd expect a SLOB Update test to
result in write I/O as well as read I/O. For comparison here's an output
from a 25% update run I did recently.
Collecting AWR metrics at the PDB level is new to 12.2, and there may be
bugs.
What I have planned to do is run another test but manually run AWR
before/after snapshots at the CDB level and then run that report.
So far as I can tell there's no write activity in your AWR reports. I'dAgreed, not much in the report, but as SLOB was always set to 20-50%
further suggest that a useful metric since you are looking at I/O
performance, would be SLOBOps/sec/vCPU - or else duration of a fixed run.
update, there definitely should be write activity.
That all said, I see you are using the current (or at least a recent)
version of slob, whereas I'm still using one from 2014 (not yet validated
comparability of results from the newer kit).
Yes, the most recent version of SLOB.
I have modified it a bit to call the AWR reports at the PDB level. These
are minor changes to call PDB rather than CDB reports.
Seen here if you like: https://github.com/jkstill/SLOB-PDB
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill