Re: very impressed by 11g
From: Boris Findrik <boris.findrikmakni_at_zg.t-com.hr>
Date: Thu, 26 Apr 2012 20:21:20 +0200
Message-ID: <jnc3n7$ca4$1_at_ss408.t-com.hr>
On 26.4.2012. 4:35, Mladen Gogala wrote:
> 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.
>
>
I am almost sure that we have 5.0.27 on Unisys 5000/50 (Motorola 68020, 80M mem(?), 3 x 110M HD, SVR3).
15 users, uvt1224 terminals, works like a charm.
Date: Thu, 26 Apr 2012 20:21:20 +0200
Message-ID: <jnc3n7$ca4$1_at_ss408.t-com.hr>
On 26.4.2012. 4:35, Mladen Gogala wrote:
> 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.
>
>
I am almost sure that we have 5.0.27 on Unisys 5000/50 (Motorola 68020, 80M mem(?), 3 x 110M HD, SVR3).
15 users, uvt1224 terminals, works like a charm.
And, I expect 12C. Received on Thu Apr 26 2012 - 13:21:20 CDT