Monthly Archive: October 2007

Oct 24 2007

XMLIndex Performance and Fuzzy XPath Searches

Categories:

11gR1, 11gR2, Binary-, CLOB-, Object Relational Storage, General, RDBMS, XMLDB

XMLDB Hands-on Labs

Learned yesterday an important lesson on the Oracle OTN XMLDB forum. A question was asked why a count via a full table scan was quicker than the same example while using an XMLIndex. “XMLIndex performance regarding // (any descendant))”. The poster used the // xpath expression to do his search.

As in most cases nowadays it is important to keep your statistics in order. An XMLIndex is not an “index” as such, it is an logical index / domain index, specially designed for use with XMLDB / XML data.

Read more…

This post has no tag

2 comments

Oct 20 2007

RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach

Categories:

Books, Oracle

rman.gif

Ahhh, this is just a great book. In the last 1 1/2 months I was wrestling with the most stupid recovery scenario’s in a long time. Not because I didn’t set up all things properly, but because over time things changed and therefore recovery scenario’s set-up weren’t applicable anymore. If I had a book at …

Continue reading »

This post has no tag

Leave comment

Oct 19 2007

One day seminar with Toon Koppelaars, Amstelveen, The Netherlands

Categories:

Books, Events, General

Toon Koppelaars, Lex de Haan: Applied Mathematics for Database Professionals

Today I got an e-mail from Juliette Nuijten (Natural Join B.V.) alerting me that Toon Koppelaars will present on 29 November 2007, a mini seminar in Amstelveen Toon Koppelaars, Lex de Haan: Applied Mathematics for Database Professionals (The Netherlands), based on his and Lex de Haan‘s book: Applied Mathematics for Database Professionals.

Unlucky enough, I will not be able to attend and I am sure this will be an very interesting mini seminar.

This is not only because Toon is a very gifted and inspiring speaker, but also because the seminar will present a very useful practical methods and theories applicable to us relational practitioners. The content of this seminar, which can also be found on the website of Ivan Pellegrin (www.maestridellarte.com) that organized this event, will have the following sections:

Read more…

This post has no tag

4 comments

Oct 17 2007

Oracle has humor…

Categories:

General, Oracle, SQL, XML/SQL, XPath, XQuery

XMLDB Hands-on Labs

The following email content was send to me today, by my colleague Alex Nuijten (AMIS)…

PLS-00101: reserved for future use 

Cause: This error message is not used yet.(Heh, heh, that"s a joke, son.)
Action: none

Who says they don’t have humor at Oracle…

If you want to check it; Have a look here:

This post has no tag

1 comment

Oct 16 2007

Windows “SC” command – Handling Windows Services the Proper Way.

Categories:

General, Howto, RDBMS, SQL*Net, Protocol Server

XMLDB Hands-on Labs

Instead of always deleting whole registry keys to “clean up” Oracle software, there is also a normal statement on the command prompt to do this more effectively and in a more proper way. Only…I always forget what the statement was, so that’s why I post this now on this site…   C:\> ver   Microsoft …

Continue reading »

This post has no tag

8 comments

Oct 12 2007

Oracle and Bea (WebLogic)

Categories:

General, Oracle

XMLDB Hands-on Labs

As Justin mentions here, “Oracle Offers to Acquire BEA”. This really makes sense. As far as I know, the BEA WebLogic app server is the most loved one and probably implemented one regarding PeopleSoft implementations. I am only surprised that it took this long to make a shot at it. I would have expected this …

Continue reading »

This post has no tag

1 comment

Oct 12 2007

Going the Total Retro – Solving SQLPME V1.2.1 Problems with Oracle V5.1.17.4 on MSDOS

Categories:

Old Stuff, Oracle, RDBMS, Virtual Machines

SQLPME crash

Did it. At last I managed to install Oracle V5.1.17.4 on MSDOS 6.22 under VMware Server 1.04. You probably think I am nuts. As someone said on our way home from Miracle Open World: “I would spend my time learning Oracle 11g”. Maybe. The person who said it, by the way, is an Oracle trainer, so what would I expect…

I / we (Bert Jan Meinders, an old colleague of mine) did our first attempt almost 1, 1 1/2 years ago. Our first attempt was based on VMware GSX software after we succesfully installed Oracle 4.1 on MSDOS. This was the first time (and until now the last time) I saw a total crash of VMware software. Oracle V5 was shipped under DOS with a memory manager called SQLPME (SQL Protected Mode Executive) V1.2.1.

This memory manager made extended memory available for use of Oracle software (database, forms etc), this way it could cross the 640 Kb boundary of conventional memory.

SQLPME was aggressive enough with its peeking and poking in memory that it crashed the VMware GSX environment at the time. Under VMware Server 1.04 it just hung itself up / nothing happened.

SQLPME crash

Click on the image to enlarge

Read more…

This post has no tag

12 comments

Oct 08 2007

Miracle Oracle Open World 2007 Recap

Categories:

Events, General

logo256x256

The complete (almost complete) recap on my adventures can be found on the
AMIS Technology Blog site:

Have a look.

8-)

Marco


PS.: Other worthwhile reading about Miracle Oracle Open World 2007:

…read more…

This post has no tag

2 comments

Oct 03 2007

Miracle Benelux – Presenting Cary Millsap

Categories:

General, Oracle

The Story of Bob

I already heard some rumors about it during Miracle Open World. It looks like Cary Millsap will probably present for Miracle Benelux in January 2008. I know, this sounds like a lot of ifs, but it will be worthwhile if your in the neighborhood.

So keep your eyes open for announcements on the Miracle Benelux website during the following months.

The Story of Bob

 

Your chance to hear the stories about: “The Story of Bob, Bob’s Boy, and the Bicycle that became a Ferrari” and “How (not) to blow up a box turtle”. Presentations of Cary Millsap are worthwhile, especially if you had never the chance to attend one.

8-)

This post has no tag

Leave comment