RE: How enforce uniqueness across partitions in the partition table?

        I agree VMS was the best operating system ever. Everything else has been a step backwards. Good engineering does not win against great advertising. The COBOL programmers, who didn’t bother to learn anything else, were a warning to me. This is an ever changing business; we need to be always learning. I went from a VMS sys manager to a UNIX sys admin to an Oracle DBA. I'm sure I'll turn into something else before I retire in about 9 years.

Liz

-----Original Message-----
From: Mladen Gogala [mailto:gogala.mladen_at_gmail.com] Sent: Monday, June 05, 2017 6:55 PM
To: Reen, Elizabeth [ICG-IT]; Stefan Koehler; oracle-l_at_freelists.org Subject: Re: How enforce uniqueness across partitions in the partition table?

On 06/05/2017 11:53 AM, Reen, Elizabeth wrote:
> Where are you getting your information from?

Dice.com and Monster.com are my favorite job . Every now and then I check my options.

> I agree that there are fewer DBA jobs around, but that is due more to offshoring than an Oracle decline. Sybase and SqlServer DBA jobs are not exactly abundant either. Also it depends on where you live.

Well, I live in the Big Apple. And I noticed that SAP Hana is making great inroads. I am not particularly interested in SQL Server jobs because they don't pay as well as the Oracle jobs. I've also had several consulting gigs for replacing Oracle with DB2, which was almost unthinkable not so long ago. Of course Sybase is in decline, SAP is clearly favoring Hana. DB2 is a lot cheaper than Oracle and can do many of the same things. In version 11, Oracle compatibility is further improved and in-memory option, also known as "Blue Acceleration" is further improved. Blue Acceleration is actually approximately a year older than Oracle's In-Memory option, but it is included in the DB2 enterprise version. MariaDB 10 has also mastered maintaining simultaneous copies of the data in row format and column format, which is now known as "In-Memory Option". I have worked for some victims of the infamous "audits" and I know the general mood.

History sometimes repeats itself. Once upon a time, there was a dashing and brilliant entrepreneur named Ken Olsen, who has built the second largest IT company in the world, second only to the mighty IBM. Products of the company, both software and hardware, were present everywhere in the IT world. The company's influence is being felt even today, more than 20 years after its demise. Oracle's GI has obviously evolved from the Tru64 clustering. Yet, when the collapse came, it was very sudden, total and final. At that point, I was in your shoes because I couldn't believe that the once mighty company from Maynard Mill, MA could collapse so quickly. And yet it did. The collapse killed off the best OS that I have ever seen, bar none. No Linux or Windows versions can come even close to the monitoring facilities, diagnostic facilities and ease of use of VMS. Yet, it died, very suddenly and abruptly. The levels of hostility toward the company from some of my colleagues were similar to the vibe I feel these days. I wish I am wrong, but I don't think so. I have devoted a good part of my life to Oracle and am not thrilled by having to change my specialty in the 57th year of my life. However, that is exactly what I am doing.

>
> Liz
>
> Elizabeth Reen
> CPB Database Group Manager
> 718.248.9930 (Office)
> Service Now Group: CPB-ORACLE-DB-SUPPORT
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
> Sent: Saturday, June 03, 2017 5:52 PM
> To: Stefan Koehler; oracle-l_at_freelists.org
> Subject: Re: How enforce uniqueness across partitions in the partition table?
>
> On 06/03/2017 08:07 AM, Stefan Koehler wrote:
>> Hey Mladen,
>> ???
>>
>> What has all your text to do with Vadim's question and the mentioned
>> feature "Asynchronous Global Index Maintenance"? "Asynchronous Global Index Maintenance" is not an option - just an enhancement - and everybody who is using partitioning (option) today gets the benefits of it with 12c.
>> Partitioning is used a lot in the field.
>>
>> Best Regards
>> Stefan Koehler
>>
>> Independent Oracle performance consultant and researcher
>> Website:
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de&d=Dw
>> I
>> CaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9Uxec
>> V
>> 7xpc&m=7VzWvhVFIujVnM5fZqjU7ILBtleiQhSOFYT_CRdtg_w&s=cTPo9yrBlCUK43Vz
>> 8
>> aXqTj2sYir7PBCJnMPcGHhHB4Q&e=
>> Twitter: _at_OracleSK
>> Upcoming online seminar:
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__tinyurl.com_17-2D
>> 0
>> 6-2D13-2DShared-2DPool-2DInternals&d=DwICaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&
>> r
>> =yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=7VzWvhVFIujVnM5fZqjU7I
>> L
>> BtleiQhSOFYT_CRdtg_w&s=lhptluHJJOD5DrEWGX6m1aYvGFeyIvPlpVt3VoKNmhs&e=
> Hi Stefan,
>
> I was simply pointing out the fact that Vadim, the original poster, will probably not have the "Asynchronous Global Index Maintenance" option at his disposal. Very few people will. The option existence information you provided is interesting but not very useful.
>
> Regards
>
>
> --
> Mladen Gogala
> Oracle DBA
> https://urldefense.proofpoint.com/v2/url?u=http-3A__mgogala.freehostia
> .com&d=DwICaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxu
> stAZ9UxecV7xpc&m=7VzWvhVFIujVnM5fZqjU7ILBtleiQhSOFYT_CRdtg_w&s=YIR5MdR
> weYziOKkmGKYJjW1Lg2omw3fZfS0kmKBxYWs&e=
>
> --
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_
> webpage_oracle-2Dl&d=DwICaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8V
> LeJtKLVJGefQxustAZ9UxecV7xpc&m=7VzWvhVFIujVnM5fZqjU7ILBtleiQhSOFYT_CRd
> tg_w&s=JwKdXEjrv_oPeRULW6sWMoEDvWMqYA_ZgWpEhaLB3MY&e=
>
>

--
Mladen Gogala
Oracle DBA
https://urldefense.proofpoint.com/v2/url?u=http-3A__mgogala.freehostia.com&d=DwICaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=TPSbquwstMqaOb2FqMPzKjWlVaFP_JACem1dSs_23jU&s=UWkGRXvWdqNDRnBHHoHdOzYoXK61-Mq-ae70hLMaeuM&e=

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Jun 06 2017 - 16:33:15 CEST