I work for Amazon Web Services. The opinions I share in this blog are my own. I'm *not* communicating as a spokesperson for Amazon.
In other words, I work at Amazon, but this is my own opinion.
Join 743 other subscribers
All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.
Hey kevin, thanks for linking.. BTW here’s the permalink of the wiki SLOB cheat sheet http://goo.gl/yKa45
-Karl
The link for the SLOB Setup cheat sheet doesn’t work 😦
@aus_effendi : It should now… sorry about that…
Another suggestion… anyone who is leaving batches of SLOB tests running overnight might want to think about disabling the automated maintenance tasks in the scheduler otherwise the resource manager can start skewing your results, giving you Top 5 wait events such as “resmgr: cpu quantum”
Automatic maintenance tasks can be disabled by running:
EXEC DBMS_AUTO_TASK_ADMIN.DISABLE;