Managing free space in a tablespace seems to be an easy task, what with the views DBA_DATA_FILES, DBA_TEMP_FILES and DBA_FREE_SPACE avaliable. Those views can provide accurate information for datafiles not set to autoextend, however for autoextensible datafiles they can paint a bleaker picture because they’re based on the current size of the file, not the autoextend limit that file could reach. Let’s look at how those views, without taking autoextend into consideration, can report a (more...)
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...)