HOTSOS 2K8 – About Filling the Gaps in Performance Tuning
After a quick breakfast, the Hotsos symposium got on has way with a small introduction of Gary Goodman on reviewing the history of the symposium event. This time also …
Category: Database
HOTSOS 2K8 – Prequals
It’s Sunday and the first signs from the up coming Hotsos 2008 symposium are beginning to show in the Omni Hotel. The conference rooms are being set-up and the …
Hotsos 2008, here we come…
It was supposed to happen in 2007, but due to some private issues I never made it to Hotsos that year. I have been wanting to attend since several …
HOTSOS 2K8 – Mind the GAPP
If your there, "mind the GAPP", also during Hotsos. Tomorrow, my colleagues and me, will arrive in San Colinas, Dallas, TX. Yesterday I got the first taste of Gerwin’s …
Advanced Application Development with the Oracle Database – preparing for the RedDatabase Symposium (11th March 2008, Den Haag)
I am having fun today. Today I started in earnest with my preparation for the RedDatabase Symposium, a very promising three-day event on the Oracle Database, with a total …
How to stop running RMAN jobs in OEM Grid Control
Life became very easy after Oracle’s invention of OEM Grid Control. That is what Oracle promised us when they invented it. A couple of months ago one of my …
What have a Merchant, some strawberries and a performance problem in common…….
If you want to know what a Merchant, some strawberries and a performance problem have in common, you should come to the AMIS Query at thursday (28-02-2008). In this …
Saving (XML) data directly to disk
I was asked, also after the former post “Selecting (XML) data directly from disk“, what the best way would be to save data directly (locally) to disk via XMLDB …
AMIS Query 28/2: Een nieuwe denkwijze op het gebied van Business Proces Performance
How System Metrics Can Help You Find Performance Bottlenecks for Business Processes in Complex Architectures Gerwin Hendriksen will give a pre-view on the 28th of Februari of his presentation …
Selecting (XML) data directly from disk
On the OTN XMLDB Forum, a question was asked if you could directly select from a XML file on disk, or to be more precise ” XQUERY / XMLTABLE …
HOTSOS 2008
The new year has started and one of the most important Oracle performance conferences is about to start. The Hotsos 2008 Symposium will be held again, almost traditionally now, …
Puzzelen met SQL: Crash SQL Investigation
![Puzzelen met SQL: Crash SQL Investigation]({"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"} "Puzzelen met SQL: Crash SQL Investigation")
door Anton Scheffer en Alex Nuijten Dit artikel is de on-line tegenhanger van de rubriek Puzzelen met SQL die verschijnt in de Optimize, het vakblad voor Oracle ontwikkelaars in …
Scribble on a Pull-turns-push architecture based on http – registering web applications as event listeners
Today in the car I had some thoughts on applications working together, across the boundaries of technology and organizations. I tried to find an easy, cheap way for for …
Your lucky if you are in Holland – A Great Symposium Announced
Oracle The Netherlands just announced, via email, an great "RedDatabase Symposium" event / symposium on 10,11 and 12th of March, organized by RedStone Innovations. The focal points for this …
UKOUG 2007 – The Final Verdict of the Attendees
Today, I got my evaluation results for my presentation during UKOUG last year. Overall, I am not unhappy. I am a little bit perfectionist minded, but for a first …
Year 2007 Round-Up and Picture Galore
It has been a very interesting year for me. I met a lot of people of whom I only had the pleasure to mail with. Some of them are …
APEX and/or ADF – demonstrating two similar yet different applications
December 23, 2007
Database, IT, Java, Oracle, Oracle Application Development Framework, PL/SQL
8 Comments
Last Monday, we organized an AMIS Query on APEX and ADF. Dimitri Gielis, APEX specialist, joined us and presented his ideas on APEX. I took on the role as …
Where is my WHERE?
Sometimes I encounter query which have a WHERE clause that starts with: select ... from ... where 1=1 and ... When asked the reason for this predicate, most of …
Report from Oracle Open World 2007 – Slides from our Knowledge session
December 19, 2007
Database, IT, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA
No Comments
Last month we organized a Knowledge Center session on Oracle Open World 2007. AMIS consultants Peter, Sjoerd, Harm and Lucas were joined by Lonneke from Approach Alliance to present …
SQL in Java: To batch or not to batch with Oracle JDBC
Last week I had to parse thousands of sql insert statements, read from files (one file per table), within a Java environment. These files contain complete SQL insert statements, …
UKOUG – Wednesday, Thursday and Wrap-up
I met a fellow dba with 20 years of experience and I couldn’t make him understand James Morle’s presentation regarding skew and latency (f.k.a. “Every Performance Problem Is One …
UKOUG – Pictures and some not so nice stuff…
Thanks to Daniel Fink I was able to upload some pictures now. Have a look at my written posts. In the meanwhile (if you didn’t notice) a not so …
UKOUG – Running the Gauntlet
I didn’t "do" much on Tuesday regarding the attending of sessions. I saw Alex Gorbachevs’s presentation regarding "RAC connection management". I was a little bit "afraid" of the "RAC" …
Puzzelen met SQL – de Kassabon
Dit artikel is de on-line tegenhanger van de rubriek Puzzelen met SQL die verschijnt in de Optimize, het vakblad voor Oracle ontwikkelaars in Nederland. Vooral op het …
UKOUG – Monday
The day started off with a two keynote session from Ian Smith and Thomas Kyte. Tom Kyte addressed more or less the same items (“30 years of Oracle”) as …
UKOUG – Monday First Impressions and The Human Lottery Show
On Sunday I left to Birmingham to attend and, for the first time, speak at the UKOUG. It started off completely wrong. I went with a taxi to the …
Custom authentication in Apex (part 1)
Another word for authentication is acces control. Authentication is the mechanism to verify the user’s identity and provide access to a system or application based on the credentials entered …
and now we present… 11g and Apex on Ubuntu
Thanks to a completed messed-up Windows (I managed to demolish my network connections beyond repair) and a helpful tutorial from Dizwell’s blog (thank you oh so very much!) I …
AMIS Query – on developing Web Applications with Oracle development technology: ADF and Application Express side by side (with Dimitri Gielis and Lucas Jellema)
AMIS is proud to announce an AMIS Query on Monday 17th December 2007: Developing Web Applications with Oracle development technology: ADF and Application Express, side by side. There are …
OOW 2007: (most) presentations available for download
Most of the presentations for the sessions presented at Oracle Open World 2007, last week in San Francisco, can be downloaded from the Content Catalog at: http://www28.cplan.com/cc176/catalog.jsp. You will …
OOW 2007: The Great Oracle SQL Quiz. We have a winner: Laurent Schneider
Just under an hour ago, we completed The Great Oracle SQL Quiz session at Oracle Open World. Around one hundred attendants managed to find their way to the session …
Oracle 11g – Generating PL/SQL Compiler Warnings (Java style) using PL/Scope
The Oracle 11g PL/Scope feature allows us to have the PL/SQL compiler generate information on all identifiers used in our PL/SQL code. Using the information generated and available from …
OOW 2007: Mark Townsend explains "Storage is not cheap"
My first formal activity at Oracle Open World 2007 was the Oracle Ace Director Product Briefing. A closed session where 30 odd ACE Directors (and you read that any …
Oracle 11g for Developers – 60+ slide presentation
The November 1st presentation that Alex and I did on 11g – focusing on features and functionality that are of particular interest for developers – is finally available for …
Conditional Default Value – How to set different default Salary for Managers, Clerks and Others? (not in the Great SQL Quiz at OOW)
In about a week’s time, I am presenting the Great Oracle SQL Quiz, at Oracle Open World in San Francisco. Thursday morning, 8.30am (it’s session S290735 – Hilton Continental …
The Great Oracle SQL Quiz – your chance to get grilled at Open World (S290735) – two sample questions
Next week, I am doing two presentations at Oracle Open World, both on Thursday. One is on ADF – more on that later. The other one is The Great …
Querying RSS feeds in SQL – contortionism with Oracle XML DB in 10 lines of SQL
There are times when a challenge presents itself. Often for no logical reason and without any direct benefit. Like doing a crosswords. I have this unconscious part of me …
AMIS Query, November 6th – Introduction into the practical use of Oracle XMLDB
At last notice. Next week, Harm and I, will give an AMIS Query about the practical use of XMLDB.In short, I will give an introduction into the XMLDB Features like …
OAUG Fusion Middleware BootCamp Chicago – Part IV
The past days have been really interesting. During last Wednesday (november 24) we finished the XML topic, covering Generating XML from an Oracle Database, Managing XML data in an Oracle Database, …
OAUG Fusion Middleware BootCamp Chicago – Part III
Hi there! Today we continued our journey into the XML realm, by exploring the XML Schema, XPath, XSL and XML DB. XML Schemas XML Schemas are based on XML …