Apr 26 2007
Here posted some of the images of the “Anjo Kolk – How the Middle Tier is Slowing Down Your Database” event, which 70 people attended at AMIS. Great posts of Lucas and Gerard about the event can be found here: SAN, SUN and SOA, better run and hide – Likes and dislikes of Anjo Kolk …
Apr 16 2007
This was once posted on a Oracle OTN XMLDB forum; and though I thought it was easy, it wasn’t at all. It took me some sweat and I learned more about XPath than I had done so far and the (in)possibilities of using XPath within an Oracle database… All in all it was a good …
Apr 15 2007
This article from Doug Burns gives an great insight of the possibilities and advantages a Development DBA could have during the life-cycle of a development process. Lot’s of time the function of a DDBA is not even implemented during this process with all the problems and drawbacks that will have regarding the success of a …
Apr 08 2007
AMIS is proud to announce their AMIS Query (free technical seminar), targeted at Oracle Database Architects and Database Administrators. How the Middle Tier is Slowing Down Your Database Multi tier systems are very common today. Most of these systems include a web server, an application server and a database. They also rely heavily on the …
Apr 08 2007
Based upon: http://forums.oracle.com/forums/thread.jspa?threadID=498374 SQL> SELECT * FROM v$version; BANNER —————————————————————- Oracle DATABASE 10g Enterprise Edition Release 10.2.0.3.0 – Prod PL/SQL Release 10.2.0.3.0 – Production CORE 10.2.0.3.0 Production TNS FOR 32-bit Windows: Version 10.2.0.3.0 – Production NLSRTL Version 10.2.0.3.0 – Production 5 ROWS selected. Related posts: HOWTO: Move a XMLType column (based on …
Apr 08 2007
The Mark Drake Method (first steps to success) BEGIN dbms_xmlschema.registerSchema (schemaURL => ‘http://www.gralike.com/marco/HistorieWW/WWBase.xsd’ ,schemaDoc => xdbURIType(’/public/HistorieWW/WWBase.xsd’).getClob() ,LOCAL => FALSE ,genTypes => TRUE ,genBean => FALSE ,genTables => TRUE ); END; / Related posts: Mastering XML DB – Unexpected side effect of updateXML HOWTO: Move a XMLType column (based on CLOB storage) to different tablespace HOWTO: …
Apr 08 2007
Just a simple script I want to keep for posterity. The foundations were laid by Mark Drake. — ——————————————————– — – Author : Mark Drake — Purpose : Compiling XML Schema — – Altered : Marco Gralike — Date : 09/02/2007 — Alteration : Different error handling — – — ——————————————————– SET echo ON …
Apr 07 2007
The following is a just one of my weird thinking patterns I want to write down here. Therefore this is one of my first “scratchpad” exercises. maybe more will follow. I hope it will help someone out there who is trying the same stuff… Timing is done to see what the performance is; Tablespace storage …
Recent Comments