Oracle XMLDB Repository Events, IMHO, was one of the coolest functionalities introduced in Oracle 11.1. In principal they are a kind of event “triggers” that get fired during actions / methods on objects in the XDB Repository. One of the disadvantages of this functionality is that they are very “sparsely” documented in the Oracle XMLDB …
Monthly Archive: November 2011
Nov 21 2011
HOWTO: Implement Versioning via Oracle XMLDB
Since a long time, the database has had some versioning capabilities, long before features like “Edition Based Redefinition” in Oracle 11gR2 appeared. This versioning, via XMLDB functionality, is based on its XDB Repository access to the database. The XDB Repository is a file/folder metaphor that acts as a file server. You can enable this functionality …
Nov 21 2011
UKOUG 2011: Using your Database as a Fileserver
One of the coolest things in Oracle 11g and onwards is a functionality called XDB Repository Events. Most of you probably know that based on XMLDB functionality in the database, the database also can be used in a File server kind of way by enabling the XDB Repository HTTP/FTP or WebDAV functionality via DBMS_XDB. XDB …
Nov 21 2011
HOWTO: Consume Anydata via XMLType (and back)
This was a small mind exercise on the OakTable website (OakTable Challenge)for a person regarding how to go from a relational table to anydata datatype table and back, which I, of course, approached via an “XMLType” of way thinking. Probably the whole thing is not that practical and/or can be optimized in various ways, but …
Nov 10 2011
Review: The Method-R Profiler
I was lucky enough to get my hands on the Method-R Profiler and had a test drive with it. So first of all what is it? As you might expect a profiler, a profiler for Oracle performance problems. The tool makes use of Oracle’s trace facilities. If you have a performance problem with the database …
Posted on:
November 5, 2011
Nov 05 2011
Oracle XMLDB Sample Code
This week Mark Drake, Senior Product Manager Oracle XMLDB, put up a new page on Oracle OTN with some great code examples and utilities demonstrating Oracle XMLDB functionality. Among others, the latest code for Mark’s XFILES XMLDB demo application version 5, Introduction to Oracle XML DB Repository Events, Basic Introduction to Oracle XML DB 11.2.0.3.0, …
Nov 05 2011
Site Update
Updated this site to the latest “stuff” including a new stats plugin for WordPress, called kstats, just to see if this will work for me. I noticed already a small strange issue that is manifests itself in the main title of the page. Only in internet explorer it shows incorrectly, but all the others browsers …

Recent Comments