I’m not entirely sure why I liked the hockey puck so much.
It’s a beautiful little piece of technology, absolutely. Some users report that it pays for itself in energy savings rather quickly, sweet. It (more...)
In yet another Oracle forum (yes, I’m in a number of them) the following question was posed:
I'm reading oracle 9i sql and there is an example of a subquery which I'm trying to write as a group by query. select empno, ename, sal from emp where sal = (select min(sal) from emp); This works but I don't understand why I can't write this as a group by expression select empno, ename, min(sal) from emp (more...)
In a forum I frequent a question was raised regarding an index not being used. The poster is using Oracle 184.108.40.206, which limits the index access paths Oracle can use; a concatenated index is created on the table (which has columns x,y,z,t,q and w, for lack of better names) on columns x, y, and z. Let’s look at what 220.127.116.11 will do with such a situation then explain what (more...)
I’ve been trying to install open source software. In this case an application called Moodle. I followed the instructions to install it on an Ubuntu Server vm but they were missing a couple of key points.
After installing the Moodle package (under “Moodle Installation” in the instructions) you need to (more...)
Lots of news coming out of Applications UX lately, so thought I’d share it here.
Over at Misha’s (@mishavaughan) Voice of User Experience blog, you can read about Simplified UI for Oracle Human Capital Management Cloud and Simplified UI for Oracle Sales Cloud. Both versions went live in (more...)
I’m cleaning up all the open tabs for the holidays, so here are some nuggets I found that may or may not be interesting.
Hinkmond Wong of the Java Embedded Technology team did a fun Thanksgiving project, a Turkey that tweets as it cooks.
It’s time for (more...)
A while back, I promised some details on the Google Now TV Card I found accidentally.
I was watching TV via an HDTV antenna and happened to pop open Google Now for some reason or another. Now showed me this card:
Freaky, right? I dismissed it, but my curiosity was (more...)
Compression is often mentioned in reverent tones as the cure for database space problems, and properly used it can be just that. However simply throwning compression at a table without careful consideration of what can be accomplished or what behavior to expect afterwards can leave you scratching your head in (more...)
Q: How do I do an Oracle database health-check?
A: It all depends. (hint: we can use this answer for most Oracle related questions in general and Performance related in particular, but don’t try it at home).
This seems like a quite broad question and yes it is. And of (more...)