Search

OakieTags

Who's online

There are currently 0 users and 35 guests online.

Recent comments

Affiliations

August 2010

The Girl with the Dragon Tattoo…

A few friends mentioned “The Girl with the Dragon Tattoo“, but the title screamed Chick Lit to me so I avoided reading it until now. Well, it just goes to show you shouldn’t judge a book by the cover/title.

It’s a down-and-dirty detective story with some rather grim elements, but it’s really engrossing and a proper page turner. Considering my usual trauma when moving between authors, I took to this effortlessly. Maybe I’ve finally learned to read… :)

Cheers

Tim…

APPEND_VALUES Hint…

The APPEND_VALUES hint is new to 11gR2 and allows you to use direct-path inserts from “INSERT INTO … VALUES” type statements. Pretty neat if you are doing inserts in a FORALL statement and need the extra punch.

Cheers

Tim…

What’s Really Happening at OpenWorld 2010? Part II.

The OOW folks informed me that they needed to move our session to a larger room. So, if you are interested here are the new details: ID#: S315110 Title: Optimizing Servers for Oracle Database Performance Track: Database Date: 20-SEP-10 Time: 17:00 – 18:00 Venue: Moscone South Room: Rm 302

Predictive Analytics in Oracle

Predictive Analytics in Oracle

Whaddya mean, predictive analytics in Oracle?

Yes, you heard me correctly. Oracle has built-in technology that enables end-users and applications to perform advanced analytics without extracting data from the database. This functionality is sold as an option to the Enterprise Edition of the Oracle database - the Oracle Data Mining option. This post is the first of a series of posts that will describe Oracle's predictive analytics offering.

Notes on Applying Exadata Bundle Patch (BP5)

Randy Johnson has done a brief post after applying BP5 on our Exadata Lab machine. Looks like it went pretty smoothly with the exception of a problem with DBFS and some misleading comments in the README file regarding using the RDS protocol (both of which we had in play). Here’s a link to his post:

Exadata Bundle Patch 5 Gotcha’s

DMCA

Some readers have noticed that a few links to my blog seem to be broken. Don’t panic, it’s not permanent it’s just the result of Don Burleson losing his temper.

Let me start by telling you about DMCA, the “Digital Millenium Copyright Act”. DMCA is a mechanism designed to protect Internet service providers (ISPs) from being sued over content published by their customers by allowing them to act as a communication channel and staying out of the line of fire.

The protocol is simple:

  • Person B decides that Person A has copied material for which person B holds the copyright.
  • Person B emails A’s ISP with a message swearing that he (or she) really, truly, believes there is a case for breach of copyright, supplying a link to the original source and (in principle) exact details of the copied material.
  • The ISP takes down the offending article and informs person A of the “DMCA take-down notice”.
  • At this point person A simply has to send an email to the ISP swearing that the article really, truly, doesn’t breach person B’s copyright.
  • The ISP restores the article and sends the DMCA counter-claim to Person B
  • At this point the ISP is in the clear and it’s up to Person B to pursue the copyright claim against Person A in court.

The protocol is necessary because (in general) you wouldn’t want your ISP to be be shut down or bankrupted because of the actions of a single individual who was abusing the services. On the downside, the protocol does enable individuals to make nuisances of themselves – particularly in an arena which should be open to technical discussion and peer review.

Database Deathmatch: Oracle vs. SQL Server

Recently I presented my new live demo pitting Oracle against SQL server under full load enduring a series of catastrophic ordeals.  These are my slides.  I will present it again at the Michigan Oak Table Symposium and Oracle Closed World in September. -Jeremiah

What’s Really Happening at OpenWorld 2010?

This is a quick blog entry to share a few of my plans for OOW. I’ll be co-presenter with a Wallis Pereira, Sr. Technical Program Manager in the Mission Critical Segment of Intel’s Data Center Group. Wally is a very old friend of mine and we’ll be delivering the following session. ID#: S315110 Title: Optimizing [...]

Common XQuery mistakes…applied in XML DB

Do you read FAQ…?

Somehow I keep people reminding there is a FAQ URL on the XMLDB forum and even then people refuse to read those good examples… Anyway found two great posts I want to share and remember on this, my, web “notepad”. Besides the treewalker example, I tested the examples of those mentioned in the XQuery post on a Oracle 11.2 database.

As far as I could find the treewalker example is part of DOM V2 and not mandatory to implement but I wonder how I can get around the local() stuff, anyway, I will have to investigate a bit further if its just me being a novice in XQuery or that I am missing out on details/info. The XQuery post only demonstrates to me how powerful this extra query language is in an Oracle database and that it is time for me to learn this properly…

The posts that I was referring to:

…be aware of the use of the (double quote instead single quote), namespaces (indeed apparently always an issue) and using (::) in SQL*Plus… The (::) is needed in SQL*Plus to mark that the “;”  is not seen as direct processing instruction for SQL*Plus, but in this case, is for the XQuery engine.

The headlines follow the ones in the XQuery post…