Posts Categorized: Technical Blog
I attended a great presentation at UKOUG 2011, “Oracle E-business Suite’s use of edition-based redefinition for online patching,” delivered by Bryn Llewellyn from Oracle. The presentation provided thorough insight on how EBR works and how E-Business Suite will be able to use it for online patching. It answered many questions, but raised a few more questions and concerns. I’ll try to summarize in this post the main concerns I’ve been thinking about after attending this presentation.
Hot on the heels of 22.214.171.124 coming out for Exadata, there’s yet another Exadata patch schedule out: the Quarterly Database Patch for Exadata (QDPE). They’re designed to being some of the predictability of Oracle’s quarterly critical patch updates (CPU) to the Exadata world.
DuckFeet’s guts are SQLicious, and built as DBIx::Class classes, sprinkled with wonderfully tooth-decaying DBIx::Class::Candy on top. In the repo, it’s all under the DuckFeet::Schema namespace. For the time being, there is only a handful of tables (hits, uris, referers, agents and hosts), but it should be easily extendable to add any type of information we might desire to throw in, but it should be easily extendable to add any type of information we might desire to throw in.
Since Oracle 126.96.36.199 came out last September, there have been questions about Exadata availability. As of today, the patchset is now available.
Reviewing the upgrade document (MOS note 1373255.1) a few things that jumped out at me, here they are.
In this post I quickly cover the new features in SQL Server RC0 setup.
How much memory does my Oracle instance use? How much memory do my database connections use? These are questions that can help with capacity planning of your server’s Physical and Virtual memory. There are several write ups out there on the web that attempt to address these questions. From what I could gather from them, there is only one truly good way to tell exactly how much memory is currently in use by an oracle instance, as well as the average memory usage for oracle dedicated connection processes. I explain it here.
In this post I’ll Briefly cover the changes to SQL Server licencing which happened in two areas, edition changes and licensing changes. Lets get started.
I had to refresh my knowledge on how InnoDB threads queue works the other day when debugging activity spikes on one of the customer’s production system and while I had general idea about InnoDB kernel and queue, thread concurrency and queue join delays I didn’t have a complete model of how InnoDB concurrency control works. So I started from manual…
This year, there were ten Pythian folks attending UKOUG Conference and we did twelve sessions including multiple presentations, masterclass, RAC Attack workshop, round-table and 10 minutes OakTalk. I think it’s the record number of session Pythian folks did at a single UKOUG conference and the record number of Pythian peeps attending. A dozen of Pythian people in Europe and now even a sales guy in the UK mean that Pythian penetration in the UK database services business is close to the infliction point. This is ultimately a good news!
Somebody at $work asked me how I use Git to deploy stuff, probably working under the false hypothesis that wisdom is in any way, shape or form affiliated with yours truly. The fool…Yet, it is true that I had my share of tinkering with Git, and that I might have gleaned from my experience. So I sent him a couple of links leading to more wisdom-certified sources. They are listed at the end of this blog entry; if you have more good articles/blog posts that you’d like to add to the pile, please don’t be shy and mention them in the comments. But I can’t just stop there, really. So, if you allow me, I’ll dust off the good ol’ soap-box, hop on it, and share my thoughts on the subject.