Month: September 2009
September 14

AMIS Query – Technical Introduction of Oracle Database 11g Release 2

(dutch text)

Oracle heeft zijn nieuwe database release – 11g Release 2 – begin deze maand vrijgegeven. AMIS heeft als deelnemer aan het beta-traject al geruime tijd met deze release kennis kunnen maken. We organiseren op dinsdag 29 september een AMIS Query sessie waarin we van deze eerste ervaringen verslag doen. Niet zozeer in marketing-kreten maar vooral in echte praktijk-voordelen.

Onze Expertise Manager voor Database & Middleware Gerwin Hendriksen en Oracle ACEs Marco Gralike en Lucas Jellema presenteren en demonstreren hun ervaringen, inzichten en eerste aanbevelingen rond deze nieuwe release.

We openen met een kort overzicht van de ‘elevator pitch’ voor 11gR2 – wat houdt ‘Consolidate, Compress, Control’ in (dat is de marketing-slagzin voor 11gR2), wat is de essentie van deze nieuwe release.

Read the postAMIS Query – Technical Introduction of Oracle Database 11g Release 2
September 10

Oracle 11g Release 2 – New Features Blog Posts

September 9

Oracle 11gR2 – XML Data Partitioning

There is a Metalink note (563802.1) that has a very good example how XML data storage, partitioning can be achieved in Oracle version 9.2.0.3.0 (the first officially supported XMLDB database functionality) and onwards. Partitioning can be used in such XML situations to spread the I/O load and it also supports, if done correctly, the XMLDB functionality / Oracle database, to use query re-writes during XPath or XQuery statements. See for more information about Query Rewrite support the Oracle XMLDB Developers Guide.

The “new” equi-partitioning functionality, supported from 11.1.0.7.0, but now described in more detail in the 11gR2 XMLDB Developers Manual, also propagates / partitions all underlying structures. As described in the Metalink note:

“In Oracle release 11g the partitioning model is equi-partitioning which means that the underlying storage tables are partitioned too along with the default table partitioning structure. In previous releases only the default table is partitioned, but the underlying storage tables for the types are not.”

So explained in more detail, before 11.1.0.7.0 only the “xdb:defaultTable”, in the following example table “TESTELEMENT”, is partitioned by range. In Oracle 11.1.0.7.0 and onwards also all referred XML structures underneath this entry point are equally partitioned based on this defined range.

Read the postOracle 11gR2 – XML Data Partitioning