Subject: Re: How enforce uniqueness across partitions in the partition table?
To: Michael Cunningham <napacunningham@gmail.com>
Cc: "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>
 <d8bc227a-e65e-2cc2-d1de-b7fa44c8efb5@gmail.com>
 <CAPt39ts=UVSZsbinvbh2dveKPSFwOmQPshiV1UE3_VCYRQriEw@mail.gmail.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
Message-ID: <981fc80e-2281-9c11-836e-4c0b2af1818d@gmail.com>
Date: Tue, 6 Jun 2017 07:51:15 -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: <CAPt39ts=UVSZsbinvbh2dveKPSFwOmQPshiV1UE3_VCYRQriEw@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------617377D634B6C03479222EBD"
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
--------------617377D634B6C03479222EBD
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

On 06/06/2017 12:04 AM, Michael Cunningham wrote:
> Hi Elizabeth, I might as well chime in on this.
>
> I have put food on the table for 20 years now based on my Oracle 
> expertise. However, more and more I am involved in conversations about 
> how long Oracle will be able to treat customers the way they do while 
> other (cheaper) databases continue to gain stability and features.
>
> To give some meat to my statement I'm talking about the Oracle audits 
> (like Mladen mentioned) where the customer is treated like a criminal 
> - I've been there. And then there is licensing where if you use Oracle 
> cloud you get more bang for your buck now that the core licensing has 
> changed for other cloud providers such as Amazon. When management 
> hears this stuff they start looking for ways to get rid of Oracle. 
> Already, we have been directed to use "other than Oracle" databases 
> for all new projects. As someone who has defended Oracle for years 
> (due to my skillset) there is a time when I have to see the light. 
> That time cam during our latest audit.
>
> I can only speak for the San Francisco area, but, yes, my colleagues 
> have noticed a decline in Oracle jobs. That could be due to 
> outsourcing, but I honestly don't have enough knowledge in that area 
> to know. At the same time I see MySQL and PostgreSQL jobs still in 
> demand. It also seems jobs are on the rise for skilled AWS folks. 
> Aurora is not something that should be ignored with the ease of 
> migration from Oracle.
>
> I truly think 10 years from now the database landscape will look much 
> different than today in regards to Oracle.
>
>

Hi Michael,
Yes, I agree with your post almost entirely. However, Oracle extortion 
raids on their customers, also known as "audits", are not the only 
problem. The word "audit" seems to be quite popular with both Oracle 
Corp. and the Church of Scientology. Prices are the most fundamental 
issue here. Oracle is the only DB vendor which charges you for the right 
to create another database or for the right to create a partitioned 
table. Also, monitoring and diagnostic tools come separately. The prices 
needed to get something useful are outrageous. The other database 
vendors are not quite as good as Oracle, but in many cases, they are 
good enough.
Regards


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


--------------617377D634B6C03479222EBD
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">On 06/06/2017 12:04 AM, Michael
      Cunningham wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAPt39ts=UVSZsbinvbh2dveKPSFwOmQPshiV1UE3_VCYRQriEw@mail.gmail.com">
      <div dir="ltr">
        <div>Hi Elizabeth, I might as well chime in on this.</div>
        <div><br>
        </div>
        <div>I have put food on the table for 20 years now based on my
          Oracle expertise. However, more and more I am involved in
          conversations about how long Oracle will be able to treat
          customers the way they do while other (cheaper) databases
          continue to gain stability and features.</div>
        <div><br>
        </div>
        <div>To give some meat to my statement I'm talking about the
          Oracle audits (like Mladen mentioned) where the customer is
          treated like a criminal - I've been there. And then there is
          licensing where if you use Oracle cloud you get more bang for
          your buck now that the core licensing has changed for other
          cloud providers such as Amazon. When management hears this
          stuff they start looking for ways to get rid of Oracle.
          Already, we have been directed to use "other than Oracle"
          databases for all new projects. As someone who has defended
          Oracle for years (due to my skillset) there is a time when I
          have to see the light. That time cam during our latest audit.</div>
        <div><br>
        </div>
        <div>I can only speak for the San Francisco area, but, yes, my
          colleagues have noticed a decline in Oracle jobs. That could
          be due to outsourcing, but I honestly don't have enough
          knowledge in that area to know. At the same time I see MySQL
          and PostgreSQL jobs still in demand. It also seems jobs are on
          the rise for skilled AWS folks. Aurora is not something that
          should be ignored with the ease of migration from Oracle.</div>
        <div><br>
        </div>
        <div>I truly think 10 years from now the database landscape will
          look much different than today in regards to Oracle.</div>
      </div>
      <div class="gmail_extra"><br>
        <br>
      </div>
    </blockquote>
    <br>
    Hi Michael,<br>
    Yes, I agree with your post almost entirely. However, Oracle
    extortion raids on their customers, also known as "audits", are not
    the only problem. The word "audit" seems to be quite popular with
    both Oracle Corp. and the Church of Scientology. Prices are the most
    fundamental issue here. Oracle is the only DB vendor which charges
    you for the right to create another database or for the right to
    create a partitioned table. Also, monitoring and diagnostic tools
    come separately. The prices needed to get something useful are
    outrageous. The other database vendors are not quite as good as
    Oracle, but in many cases, they are good enough. <br>
    Regards<br>
    <p><br>
    </p>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Oracle DBA
<a class="moz-txt-link-freetext" href="http://mgogala.freehostia.com">http://mgogala.freehostia.com</a>
</pre>
  </body>
</html>

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