I’m one of those types that always needs a project. If I run out of projects using the things I know, I take on a project that involves something I don’t know whatsoever. For instance, building a filesystem in C that connects to Oracle and uses queries in order to
Category: Oracle
Oracle is my focus profession and the big kahuna among transactional databases on the market today. This category features in-depth technical posts regarding Oracle, musings, projects, and Oracle related news.
Hey Guys, Does Size Matter?
Last night I was called in on an unfortunate problem. A client has an update that they must run (unfortunately) which updates ~830,000 rows, setting one column equal to the other (two column table). On their development environment this was taking roughly twenty seconds to perform. However, on their soon-to-be
Undone by Undo
It has been quite a long time since I posted here. However, all I can say is that I’ve been very busy, and I’m happy that work is so plentiful that I barely have time for blogging! Yesterday I got a call from a client that was having some trouble.
Easy Stored Procedure Output
I answered a question on a DBA Forum today and I thought it was a common enough question to warrant a blog posting. Question: I am new to the wonderful world of Oracle. I want to be able to view the results of a stored procedure in an output window,
When errors tell you absolutely nothing!
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.