Slashdot Mirror
Review: Oracle Database 12c
snydeq writes "InfoWorld's Riyaj Shamsudeen offers an in-depth look at Oracle Database 12c, which he calls a 'true cloud database,' bringing a new level of efficiency and ease to database consolidation. 'In development for roughly four years, Oracle Database 12c introduces so many important new capabilities in so many areas — database consolidation, query optimization, performance tuning, high availability, partitioning, backup and recovery — that even a lengthy review has to cut corners. Nevertheless, in addition to covering the big ticket items, I'll give a number of the lesser enhancements their due,' writes Riyaj Shamsudeen. 'Having worked with the beta for many months, I can tell you that the quality of software is also impressive, starting with a smooth RAC cluster installation. As with any new software release, I did encounter a few minor bugs. Hopefully these have been resolved in the production release that arrived yesterday.'"
Shouldn't shill articles be over on SlashBusinessCrap or whatever?
Backup and restore are new features in this latest version of the Oracle Database??
How on earth did they manage before?! Seriously? Is it just me or am I the only person who writes programs from scratch with data security, portability and safety in mind? Gosh, My data has been separate from the program since I was loading out to 90-minute Type II's!
I mean, seriously, from this article can we assume that mysqldump offered a more sensible backup than every version of the mega-expensive Oracle, until this version?
This tagline was transcoded to result in at least one smirk. If you experience failure to smirk, please consult your Gen
Wow. What a blatant advertisement. Slashdot has really sunk.
Wait what. He wrote a review about Oracle, gave an 8 for value, and didn't mention pricing? Is this some kind of shill or such?
Even for a shill I would at least expect a line like
'Yes, a license for a normal octocore setup costs more than your home, but...'
or 'After going through the 2 hour cost calculation matrix, the resulting price seemed a tad steep, but'
It's free for personal use (edelivery.oracle.com) just like all Oracle software. You only need paid licenses and support for commercial use. For that you need a lot of money.
Well good luck getting MySQL or MariaDB to run 24/7 on a multi terrabyte database with 99.999% uptime including doing backups.
Nobody, not one single person is using Oracle databases in a personal capacity. It is always in connection with business. Therefore, I expect there to be a mention of pricing.
Finally had enough. Come see us over at https://soylentnews.org/
So if you're one guy who needs a database for himself that he doesn't need to expose to clients at all, it's only $200 a year.
Sorry, but I can't imagine they have much take-up of that at all, except for testing / experiments / copyright infringement.
...this earthy smell, I do like it!
"smooth RAC cluster installation". That would make a pleasant change.
No, it's $200/year for a personal licence if you're going to use it commercially. If you're just creating a DB to categorize the porn on your PC and don't ever plan on making money or exposing it in a commercial sense it's free to use.
Any company considering systems (Oracle sells hardware, OS, database, back end, middleware and front end) doesn't have to pay first and hope later. Developers can and do build full turnkey solutions at zero speculation cost. Try that with DB2 or MS Foxbase Pro. Try it with SAP (for that manner, try getting SAP to run on Flash.free Apple). Can you imagine it now? This is the same thing as Apple, Microsoft, Adobe, Autodesk and the rest giving freebies to schools and deep-discounting for students.
Oracle uses a tiered system for licensing and the prices are usually depended on what features you need for your business. I've installed and use Oracle DB for personal use. It was mostly a training excise, but I use it to keep track of my beer brewing recipes, cost of supplies, quality checks, temperature, specific gravity, alcohol by volume, taste, etc... I could have used MySQL, but I wanted to learn and practice with Oracle because that's the industry standard for large database applications.
I'm not a shill promoting Oracle, MySQL and SQLServer are all great products. I haven't used MariaDB yet, but I like to play around with the technologies. Oracle is a great product if you have a need for large database applications. It's management are still a bunch of asshats; it sucks that business people get in the way of and ruin great technologies.
In education they like to send you a quote for a unreasonable amount of money with stupid discounts.
I think our quote was a few million for the license with 98.5% discount.
Its right beside the dislike button.
The correct one:
http://msdn.microsoft.com/en-us/library/windows/desktop/aa384649(v=vs.85).aspx
For a list of in-box (Windows' own internal VSS writers that ensure disk consistency) see here: http://msdn.microsoft.com/en-us/library/windows/desktop/bb968827(v=vs.85).aspx
Oracle is an external VSS writer. Has supported VSS for many years.
Reading slashdot one-liner: (irm http://rss.slashdot.org/Slashdot/slashdot).rdf.item | fl title,desc*
99% of database users have no need at all to give money to One Rich Asshole Called Larry Ellison.
Yes, there are a tiny handful of applications where Oracle outshines the alternatives. Yours probably isn't one of them. If you're running a small website, MySQL/MariaDB will almost certainly work just fine. (Or the free version of MS SQL Server, if you're developing in ASP.NET.) For larger applications, PostgreSQL can do the vast majority of what Oracle can do at no cost. If you're not working with absolutely massive datasets, and don't need the specific enterprise features the system offers, Oracle is probably a waste of your money.
Too many companies throw their money away just because it's "standard", even though it really isn't – other databases are more widely used as well as being cheaper and easier to administer. Anyone who wants to buy Oracle should have to justify with clear and specific reasons (not just marketing buzzwords) why they need it and how the massive expense is going to benefit the company compared to the alternatives.
The syntax is:
alter database recover datafile '/path/to/restored/file.dat';
alter datafile '/path/to/restored/file.dat' online;
I used that on an Oracle 7 database about 2 months ago.
A processor license for Oracle Enterprise database is $47,500.
http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf
Currently, this lets you run on a dual-core x86, or a single core RISC/Itanium. The SPARC Niagra line had some real discount wierdness, since they present 64 cores to the OS.
PostgreSQL can do the vast majority of what Oracle can do at no cost
And PG year after year is much, MUCH easier to install,backup,and maintain.
No, it's not free for personal use. It's free for single person development / prototype use.
There is a personal edition for production use, pricing at USD460 + around 20% per year for support.
I am.... I have a 2 node RAC cluster running at home for fun. Only 1 app using right now, but it is for personal use.
Developers can and do build full turnkey solutions at zero speculation cost. Try that with DB2 or MS Foxbase Pro.
DB2 Express is free, to allow developers to experiment and build up solutions with zero cost. Last time I looked, it was also the most deployed commercial database solution in the Amazon EC2 cloud. From there, it's up to you whether you want to head down the High Availability routes via HADR or pureScale, or the shared-nothing infrastructure of DPF. Or stay with Express if it meets your needs.
P.S. Standard disclaimer: I work for IBM
Anything I post is strictly my own thoughts and doesn't necessarily have anything to do with the opinions of IBM.
People use Oracle because either they use something that depends on it (some other Oracle product, like their ERP, which has some value for certain high end segments of retail), or because they're extremely high end, where a support contract and the license cost is irrelevent compared to a very specific feature they need.
Its niche, but its a big buck niche with enough customers to prevent Oracle from dying...
Now there's all the medium sized companies that got suckered into using Oracle for no good reason. I feel for them.
I could have used MySQL, but I wanted to learn and practice with Oracle because that's the industry standard for large database applications.
QED.
Finally had enough. Come see us over at https://soylentnews.org/
I read it as "Oracle Database : price 12 cents".
You'd get two for a quarter and a penny change!
Don't blame me, it's usually 2 in the morning when I post