Category: Database
Apparently it is still out there, the RBO in 10g. I saw the following post of Eric Jenkinson in a OTN forum...
Analytical Functions are a joy in my life as an Oracle developer. I have been demonstrating them, presenting on them, teaching on them and using them. Today I had …
It looks like that the upcoming Oracle 11 release will be certified on SUSE Linux Enterprise 10. As a Novell / SUSE communique (Novell news - 3 oct) says …
Even though we keep telling ourselves that iron these days is cheap, I was having difficulties with my laptop’s hard disk. It was almost full – to the brim. …
When you use VMware Server software to move or clone VMware Linux guest machines, you are asked by the VMware software if it should update the configuration file. When …
When defining sequences, you can choose to set a cache size or disable the sequence cache: create sequence tst_nc2 start with 1 increment by 1 nocycle nocache; create sequence …
Database Performance Analysis and Tuning of queries and Database Design have never been my specialty. As of late, I have been reading a lot in this area, on Wait …
Yesterday I needed to apply a patch to my Oracle E-Business Suite 11.5.10.2 environment. This environment consist of a 10G release 2 RAC database and two application tiers. I …
I signed up a while ago for the SUSE Cool Solutions mailling list and I saw a very good step-by-step from Michel Bluteau regarding "Installing Oracle 10g R2 Database …
Riddle me this: Can an object exist in all_objects before it is created?Well no, of course not. I was under the assumption that if you create a table with …
At the customer site where I work, we are using an Oracle 9i. More specific a 9.2.0.5 database. While demonstrating to one of my colleagues when an index can …
AMIS has been proven worthy to test the upcoming release of the 11gR1 database. After entering a lot of data in questionnaires and filling in project plans, AMIS got …
We all are at least a bit aware of the awkward behaviour of NULL in Oracle. But it still is difficult every time we encounter it in a function …
or How to deploy into an application-specific OCJ4-container on Oracle AS 10.1.3 without JBOExecption during deployment when your application uses ADF Lately our developers were working on an application …
I just got started using XMLType. I know maybe a little late to start to look at it, but better late than never, right? Anyways, to see what is …
Back in 1998 or 1999 I filed a bug/enhancement request in the Oracle bug database. As I was still working at Oracle back then and I had direct access …
Recently I had to extract data from 5 Access databases and 4 Excel files and merge the data into an Oracle table. One method was to export the data from Access to Oracle via …
My colleague Alex Nuijten did a very fine presentation on Oracle Analytical Functions during the recent ODTUG 2006 conference in Washington DC. His paper for this conference was nominated …
Lucene is a text search engine written in Java. It’s very easy to use (for both developers and users) and fast. The creator of Lucene (Doug Cutting) started with …
Automatic continuous compilation of webforms on linux without X-terminal In the webforms world you it is not uncommon to compile a webforms application on a linux/unix application server, after …
Theserverside is offering a free copy of Mastering EJB3.0. Published in July 2006, the best selling book Mastering EJB is now in its fourth edition and has been updated …
With Java EE 5 being final, application servers need to be upgraded to support features like EJB 3.0. In some cases, loading the Java EE 5 jars may be …
Using CLOBs, conversion to and from VARCHAR2 may give you a headache.
Two weeks ago I encountered a very weird issue when using Microsoft Cluster Server. What happened? We created a MS Cluster Server environment with two servers (NodeA and NodeB, the …
Today I read a remarkable statement in the Dutch Automatiserings Gids - they claim that Windows WinFS will not only not be embedded in Windows Vista but also will …
When trying to create anonymous data, I encountered an unexpected side effect of the updateXML statement while updating XML documents in an Oracle 10gR2 (10.2.0.1.0) EE database. I got …
Interested in the features and options of the different editions (standard, express and enterprise) of the Oracle database? This document lists them all in a handy matrix format.
Last night, the ODTUG 2006 Conference Committee announced that all handouts and presentations from this year’s (well, in fact that is last week’s) conference are available for download from …
During one of the sessions on last week’s ODTUG 2006 conference, I saw a very interesting demo by Keith Laker. He discussed the problem of having several dozens of …
Ohhh, thy mighty Oracle. I had completly forgotten about him and then we where re-united. We met years and years and years ago…and I coud always ask him …
Right after the Oracle Quiz Lucas and I presented last week on ODTUG, I went to Mogens Norgaard’s presentation. Here is a short report from that session, you may …
Last week at the ODTUG conference, I did a presentation on Analytic Functions. Later on someone came up to me and asked me if there is also a Median-function …
While preparing a Lucene presentation and workshop I came across Spring Modules. It’s a small set of libraries that does things the Spring-way. It isn’t included in Spring because …
The problem: I recently had to resolve a problem at a client’s site where an automated database provisioning process was regularly failing due to LAN outages. Under normal circumstances, …
When you use Oracle Alert, a module from the Oracle EBS, you probably work with custom alerts next to the standard alerts provided by Oracle. When working with custom …
Today was another AMIS day at ODTUG 2006. After yesterday’s three presentations, today we have done another three. Aino kicked off at 8.30 AM with his presentation on How …
It's Showtime! Today at ODTUG 2006, Alex and I are presenting our Oracle Quiz on SQL and PL/SQL – the water is still burning. We will present our audience …
JSpring vond net als JFall van afgelopen jaar weer plaats in de Reehorst in Ede, een mooie locatie en vooral goed bereikbaar met de auto. Er stonden weer diverse …
Routeplanners have always been somewhat magical in my eyes. Finding the quickest route from A to B in a graph of thousands of points and connections. I have tried …
Yesterday I installed Oracle XE at my Ubuntu Linux server at home. I wanted to do this for a long time but was a bit scared because installing non …
![How does the sequence cache affect performance?]({"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"} "How does the sequence cache affect performance?")