The task was simple… Oh yes, hello by the way. It has been a while since I’ve posted! Anyways, like I said, the task was simple. Migrate an Oracle 10.1.0.3 32-bit database on one server to 10.2.0.3 64-bit on another server, and do it with only 1 hour of downtime.
The Oracle 11g Result Cache
I just wanted to take a minute to point any of my readers (hears crickets chirping) to a great article on the DBA-Oracle site regarding the Oracle 11g Result Cache. Take the time to have a read, it’s filled with great information, comparisons, and commentary. As always, make sure to
Say Goodbye to LIKE, and Hello to Oracle Text
Don Burleson recently posted a great article on using Oracle Text indexes to make up for the horrible performance issues caused by ‘%LIKE%’ queries on large blocks of text. I have personally been enjoying keyword searching CONTEXT indexes for quite some time through its various incarnations as the Context Option,
Log Buffer #60: a Carnival of the Vanities for DBAs
It has been a long time since I have posted on here (work and all, sorry about that), and so when I was asked to do another Log Buffer, it sounded like a great way to get back into the swing of things. Not to say work is light; on
Oracle Parameters You’d Love to See
Have you ever just WISHED that a parameter existed in Oracle? I know I have, and old coworkers of mine have long joked about the need for things like the “fix_database.sh” script. So I ask you, what parameters would you just LOVE to see show up by Oracle 20rr (Really
SCD: Slowly Changing Dimensions or Schroedinger’s Cat Dilemma?
In the world of theoretical physics there is a theoretical cat owned by Erwin Schroedinger. This famously fickle feline posed a problem: he could not decide if he was alive or dead. In the Schroedinger’s Cat thought experiment, a living cat is placed in a box with a nefarious device.
Socket Based Licensing for Standard Edition
I ran across this article today on Oracle’s new strategy for Standard Edition and Standard Edition One licensing. As a consultant, there are times when I have to tackle licensing questions, though I usually try to stay away from it and let Oracle’s salespeople do that job. However, I found
Patching from 10.2.0.1 to 10.2.0.3
I’m not a big fan of ignoring errors with OUI (we all have our horror stories), and so when I ran across this one I was loathe to ignore or cancel: Error in invoking target ‘all_no_orcl ipc_g’ of makefile Now, an experienced Oracle installer/patcher/troubleshooter/slave knows full well that most of
The Shining – Feel Good Movie of the Year
If you’ve ever seen the movie The Shining, you have to see this trailer! The story, so I hear, is that a film student did this for a contest called Trailer Park. The goal is to take a movie and create a trailer for that movie that makes it seem
It’s been a while!
Hello everyone…I know I haven’t posted in quite a while, and I’m not about to start now. Things have been extremely busy lately, starting with my 10g RAC course aboard the Carnival Glory on a 7-day Caribbean cruise (more on that later). So I will be posting again soon, and