Re: very impressed by 11g

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 26 Apr 2012 02:35:48 +0000 (UTC)
Message-ID: <pan.2012.04.26.02.35.48_at_gmail.com>



On Wed, 25 Apr 2012 19:07:22 +0100, Eric wrote:

> On 2012-04-24, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

>> On Tue, 24 Apr 2012 13:41:56 -0700, Matthias Hoys wrote:
>>
>>> What was the compatible parameter set to originally? 10.2.0.5? Must be
>>> that the change activated some new Oracle 11g optimizer features...
>>> 
>>> Matthias
>>
>> Sounds like it was set to 5.1.22 or 6.0.33.

>
> 5.1.22 ? Those were the days - things were simpler then.
>
> Eric

I am partial to 6.0. I was the first guy in the EMEA region licensed to teach Oracle 6 internals course by Oracle Austria. The examiner was a guy named Wolfgang Schluessel. That was the first version I was utilizing on Unix. 5.1.22 was, at least in my mind, tied to VAX/VMS. Before image file (now "UNDO tablespace") was defined as VAX$BI. There was a utility to start the instance called "ior". One would run "ior w" for warm start or "ior c" for the cold start. Monitor was called "odt". It was complicated. Oracle 6 had sqldba, with a nice top-like monitor. That was changed to "svrgmgrl" in oracle7 and oracle8i, but I still have alias svrmgrl="sqlplus / as sysdba"
in my .bashrc. Of course, I started with Oracle 4 and "ufi" (user friendly interface) on dos 3.3. There was a language to write forms, one had to use an editor, write a form, compile it with iac.exe and run it with iap.exe. That was running in 512KB of memory. Yes, it was "K" as in "kilo". Boy, I feel old.
This year, we will see Oracle 12F. A long way for someone who has started with the version 4 and installed it from floppy disks. However, this year will be different. It looks like IBM has finally begun to seriously look into selling DB2 on Linux. They dropped the prices much lower than Oracle and Oracle should brace for impact. I feel that the pervasive mood has turned against Oracle.

-- 
http://mgogala.byethost5.com
Received on Wed Apr 25 2012 - 21:35:48 CDT

Original text of this message