Monthly Archive: June 2007

Jun 28 2007

Need a personal invitation?

You personal invitation from Mogens Nørgaard, for Miracle Open World 2007, can be found here…http://miracleas.dk/index.asp?page=167&page2=408 So if “you missed something“, maybe this, first schedule release, will help: http://miracleas.dk/images/upload/MOOW07/MOOW07_agenda.pdf (yeah, I’m in.) No related posts.

Jun 28 2007

Oracle 11g – SQL*Plus Command Line Options

Had a small typo and ended up with the command line options for Oracle 11g SQL*Plus. Always handy to know… Related posts: Oracle 11g – XMLType Storage Options APEX installation via the Oracle Protocol Server (listener) Friday afternoon – updating Oracle XE Back to the future (Oracle 4.1 VM appliance) Small introduction to SQL*Net debugging …

Continue reading »

Jun 26 2007

Oracle 11g – DBConsole

Posted new articles on DBConsole on the AMIS Technology site. DBConsole 11g (part 1) – An Introduction of the new Version DBConsole 11g (part 2) – Using the SQL Performance Analyzer DBConsole 11g (part 3) – Transparent Tablespace Encryption and Alerting Have a look… Related posts: My first impressions about Oracle 11g… Friday afternoon – …

Continue reading »

Jun 26 2007

Turn It On Again

I almost forgot, but an event that I waited for a long time, will happen at last in Holland, on the 1st of July: The Genesis – “Turn It On Again” Tour. Genesis will play in the Amsterdam Arena with probably the same set as rehearsed in Brussels. I am one of the lucky ones …

Continue reading »

Jun 24 2007

Oracle 11g – XMLType Storage Options

Though also a recap on presentations of Oracle Open World 2006, where I pinpointed on XML and XMLDB sessions, now it is time to go a little bit further into these great new features that will be available in Oracle 11g regarding XMLDB functionality. One of the big steps forward to full exploitation of these …

Continue reading »

Jun 23 2007

My first impressions about Oracle 11g…

You are now able to read-up on my first impressions about Oracle 11g on our cooperate technology AMIS blog: site called “Oracle 11g – First Impressions” Regards, Marco Related posts: OOW2K6 – Newbie impressions… Hmmm, I got digged ;-) Back to the future (Oracle 4.1 VM appliance) Friday afternoon – updating Oracle XE

Jun 21 2007

Advanced Oracle SQL Programming

I just got a small e-mail from Laurent Schneider. He started a bold quest in writing a book about SQL programming called “Advanced Oracle SQL Programming“. I had the pleasure to meet Laurent, up in person, during my visit to Oracle Open World in San Francisco (2006).

He has a brilliant mind and likes, amongst challenging Chinese people into a chess game, to juggle with SQL puzzles and problems, and can be very creative like the examples he demonstrated with the XMLDB functions and regular expressions (see here). Advanced Oracle SQL Programming - Laurent Schneider

Despite the fact that he admitted that it won’t have examples like those of my collegaes Anton (“Solving a Sudoku with 1 SQL-statement: the Model-clause”) or Lucas (“Pie Charts in SQL – how pathetic can you get?”), regarding Sudoku puzzles and pie charts, I can’t believe this book won’t be mandatory lecture for all of us who needs to program with (and want to excel in) SQL (…and all us mere mortals who want to catch up…)

The content is described as:

Jun 20 2007

Reclaim virtual redo disk space; VMware Converter 3.0.1

I got a small problem regarding a acceptance environment build on VMware Server (currently version 1.02) on Windows. This virtual environment with, amongst others a Oracle 10gR1 database on it, was once build with the older VMware GSX 3.21 software, but the supported (and paid for) VMware GSX version has become over time, the free down loadable VMware Server edition.

When I started, I though it would be useful to enable the snapshot function, so if a upgrade or patch process, for database, OS or application, went wrong I was able to reset the virtual machine to it’s starting point and try again… I noticed that after upgrading the software to VMware Server 1.01 and after a while to VMware Server 1.02, that I couldn’t disable the snapshot function anymore because this enable/disable feature was grayed out. The VMware disks had a lot of REDO files so I wanted to consolidate this space, because the SAN where the VMware virtual disks were residing had almost no disk space left.

Normally, if the VMware Tools are installed in a VMware machine, it is possible to shrink the disk space of the virtual disks, but this feature is only available if, amongst others, the snapshot feature is not enabled. In my case, apparently it was, but also I couldn’t disable it because the disable snapshot feature was grayed out and not clickable anymore…

So what now?

Jun 16 2007

VirtualBox 1.4.0

There is great virtual machine software out there, VMware, XEN, etc. VMware was one of the first I also dared to use for more serious environments, like for instance development environments. Triggered by my old friend Erwin Brinkhuis, he completely switched to Linux (in his case Ubuntu), I had a look at VirtualBox. This product …

Continue reading »

Jun 15 2007

“Applied Mathematics for Database Professionals” – Toon Koppelaars

On the oracle-l list of freelists.org, Toon Koppelaars announced that Lex‘ and his book project, now has finished and he also recieved his first copies via DHL. Knowing the effort and the involved people, Lex de Haan and Toon Koppelaars, I only can imagine that it is a great book (I wasn’t one of the …

Continue reading »

Older posts «