Re: How enforce uniqueness across partitions in the partition table?
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: "Reen, Elizabeth" <elizabeth.reen@xxxxxxxx>, Stefan Koehler <contact@xxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Jun 2017 18:55:27 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Mladen Gogala
Sent: Saturday, June 03, 2017 5:52 PM
To: Stefan Koehler; oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: