Subject: Re: How enforce uniqueness across partitions in the partition table?
To: "Reen, Elizabeth" <elizabeth.reen@citi.com>,
 Stefan Koehler <contact@soocs.de>,
 "oracle-l@freelists.org" <oracle-l@freelists.org>
References: <CAHL4c1OwDEjEFQ86nV=T-e-hKup8ZQSq7g79mJOvh9+gHwkdDw@mail.gmail.com>
 <1491659099.7087.1496254760915@ox.hosteurope.de>
 <6f9bcb48-e231-5c7f-2a06-9d193ba13f1c@gmail.com>
 <785524811.6188.1496491666813@ox.hosteurope.de>
 <dc74eaa6-e4cd-ba21-efe9-e799d80b05ba@gmail.com>
 <258575162B63424EB58DAE3A5475B6ED0124CD67B8@EXNJMB25.nam.nsroot.net>
From: Mladen Gogala <gogala.mladen@gmail.com>
Message-ID: <d8bc227a-e65e-2cc2-d1de-b7fa44c8efb5@gmail.com>
Date: Mon, 5 Jun 2017 18:55:27 -0400
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:52.0) Gecko/20100101
 Thunderbird/52.1.1
MIME-Version: 1.0
In-Reply-To: <258575162B63424EB58DAE3A5475B6ED0124CD67B8@EXNJMB25.nam.nsroot.net>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: gogala.mladen@gmail.com

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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mladen Gogala
> Sent: Saturday, June 03, 2017 5:52 PM
> To: Stefan Koehler; oracle-l@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=DwI
>> CaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV
>> 7xpc&m=7VzWvhVFIujVnM5fZqjU7ILBtleiQhSOFYT_CRdtg_w&s=cTPo9yrBlCUK43Vz8
>> aXqTj2sYir7PBCJnMPcGHhHB4Q&e=
>> Twitter: @OracleSK
>> Upcoming online seminar:
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__tinyurl.com_17-2D0
>> 6-2D13-2DShared-2DPool-2DInternals&d=DwICaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r
>> =yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=7VzWvhVFIujVnM5fZqjU7IL
>> 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=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=7VzWvhVFIujVnM5fZqjU7ILBtleiQhSOFYT_CRdtg_w&s=YIR5MdRweYziOKkmGKYJjW1Lg2omw3fZfS0kmKBxYWs&e=
>
> --
> https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwICaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=7VzWvhVFIujVnM5fZqjU7ILBtleiQhSOFYT_CRdtg_w&s=JwKdXEjrv_oPeRULW6sWMoEDvWMqYA_ZgWpEhaLB3MY&e=
>
>

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

--
http://www.freelists.org/webpage/oracle-l