back to article Put down that Oracle database patch: It could cost $23,000 per CPU

Oracle has released "the most comprehensive patch set" ever for its database software – but its users should be aware of potentially wallet-busting features in the batch. Version 12.1.0.2 of the database came out on Tuesday and brought with it a range of new features, including Oracle's hotly anticipated "in memory" tech. The …

  1. John Sanders
    Linux

    And that's why...

    Everybody who can its movig to postgresql.

    1. phil dude
      Thumb Up

      Re: And that's why...

      yes, my poor man's solution for our disease genetics DB was to use /dev/shm for the table copies.

      Yes, only for read-only data...!

      This is also a hack we use on supercomputers too...

      P.

      1. Sir Alien

        Re: And that's why...

        You would like to know that PostgreSQL does support extensions one of which is Memcached

        http://railsware.com/blog/2012/04/23/postgresql-most-useful-extensions/

        So depending on use case... not always needed to hack about and putting files on SHM

        -SA

    2. Destroy All Monsters Silver badge
      Windows

      Re: And that's why...

      Yeah, well....

      So when will PostgreSQL Global Development Group actually move into the 21st century and manage to set up a bug tracking database?

  2. LHGFLICOD

    Or...

    INMEMORY_QUERY doesn't enable the feature. It allows sessions to use the feature if it is enabled, to enable the feature the parameter INMEMORY_SIZE is used to assign memory to the column store this defaults to 0 (disabled) and requires a restart to set, so not quite as on by default as it seems.

    1. TechicallyConfused

      Re: Or...

      Well the catch will be at what state Oracle consider it to be "ON" from a scalping you for the license cost point of view. This is a tried and tested Oracle stunt - eBusiness Suit install everything by default wizard being another favourite.

  3. MikeOxlong

    Almost a genuine reason for customers wanting DRM.

    When software licences are this expensive, it's almost a valid expectation that the feature should require some form of enabling licence key to switch it on when necessary.

    A Simple email, or even via the online portals of Oracle should allow a sysadmin or DBA to generate a test code that lasts for 14 days, (you should supply the system details it will be used on as well)

    Then Oracle can follow that up with the Software Asset management team of the client (or whoever normally settles the Oracle invoices and bills) to confirm the full code will be released and they can expect payment.

    Both vendor, and client/ customer have a duty of care to ensure there are suitable, and adequate measures in place to ensure a licence breach does not take place.

    Oracle, by not putting such checks and balances in place could be viewed as wilfully and deliberately allowing such breaches to take place so that post usage fees can be generated at a later date.

    Last I saw, This was similar to how VMWARE managed licences and nodes within a VMWARE farm.

    Even Microsofts licencing portal allows visibility of all the features that your company have licenced and how many are currently in use (approximately)

    1. Raoul Miller

      Re: Almost a genuine reason for customers wanting DRM.

      But none of Oracle's tech products have license keys (not sure about the apps side). The onus has always been on the customer to make sure what they are licensed for and what is actually deployed.

      In this case, however, I think a line has been crossed.

      1. Anonymous Coward
        Anonymous Coward

        Ah. The 'license audit'.

        I'd be willing to wager that the growth in revenue from 'add ons' comes not from willing customers but from the disgusting practices that oracle employ in the innocent sounding 'license audit'. I got scalped in the last financial year despite running (what we considered to be) very strict adherence to the rules.

        Funnily enough they got us on a couple of options that we had never used or installed (but were 'on by default') and their utterly ludicrous definition of what constitutes virtualization in their twisted world.

        Bitter ? You betcha ! Their ploys are deliberate and unethical. Although oddly they have helped me rigidly define my future IT strategy. My only real goal in my professional life is to do all I can to reduce payments and installation of oracle products.... :-)

        Caveat Emptor people. Nasty nasty organization...

        1. JeffyPoooh
          Pint

          Re: Ah. The 'license audit'.

          Wait until you discover that the "patch" also included the Ask toolbar !!

    2. JEDIDIAH
      Linux

      Re: Almost a genuine reason for customers wanting DRM.

      > When software licences are this expensive, it's almost a valid expectation that the feature should require some form of enabling licence key to switch it on when necessary.

      ...or the people managing multimillion dollar systems and software have half a clue and keep on top of this stuff. This isn't amateur hour.

      Mandatory license managers just cause trouble. That's another layer of complexity that important high value mission critical systems don't need.

  4. rob_leady
    Meh

    Not quite that expensive

    "setting you back at least $23,000 per Oracle SPARC processor it's installed on, we've heard"

    Based on the price list here:

    http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf

    it's $23,000 per Processor. But most SPARC processors use a factor of 0.5, so it'll only be $11,500...

    http://www.oracle.com/us/corporate/contracts/processor-core-factor-table-070634.pdf

    1. asdf
      Mushroom

      Re: Not quite that expensive

      >it's $23,000 per Processor. But most SPARC processors use a factor of 0.5, so it'll only be $11,500...

      Oh well then that changes everything. 11 grand is nothing (besides a fairly nice used car). What saves most people that use Oracle is you said SPARC. Careful dead platform stumbling by.

  5. Allison Park

    actually $184K per SPARC chip and $736K per server

    SPARC T5 is 16 cores * .5 core factor table = 8 licenses required.

    8 * $23K = $184K

    Since most database systems have four sockets at least you are now talking about $736K per box.

    Now you know why Oracle bought the SPANC technology.

  6. LicenseConsulting.EU
    Thumb Up

    License Consulting

    No news here: Even Standard Edition One users can run Enterprise features. A curious DBA can run a Backupset with 'medium' or 'high' compression on command line or via OEM, and then Oracle comes along a year later and demand licenses for Enterprise Edition and Advanced Compression. Which would account for $47.500 + $11.500 = $59.000 per Processor license. It's simply a sales strategy. This is one out of probably hundred examples we have run into.

    What really strikes me is the word choosing:"....Oracle chooses to carry out a license fee audit". It IS all about money and not about compliance. Unprepared folks will indeed pay unnecessarily.

    1. Anonymous Coward
      Anonymous Coward

      Re: License Consulting

      Just tell them to f*ck off and die. What they going to do, start suing their customer base? As long as you're not a minnow - in which case you're retarded to be using Oracle - they'll need to negotiate.

      1. Anonymous Coward
        Anonymous Coward

        Re: License Consulting

        "What they going to do, start suing their customer base?"

        Yes that's exactly what they'll do, they have form for exactly that.

  7. Anonymous Coward
    Anonymous Coward

    Caching disk in RAM is a new feature

    Is anybody in the DB parallel universe embarrassed?

    What's the next innovation, a string comparison that short circuits on the first differing character?

    Sorry to spoil that for you.

  8. xpabu

    Totally agreed with you, License Consulting. Probably news for a lot of people who haven't been caught out yet...

  9. Michael Kean

    SSD?

    Hi :)

    I'm not at all in the world of databases, having progressed only as far as Microsoft Access and VBA; so perhaps this is a stupid suggestion; but with SSDs being so fast these days does it really matter if data is not in RAM any more?

    Cheers, Mike.

    1. Robert Heffernan

      Re: SSD?

      Yes, it still matters quite a lot. While SSDs are faster than spinning rust drives, RAM still blows it away by an order of magnitude at least.

      These read speed figures for media are rather general

      Cheap USB2 Flash Drive: 5mb/sec

      7200 RPM SATA HDD: 120mb/sec

      SSD: 550mb/sec

      DDR3 RAM: 12,500mb/sec

      So from that you can see how much faster your database would run with your tabled cached in RAM.

      That being said, at $28k per core I don't give two shits how fast my database runs, you shouldn't have to pay that much for what should be a basic feature of any database

  10. Destroy All Monsters Silver badge
    Windows

    Old tricks work best.

    Basically the old "extra lapdancing fees" scam.

    And did I spy a previously unknown usage for the word nascent in: "It really should have a default initialization setting that renders the option/feature nascent"?

    1. kevinclosson.wordpress.com

      Re: Old tricks work best.

      Yeah, my thesaurus skills failed me there. I updated the blog. Thanks for pointing it out.

      1. Destroy All Monsters Silver badge

        Re: Old tricks work best.

        My pleasure.

  11. chasil

    Oracle Clone

    If I endured a hostile audit, I'd be in a hurry to switch to EnterpriseDB for every server I could.

    http://www.enterprisedb.com/solutions/oracle-compatibility

  12. Lee D

    If you're large enough to justify using Oracle, you would hardly care. In fact, you'd probably pay it for the option to move that much faster.

    If you're not large enough to justify using Oracle, STOP USING ORACLE.

    I don't particularly care what companies this huge charge for databases sold on this scale. If you're even CAPABLE of paying that much money for one piece of software running on one processor, you're big enough to know what to do about it and hire experts to manage it and the time is critical. Everyone else can just jumble along on "normal" business databases quite happily.

    Seriously, I'm not even sure at what kind of scale I'd need to start thinking to myself "Hmmm... Oracle might be what I need here". Possibly government-sized? I don't know. Certainly not 99.999% of the IT that's out there in the world.

  13. Sir_Hops_A_Lot

    When did "Patch" stop meaning "Free fix for stuff we screwed-up. Sorry about that."?

    1. Anonymous Coward
      Anonymous Coward

      When did "Patch" stop meaning "Free fix..."

      It never did, except in the universe where the "Ask taskbar" is included in a JRE download.

      I've just spent forty minutes on the phone remote diagnosing this and removing it for someone whose IT literate family member has died. Bastards.

  14. Anonymous Coward
    Anonymous Coward

    I think that the true purpose of Oracle is to make Microsoft look like angels in comparison.

    As above.

    ......

  15. KayKay
    FAIL

    mmap has existed in unix since??? 1970's? so this is new?

  16. Duncan Macdonald

    Large SGA ?

    Back in Oracle version 7 (last version that I used), if the SGA (Shared Global Area) was larger than the database (plenty of RAM and small database) then once a table had been read in it would never be evicted from RAM so it was possible to run the whole database from RAM - the only I/Os were writes from database updates. Given Oracle's exorbitant pricing , if the database can be held in memory this way then this might be the better option (assuming that for some reason you are locked into Oracle).

  17. Matt Bryant Silver badge
    Happy

    MemFS/TmpFS?

    Does the Oracle DB know what is "RAM" only by the SGA size? If so, does it know memory being presented as an in-memory fielsystem by tools such as memFS or tmpFS is actually memory or does it think it is "disk"? If so, could you get round the memory tax by creating a memory filesystem, thus getting the speed of RAM without the added licenses? You would need lots of memory to ensure the memory filesystem didn't eat too much shared memory, but RAM is cheaper than Oracle licenses......

  18. Alin Sas
    Thumb Down

    Not really accurate.

    Actually if the option is installed it doesn't mean it's in use. The whole article is based on having the INMEMORY_QUERY parameter enabled but this only shows proof of installation. The most important part is having the parameter INMEMORY_SIZE = 0 (default value) as this makes the whole difference and shows proof of non usage.

  19. bobajob12
    WTF?

    Confused, maybe an ORCL DBA can explain

    Haven't used Oracle since a RAC fiasco involving cache coherency (or more accurately, incoherency). But IIRC:

    - you can tune the SGA to trade memory usage for disk I/O, so that your frequently-hit tables stay in memory. How is that different from this IN_MEMORY option? Is it just a more aggressive hint to the DB that My Particular Table gets first dibs, as opposed to letting the SGA manager decide?

    - you could pull tricks outside of Oracle, such as using mmapped files. I suppose that's only useful if your special table is in a file by itself and/or your DB files fit in RAM?

    Can someone explain?

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

Biting the hand that feeds IT © 1998–2022