BLOG UPDATE 2014.09.11: Please note: the following is a link to a more recent update of the awr_info.sh script. This version adds DB Time, DB CPU and Logical I/O: click here. The MD5 sum for this version of awr_info.sh is: a28a38b11040bb94f08a8f817792c75c
The SLOB kit comes with a little script that extracts interesting information from the awr.txt file produced at the end of a SLOB test. This is just a quick blog entry to point folks to a patched version of awr_info.sh that works properly with all Oracle Database 11g releases as well as Oracle Database 12c.
Oracle changed AWR format in the 188.8.131.52 and 12c releases so the old awr_info.sh script (in the publicly available SLOB kit) has been faulty for some time now.
I have a release of SLOB in the works that will include this awr_info.sh as well as improved data loader and improvements to the driver script (runit.sh) that includes optional, tunable think time between iterations of the SLOB work loop in slob.sql. For the time being please get a copy of the patched version of awr_info.sh.
This version of awr_info.sh also gleans and outputs logical read (SGA buffer pool cached block accesses) data.
The following screen shot shows the patched awr_info.sh generating proper output for awr.txt files collected by SLOB databases running out of the 184.108.40.206, 220.127.116.11 and 12c releases.
The following picture is what Microsoft Excel looks like when I cut and paste the output of awr_info.sh. I’ve highlighted the new column for logical reads.
Yes, the above picture does show AWR output from a run where the top wait event was cell single block physical read. Exadata? Yes! That’s because SLOB users often share their testing results from the Exadata platform. However, I do not get enough Exadata AWR reports to work through all of the awr_info.sh issues related to Exadata. To that end, latency information is not calculated and presented as is the case with db file sequential read. For what it’s worth this particular AWR report shows Exadata single block reads serviced with average latencies of 507 microseconds ( 7233/14256602).
The following is a link to my syncplicity share with the README for this patch: Click here for the patch README.
Finally, the patched version of awr_info.sh is available here: Click here for the latest awr_info.sh script. Please verify the MD5 sum after you download this script to match a28a38b11040bb94f08a8f817792c75c.
Filed under: oracle
Another message from “Farnham for US Senate”
Lately, there has been a lot of news about “corporate inversion.” Essentially a large US based corporation essentially buys a foreign company based in a country with lower corporate income tax rates, but designates that the acquisition is now actually the top of the corporate structure. With this stroke of paperwork (producing nothing), the net income after taxes is improved for the stockholders. Aside from the public relations (which might be costly, especially in consumer products), this is what management should do: Maximize the returns to stockholders.
This is just a new wrinkle in the idiocy and waste that is taxing corporations on income.
Since customers pay corporate income taxes anyway, how about we take away the corporate incentive to lobby to complicate the tax code by eliminating the corporate income tax altogether. Now of course they should pay fees for services, such as property tax to pay for police and fire coverage and taxes on gasoline an diesel fuel to build roads and mass transit. But all manner of evil and waste are eliminated at no necessary revenue decrease by ending corporate income taxes. So what happens? Well, first off, the first country to eliminate the corporate income tax wins. (New Hampshire, with no personal income tax, might become a corporate headquarters darling, but that is parochial.) Now, instead of “inversion” acquisitions, companies will race to bring their headquarters and highest paid executives to the US. Sweet. They also will only need one set of books, so “tax accounting” and all the associated distortions and unproductive waste (that currently is very beneficial to the bottom line without producing anything) goes “poof.” Companies will save a (Burger) King’s ransom by not having to do all manner of accounting adjustments to minimize tax. Operations and cost accounting will drive corporate behavior and they will be out of the income tax credit business.
Prices will drop. Profits and dividends will rise. Individuals will get increased income from investments and they will pay tax on that. Everyone wins except the lobbyists and legislators who lobbyists pamper and fund to win favor.
Ending corporate income tax eliminates waste and improper influence by economic force.
Christ was very clear “Love your neighbor and your enemy as yourself.” You can SAY you’re Christian and do hateful things all the time, and none of us is perfect (Methodists like to say we’re trying to keep on a walk toward perfection, knowing that is not a walk we will complete), but you really are not a Christian if you are preaching hatred of … any … one … most especially and saying this hatred comes with God’s approval. Sigh. Oh – and the bit about which prophesy is being fulfilled and when – don’t bother. He’s coming back like a thief in the night and no one will know the day or time of His Coming until it happens. Anyone who thinks they can decode specifics out of Revelations is just wrong, from Christ’s own mouth. As for extracting literal rules out of the old testament, that would be a neat trick if anyone could do it figuring translations, symbols, arcana of math and all that, but the new covenant tempered all those things with the rule of Love anyway. So even if you buy as literal the old testament based on Emperor Constantine’s wishes of what it was useful for the Roman empire to include, you have to re-interpret all that in light of the new testament. Christ and Mohammed both ultimately proclaimed the rules of love and peace. So a great cartoon would be Mohammed down in the dumps and Jesus walks by and asks Mo “why so sad Mo?” And Mo replies: “Some people who claim to follow Islam are wantonly killing innocents and it is happening all the time.” Tsk, Tsk, Mo. You gave them some pretty tough rules. Imagine how I feel. I told them to Love One Another and Love their neighbor as themselves, and still I get people killing people in My Name. I did said go and make disciples in all nations. I never said “At the point of a sword!”
So yeah. Even though I’m a published scientist (thanks for the co-author status, Andy. Maybe, as you said, I did earn it – but it was still kind) and I think that if you want to make predictions about what is going to happen on this physical plane you devise theories and methods to test the theories and use the theory that is most likely (given the confidence levels of those test results) to produce a correct result for the situation you face… Even though, that, I think we can improve the world by thinking in term’s of Christ’s Love. Give it a try. You do not have to stop making rational decisions. Now I’ll leave you with a verse, and many of you will probably hum the tune: “Lord I want to be a Christian, In my heart, In me he-art. Lord I want to be a Christian, In my hear.
And seriously, if you’re moved to violence by something, no way you get to claim it was for God.
“Oracle PL/SQL Performance Tuning Tips & Techniques” by Michael Rosenblum and Dr. Paul Dorsey is a book you should read soon. A quote from Oracle’s Bryn Llwellyn in the book’s forward says it all “Every professional PL/SQL programmer should study this book and act upon its teachings.”
Misha and Paul take the scientific route to performance, providing readers the how-and-why of effective performance. The first chapter sets the tone showing how performance is an aggregate typically of nine-steps from execution of code on the client side, through middleware, to server, and back again to the client. Learn how PL/SQL works from two of the best whose shared stories of actual issues underline the importance of performance planning and thinking.
Oracle database professionals rely upon PL/SQL to accomplish many important tasks. This book presents numerous opportunities to improve PL/SQL performance offering more than just code suggestions. Perhaps most importantly, each unit steps the reader through how to test and prove if an actual improvement has been made. Code examples include explanations of how to test results so that you know the impact of your actions. For each topic highlighted, the authors provide discussions of the tradeoffs being made; for instance, did CPU improve at the expense of I/O or vice-versa? Performance-related Oracle tools and instrumentation are explained and demonstrated clearly to illustrate and confirm results.
You can read this book straight through as I did, or, pick a specific topic like caching and skip around. However you choose to read this book you’re sure to learn lots about PL/SQL performance and how you can improve your systems.
When you see that error upon trying to install or upgrade something on your Windows 7 64-bit machine, chances are that it is caused by a Windows Security update that you need to uninstall. There is probably no point in messing around with the registry or the application that you want to upgrade. Instead, remove the Windows update KB2918614 like this:
Open the control panel, then click Windows Update
I’m using a corporate notebook with automatic Windows security updates coming from time to time and encountered that problem while trying to upgrade VirtualBox to version 4.3.12. It is not a VirtualBox issue, though, other installs or upgrades may fail for the same reason. For me, this was a serious problem, because I rely on virtual machines for many demonstrations. Kudos to the virtualbox.org forums! They helped me resolve that problem within a day. Thank you once again, guys! :-)
This is a quick blog post to help folks that are testing with SLOB at high user (session) counts. The situation may arise where you are testing SLOB on a large configuration, with or without SQL*Net, and the SLOB driver (runit.sh) is failing to produce Automatic Workload Repository (a.k.a AWR) reports.
This problem will generally be seen on RHEL 6 variants that implement the much maligned /etc/security/limits.d/90-nproc.conf method of preventing fork bombs. For more information on this configuration file please refer to Red Hat bug 919793.
If you are not getting AWR reports under the condition I describe then the problem is most likely due to 90-nproc.conf short circuiting the ulimit(3) tuning you’ve established.
As an example remedy, please consider the following settings I recommended to my colleagues at VCE for performance testing of the vBlock Specialized System for High Performance Databases:
Filed under: oracle
As scientists, interested in what’s happening in platform technology, readers of my blog will find my colleague Itzik Reich’s recent blog on EMC XtremIO to be very informative. Enjoy!
Originally posted on Itzikr's Blog:
during the week of VMworld 2014, we had the pleasure of presenting in front of the audience of the tech field day delegates.
attached below are the links to the session Josh Goldstein delivered, enjoy!
Filed under: oracle
Thanks to everyone who attended my August 27th webinar entitled In Search of Plan Stability - Part 1. You can download the presentation materials from these links:
I'll update this post to provide a link to the recording shortly.
Come back in November for Part 2. Hope to see you then!