DBA 2.0 – how options are really not optional or: "the infinite database"
After Web 2.0, Enterprise 2.0 and Wife 2.0, Oracle introduces the term DBA 2.0. It seems to refer to the DBA of the very near future. The one who …
Category: Database
OOW 2008: The Database – really BIG announcement (industry shocking …)
All the tell tale signs are there: nervous Oracle staff – looking around them to check out whether no one can read their minds, some intriguing but very unspecific …
Analyzing Match Scores in ‘fuzzy searches’ – explaining the shades of gray in a non-binary world
In a previous article – Not all has to be black and white in SQL Queries – , I discuss how not all searches are about perfect matches. The …
An evening with Oracle Coherence and Oracle Data Integrator – on Compute Grids, JMS implementations and trickle feed
The other night I had an interesting dinner date: seated around me were an Oracle ACE Director (Mark) and two Oracle employees, experts on Oracle Coherence (Ewan) and Oracle …
Recovering Very Large Databases in the Least Amount of Time
Sometimes you come across beautiful things in your life, you wish you had known before, because they were there all the time, waiting for that moment to be discovered …
Remote printing to Windows printservers from Solaris
Recently I found myself in the situation that we had gotten an incident about some application that couldn’t print anymore to the printers it was printing before. This was …
Database upgrade apex.oracle.com
Oracle has upgraded the apex.oracle.com service. Now you can use this free service to evaluate Oracle Application Express and (some of) the new PL/SQL and SQL features of the Oracle …
Closing the Gapp on Oracle Open World?
I don’t know about you, but while I try to make an interesting Oracle Open World schedule for me this year, I noticed that this is not an very …
Referential Integrity with Virtual Columns, the Sequel
![Referential Integrity with Virtual Columns, the Sequel]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Referential Integrity with Virtual Columns, the Sequel")
The comments on the blogpost on Referential Integrity with Virtual Columns lead to this entry. As a recap: In the above mentioned blog post I showed how you can …
Oracle & JDBC – Passing a ‘table of custom object type’ to a stored procedure – implementing efficient single round trip data exchange (part two of an ADF application on a PL/SQL API)
July 16, 2008
Database, Databases, IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
3 Comments
One very efficient way of passing data from the Java application to the database is through the use of custom Oracle Types. Even when we want to send a …
Creating an ADF application based on PL/SQL API – part one: reading data as a Collection of SQL Type Objects
July 15, 2008
Database, Databases, IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
3 Comments
In this article something you may never do in exactly this way. Yet something that may become increasingly more useful, as our databases will have ever more Data Service …
Referential Integrity with Virtual Columns
During ODTUG, a couple of weeks ago, Tom Kyte did a presentation on the “Top 10 11 things about Oracle 11gR1″. The presentation can be downloaded from asktom.oracle.com. He …
Juggling with SQL Types in SQL and PL/SQL – fading borders between Collection and Table
While preparing for a whole different topic, I had to create a few demonstrations of using custom SQL Types and Collections in both SQL and PL/SQL. While nothing spectacular …
Instrumentation
During the ODTUG conference in New Orleans, there were multiple sessions for the Development/DBA. As I consider myself a developer with a great interest in the database, I love …
PL/SQL Table-to-Java Bean (and Data to Java Bean Manager) generator – useful for data driven demos without database
June 26, 2008
Database, IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
6 Comments
The other day, I sat preparing for a demonstration of a data driven Java Web application. I preferred to be able to present the demo without actually having to …
OEM GC 10.2.0.4 Upgrade Connect Issues
Here a small post that hopefully will help some people in the future that are stuck with the same issues. I am still missing some info, but I discovered …
Integrating Flashback in ADF Web Applications – providing the historic perspective
June 20, 2008
Database, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL
No Comments
When we were doing the APEX vs. ADF session at the last day of the ODTUG Conference yesterday, Dimitri showed a nice feature in APEX that allows you to …
Rapid PL/SQL Web Service Client development (using soapUI and utl_http)
I have written about similar topics on several occasions. But now I feel an urgent need to do so again. As with the use of the wonderful soapUI tool …
Father’s day at ODTUG Kaleidoscope 2008
Together with Aino Andriessen, Alex Nuijten, Lucas Jellema I travelled to New Orleans to attend the ODTUG Kaleidoscope Conference 2008. Today, the ODTUG is starting full speed, no time …
Installing Oracle E-Business Suite 11.5.10.2 on Oracle Enterprise Linux 5 update 1
Oracle recently announced certification for E-Business Suite 11i on Oracle Enterprise Linux 5 So, today I gave it a try, together with a colleague. The requirements for installing …
Accepted AMIS Oracle Open World Presentations
June 5, 2008
AMIS, Databases, DBA Oracle, IT, Java, Oracle, Oracle Application Development Framework, Software Engineering, XML
3 Comments
Today me colleagues Lucas, Gerwin and I got some nice “Oracle Open World Welcome Notification” e-mails from the Oracle Open World 2008 team. We are happy to announce that …
Testing Rulegen using Codetester
When I was presented with the possibilities of Rulegen it made me wonder: How can these rules be tested. Rulegen is a tool to create rules in the database …
Oracle DBA Symposium organized by Planboard
Last Tuesday (27th of May) I was present at the Oracle DBA Symposium as a presenter and attendee. The DBA Symposium was organized by Planboard. After all attendees and …
Report from JavaOne 2008 – download session resources
May 30, 2008
AMIS, Databases, IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools, Web HTML5 CSS3, Web/Java
1 Comment
Thursday 29th May – some 70 Java specialists gathered to discuss the main themes and findings from the 2008 JavaOne conference. Peter, Wouter and Lucas presented on their experiences …
E-Business Suite 11i Certified on OEL5, RHEL5 and SLES10
With the end of full support for RedHat’s Enterpris Linux 4 as of May 15 (2008), Oracle was just in time announcing support for Enterprise Linux 5 (both Oracle’s …
DBA Conference Holland & XMLDB Whitepaper
Given by Dutch DBA’s for DBA’s: The DBA Conference in Holland next week, the 27th of May 2008, Zeist. Oracle DBA Symposium Yours truly will also present as you …
Triggers…
I ran into an issue at a customer site where certain triggers were disabled in the database where they should be enabled. It appeared that an update script, that …
Collaborate 08 – Day 4 – The Final Day
April 18, 2008
AMIS, Architecture, Database, DBA Oracle, IT, Oracle, Oracle E-Business Suite
4 Comments
Being the last day of the conference there was a shorter program, only until early afternoon. I must say, this has been a very valuable conference for me. I …
Collaborate 08 – Day 3
April 17, 2008
Architecture, Database, DBA Oracle, Oracle E-Business Suite, SOA, Software Development
3 Comments
I am supposed to be at a party tonight, but I am too exhausted, to be honest to go out and my head is too full with all kinds …
Collaborate 08 – Day 2
April 16, 2008
Architecture, DBA Oracle, Development Tools, Oracle E-Business Suite, SOA, Software Development
3 Comments
This was my second day of Collaborate 08. I attended 3 sessions today: Oracle Unbreakable Linux and Oracle VM – by Monica Kumar, Oracle Building E-Business Suite Interfaces …
Collaborate 08 – Day 1
Today I have started my very first Collaborate Experience. It was a very interesting day indeed, all of the presentations I went to were of high value. My program …
RuleGen – the next generation framework for Data Logic (aka Data oriented business rules)?!
RuleGen is a framework that aids in implementing data integrity rules inside the Oracle RDBMS. That’s what it says on the website – www.rulegen.com – and that was the …
11g Technology Preview: XML Data Retrieval via Equi Partitioning by Reference
The success or downfall of your application is determined by proper logical and physical design, especially if it is based on stored XML data in an Oracle database. The …
Oracle announces XQuilla / XQilla XQuery engine available under the open source Apache 2.0 license
In the year that XML celebrates his 10th anniversary, Oracle announces to make the XQuilla XQuery engine available under the open source Apache 2.0 license. Via official sources, the …
AMIS Query 20/3: Toon Koppelaars, Gerwin Timmermans & RuleGen
Nog drie dagen te gaan, voor je laatste kans in een verfrissende, ouderwetse, gezellige en enerverende kennisavond met Gerwin Timmermans (AMIS) en Toon Koppelaars (RuleGen). Meld je aan, click …
Oracle DBA Symposium in Holland
Planboard organiseert een Oracle DBA Symposium op dinsdag 27 mei 2008. In tien technische sessies, verdeeld over twee parallelle tracks, delen DBA’ers hun praktijkervaringen met de deelnemers. Ze laten …
HOTSOS 2K8 – What Does Inspire Us…?
I can tell you about the next day. But I won’t. Most of it is (for people with the same interest) a known fact anyway. There was Tapio’s presentation, …
The Pro Active Database – Advanced Application Development with the Oracle Database
One of the themes of the seminar I am presenting next Tuesday – during the Red Database Symposium in The Hague – will be ‘the pro active database’. Of …
Hotsos 2008, day 2
Just a short impression of a few sessions today, and the day isn’t even over… I’m really loving it being here and seeing all these people thinking and acting …
Hotsos 2008, Day one
Hotsos 2008, first day of the symposium Today I had to make some difficult choices: There are too many presentation to see or just not enough me to go …