Skip to content





Daily Archives Thursday, July 2008

certification blog

I just notice a new blog on blogs.oracle.com :
Oracle Certification Blog
This is probably the right place to ask questions or get news about certification.
Out of the many questions I may ask here are just a few I am preparing.
- When will the OCM upgrade for 9i OCM be available ?
- When will be the [...]

Posted 10 July 2008 † Laurent Schneider § Uncategorized ‡ Comments Off °

Oracle Database Doesn’t Use Hugepages Correctly. What’s Better, Reserved or Used?

Yes, that was a come-on title…so surprising, isn’t it?
I’ve received questions about HugePages_Rsvd a few times in the last few months. After googling for HugePages_Rsvd +Oracle and not seeing a whole lot, I thought I’d put out this quick blog entry.
Here I have a system with 600 hugepages reserved:
# cat /proc/meminfo | [...]

Posted 10 July 2008 † kevinclosson § Uncategorized ‡ Comments Off °

Christian Antognini’s new book: Troubleshooting Oracle Performance

I learned from a friend yesterday that Chris Antognini’s new book, Troubleshooting Oracle Performance, is available now. I just checked at Amazon, and the product is listed as temporarily out of stock. That’s good: it means people are buying them up.If…

Posted 10 July 2008 † Cary Millsap § Uncategorized ‡ Comments Off °

UKOUG DE SIG Update

I mentioned in a previous post I was speaking at the UKOUG DE SIG today. The talk itself went fine, but I had a bit of a scare before hand. I drove from work to the venue and managed to get lost, which is a little surprising as it was in Birmingham and I’ve lived [...]

Posted 10 July 2008 † Tim... § Uncategorized ‡ Comments Off °

OBIEE on the Apple iPhone

Chris Claterbos from Vlamis has picked up on the story that one of the first official iPhone apps is a front-end for Oracle BI Enterprise Edition. The App Store hasn’t gone live over here yet, but apparently one of the first applications you can download (and for free) is a viewer application for Oracle BI [...]

Posted 10 July 2008 † Mark Rittman § Uncategorized ‡ Comments Off °

Great Java Xpath Article

LewisC’s An Expert’s Guide To Oracle Technology

IBM Developerworks has posted a new article, Evaluating XPaths from the Java platform. This is a really detailed article for those of you doing XML from java. The little title blurb says:

No data format is harder to sea

Posted 10 July 2008 † An Expert's Guide to Oracle Technology § Uncategorized ‡ Comments Off °

First Oracle Related Application on the iPhone?

I was just browsing through the iTunes Application Store and noticed this application -

Hmm, I guess that really makes me a geek huh? I get to look at the iPhone apps and the first one I look for is an Oracle related one.
Of course, being an Application Express fan, I’ve been used to using an [...]

Posted 10 July 2008 † John Scott § Uncategorized ‡ Comments Off °

secondmax

How do I retrieve the second highest salary of emp?
There is no right or wrong treatment of duplicates, there are only buggy specifications…
There are plenty of ways to do this.
An Oracle 7 approach would be
SELECT MAX(SAL)
FROM EMP, (
  SELECT MAX(SAL) MAXSAL FROM EMP)
WHERE SAL<MAXSAL;

Using TOP-n queries I could use

SELECT SAL
FROM (
  SELECT [...]

Posted 10 July 2008 † Laurent Schneider § Uncategorized ‡ Comments Off °

You can’t buy a SAN (I feel a rant coming on)

Warning, rant follows…
I have a problem with referring to a storage array as a SAN as seems commonplace these days. SAN is Storage Area Network. Storage array <> SAN <> RAID <> LUN, but all are related. For clarification, storage arrays, which live in a SAN, typically provide access to LUNs that are often created [...]

Posted 10 July 2008 † Dan § Uncategorized ‡ Comments Off °

I Ain’t Not Too Purdie Smart, But I Know One Thing For Certain: MAA Literature is Required Reading!

You Need to See What These Folks Have to Say
It is hereby official! I absolutely must put out a plug for the MAA team and the fruits of their labor now that I have personally worked with them on a project. I’m sure it’s no credit to them, per se, but honestly, this team is [...]

Posted 10 July 2008 † kevinclosson § Uncategorized ‡ Comments Off °