Month: January 2007

8.1.7 desupport exceptions

In the Critical Patch Update 2007 January Pre-Release Announcement, you may wonder why there is a 8.1.7.4 CPU patch. The reason is, Oracle 8.1.7.4 is still supported for some application supported by Oracle like Siebel, E-Business and Clinical. Have a look at Metalink Note 148054.1

RAC workshop

As announced, I have been speaking for Credit Suisse employees last week. The objective was to give the database project and team leaders the keys arguments for going or not going to RAC. First : what is RAC ? Oracle Real Application Cluster. You have a shared storage, and two instances accessing the same database. […]

Fit for RAC

I will be speaking tomorrow in German and Wednesday in English in Credit Suisse Bank. The workshop is about the differences between single instance and RAC Some of them : architecture, availability, scalability, manageability, skills required, price. I will talk also about the operational aspects, upgrade, dictionary, parameter file.

Paul Moen article on MONTHS_BETWEEN

I have been shocked by Paul Moen article on MONTHS_BETWEEN. Here is my own case : SQL> select months_between( date ‘2000-03-01’, date ‘2000-02-28’) * 31 from dual; 4 Incredible! I have always been very careful with months_between because of the documented end_of_month behaviour (there is one month between 30-APR and 31-MAY), but I did not […]