Browsing: XML

AMIS
3 Oracle 11g – First Impressions

The official launch is at hand. In less then 3 weeks Oracle 11g will be presented at the world during a, probably, great launch event in New York. AMIS entered the beta test program in August 2006. It was the first time we participated in beta testing and I think, we are honored and lucky to share now our thoughts and we were allowed to test the software in advance. So living towards the event, lets share some first impressions I got during those first encounters with the new database software.

When I installed for the first time the beta software, it was like unwrapping a new present. I like presents (who doesn’t). AMIS will do a lot unwrapping, after the 11g launch, but let’s tell you what my first impressions were (based, for now, on the current Windows version, to make it more visual). Be aware, the following is based on a beta release and a lot can still change or repackaged, when officially launched and delivered at your doorstep.

The new and the old
After installation of the Oracle Database Windows software, some small items are immediately noticeable.

AMIS
4 OOW2K6 – and Mr. Kyte has left the building…

Tuesday – Getting into the spirit

I am just joking, so far I haven’t seen an Elvis look-a-like in town, but I would be very interested how Thomas Kyte felt about his session this morning for this huge audience.

But I will start with the beginning. I started off this Tuesday morning in the Hilton Hotel, with Thomas Kyte’s presentation “Things you think you know”. I hadn’t really planned this session, but I am glad, I am really glad I did. Mr. Kyte is a very gifted speaker and knows what he speaking of, which helps ;-). Despite the fact that I had sometimes the feeling: “OK, what’s the big deal. It should be all common knowledge or at least, if you use your common sense, it shouldn’t be a new topic to you”. The brilliant metaphors he used, where priceless, funny and with al lot of wit addressed to the audience, so if that didn’t trigger them to think next time, then I don’t know how you should do it better…

AMIS
0 OOW2K6 – Newbie impressions…

It’s amazing how much Lucas already put to “paper”, despite all the mishaps we already encountered. The last two days I lost track on Lucas because he has completely different interests / agenda, and of course he also has to prepare for his sessions as a speaker.

Anyway here’s my input to all the great posts on the web already done (have a look at http://www.orablogs.com for most of them). As pointed out a time ago, my main interest is XML DB. Beside those sessions, I will also pinpoint some on performance, Oracle Content Directory and Open Source speeches, like those on Linux and PHP (future directions). These are old interests with whom I try to keep up, but can’t spend so much time on as in the past, because XML DB forces me to read and learn about stuff I put aside me a long time ago, or in other words neglected, for instance object (orientated) relational objects.

As a newbie (so I am fitting the profile) on this conference, I already missed apparently some important keynotes, but reading the posts of others today, I also realized that this makes my life a little bit easier, because it is now out in the open and I can address them, to a certain point, by name (11g).

See the following:
http://www.internetnews.com/ent-news/article.php/3639621
http://www.rittman.net/2006/10/23/oracle-open-world-days-12-database-roadmaps/

I will try to make my impressions, as a newbie, a little bit more colorful (pictures!), because I really enjoyed the posts made by my colleague Alex, on one of the last ODTUG meetings in the States where he spoke and attended…

AMIS
3 Oracle Open World 2006 – Almost there…

It’s almost Friday, a day before our flight. Lucas and I will be off to San Francisco on Saturday morning. Lucas will give some lectures on OOW 2006; I will mostly be pinpointing on XML (DB). On the side, I will try to consume some great lectures on performance (Tom Kyte, Jonathan Lewis, among others), try to see a little from San Francisco and enjoy the OOW 2006 atmosphere. The temperature over there will be on average 24° Celsius with a lot of sunshine.

I have mixed feelings about the event…

DBA
0 Mastering XML DB – Unexpected side effect of updateXML

When trying to create anonymous data, I encountered an unexpected side effect of the updateXML statement while updating XML documents in an Oracle 10gR2 (10.2.0.1.0) EE database.

I got a small test environment in which a table (HGO010_DETAM) resides that contains approximately 500Mb of XML documents. The real production environment is much bigger, think in 100th of Gigabytes per table and an average of 512 Kb (up to 6 Mb) per document. The web application that makes use of this data is document driven so these documents were stored in an XMLType column based on CLOB storage. The table also contains an extra ID column that was added for reference purposes.

The table was created as follows:

1 3 4 5 6 7