Prepare your database for the apocalypse with these 10 easy tips.
What happens when you update the crontab on a critical system to accommodate year-end processing? What happens when, despite all your diligence and devotion to human reliability guidelines, you perform a simple slip, and instead of typing crontab -e, you type crontab -r? Well, the documentation tells you what happens:
Pythian’s friendly Oracle e-Business Suite DBAs would like to congratulate all of our friends, clients, Pythian colleagues, prospects, new team members whom we haven’t yet met (join us!), all database geeks, and blog readers for successfully completing 2012! Have a very peaceful Christmas and the happiest year ever in 2013! May all of your pagers be quiet, and your year-end maintenance be incident-free! ;) Here comes our Christmas card to you :)
Screenings, shows, premieres and parties. Where the stars have been spotted this week? No not on the red carpet in LA, but in this Log Buffer Edition. In Log Buffer #299, stars of Oracle, SQL Server and MySQL are twinkling. Get mesmerized!!!
A client recently supplied a list of 50+ SQL IDs that should receive SQL profiles, and I’ve been working with Gwen Shapira to review the list. Further discussion showed that this list had come from the Automatic SQL Tuning feature, installed by default in Oracle 11g. The report includes a list of recommended SQL profiles ordered by “Maximum Benefit”, and in our case it included several hundred statements. The expected workflow, as far as I can gather, is to see the recommendations, look at the before- and after- execution plans, and accept the recommendations. Before blindly accepting recommendations, though, I like to see what exact changes are being proposed. They aren’t listed anywhere in the report, and require some extra work to uncover. The first step is to get the automatic SQL tuning advisor report. (
All the submissions from Pythian tree decorating teams are in! the team names are anonymous until the votes are in.
This is just a small bug fix release of the plugin. It was actually quietly released for a while now of if you have downloaded the plugin recently, you have the latest version. To be sure — check the version in the Console or you will see it in the file name.
Inspired by the benchmark in this post, we decided to run some NDB vs Galera benchmarks for ourselves. We confirmed that NDB does not perform well using m1.large instances. In fact, it’s totally unacceptable – no setup should ever have a minimum latency of 220ms – so m1.large instances are not an option. Apparently the…
Recently a client of ours who used opsview to manage their resources needed to place some of their hosts into downtime in conjunction with some other cron-scheduled tasks. In order to implement that functionality, I created this simple script that should work with most installations of opsview, or with a few modifications, can be modified…
Not many of you know that my day to day work focus is Oracle e-Business Suite :). Here goes EBS related blog post …Recently several of my team’s clients upgraded to R12.1.3 version and faced the same problem related to OACORE memory settings.