tag:blogger.com,1999:blog-7849367040589270673.post9070715460279626989..comments2024-03-21T22:50:39.997-07:00Comments on Obsessed with Oracle PL/SQL: 12.2 Helps You Manage Persistent Code Base w/New Deprecate PragmaSteven Feuersteinhttp://www.blogger.com/profile/18405765731886460622noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7849367040589270673.post-92106120848588497472016-12-09T07:03:00.238-08:002016-12-09T07:03:00.238-08:00Erwin, I am optimistic that a number of the concer...Erwin, I am optimistic that a number of the concerns you raised in your second post will be addressed with our cloud services. They do (Exadata Express) and will (future, fully matured DB services) offer lower price points and remove the need to pick and choose among options.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-88259768049793372052016-12-09T06:34:47.238-08:002016-12-09T06:34:47.238-08:00And that brings me to another important concern wi...And that brings me to another important concern with Oracle. Oracle simply is TOO expensive! You said it yourself, Exadata is wonderful, but it will cost you an arm and a leg. For years we've begged management for it, but it was deemed way too expensive. For years and years Oracle's pricing strategy worked. People complained and you spent tons on licensing, but in the end the database did its job, we were more or less happy and we paid. But times are changing, demands are changing. Could you imagine the licensing nightmare if you frequently had to double your CPU's? As a result, in a time were "data lake" is a new hype word, I see our managers and architects (it's not as if you've much say in the matter as a developer or even a DBA) moving to other solutions. Are those solutions really less expensive? I'm actually not that convinced, but it seems like it at first glance and the fact is it's often easier (read less expensive) to scale according to your needs. They now prefer pushing their data to Hadoop in Amazon AWS where queries are replaced by scala and spark functions, for example. Of course, you'll still need a relational database every now and then. But even there I see Oracle losing ground. After all, you can run Postgresql and other opensource or at least much cheaper alternatives in AWS as well. Let's be clear, these are not my decisions and as an Oracle professional with 15+ years experience I'm still convinced that it's a wonderful product that technically can answer most of our demands. But I can't argue with the pricing point. Oracle 12.1 brought us some wonderful new things such as In-Memory Column Store and the great pluggable database architecture. But both of these are extra licensing options, even for enterprise users, and as such of very little use to us. It's downright scandalous that you still have to pay for partitioning up till today. I'm convinced there will always be some business and security critical companies for which money is no issue that will have no problem spending all this money on the best Oracle has to offer. But those are a minority. And if Oracle wants to keep most of their other customers in the long term, they will have to drastically review their pricing and licensing strategies. And to come back to the reason for this reply, Exadata Express in the cloud seems to be a first step in that direction. But I'm afraid it's too little, too late. It will take more, much more to convince my managers and architects and make them turn back to Oracle.<br /><br />Kind regards,<br /><br />Erwin<br /><br />Part 2/2Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-53820216240579941092016-12-09T06:34:23.840-08:002016-12-09T06:34:23.840-08:00Hello Iudith,
You certainly have a point and I sh...Hello Iudith,<br /><br />You certainly have a point and I share a lot of your concerns. But I think Oracle had very little choice. For too long, Oracle didn't really believe in the whole Cloud concept (they were making way too much money with their on-premise licenses). And to be honest, I'm still not convinced myself that it's such a good idea in the end (security, privacy, liability, provider dependency, internet dependency etc...). The future will show us. But the fact is that a large number of (potential) customers are making the move. I see it in my company as well. And Oracle is running behind, as competitors such as Amazon, Google and Microsoft started years ago and have a serious head start. There are several reasons why companies decide to move to the cloud. One of the reasons of course is less maintenance and administration. But there's more. One of the main reasons my company is making the move, is scalability. Analytics and big data (I hate that name as it means everything and nothing) have become increasingly important over the last couple of years. I also notice people are using it for goals it's actually not meant for. But the fact remains that data volumes and more importantly, processing needs can quickly grow, business cases and usage also change much more frequently. I also notice that we've become lazy in our designs. We no longer try to model our data warehouse specifically to fulfill users' demands as performantly as possible, as those demands can change from week to week and even the users of the data frequently change and they often have different needs. One day your 8 CPU's might be fine, but a month later you might need double that amount. <br /><br />Part 1/2Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-62625921420176384762016-10-22T05:14:31.712-07:002016-10-22T05:14:31.712-07:00Hello Steven,
Maybe using the cloud might have a s...Hello Steven,<br />Maybe using the cloud might have a strong appeal on those who<br />are considering their first adopting of an Oracle project,<br />and maybe up to now they found administering a database by themselves as being too demanding ... anyway for a production database.<br />But, at least from my own experience, very big applications usually also have a very complex infrastructure around them,<br />considering all the elements and not just the database alone.<br />So, migrating such an application to the Cloud is by itself<br />not a small project at all.<br />Life would be too easy if they could just "plug out" the database from its current place and plug it in into the Cloud,<br />leaving everything else "as is" ...<br /><br />I am not a security specialist, but I guess than just dealing<br />with the possible security issues in such a context is just another big project by itself ...<br />and as far as I am aware, everybody today is "security minded"<br />more than ever ...<br /><br />I personally would enjoy having a toy database of my own,<br />managed completely for me by others, just readily put under my fingers ... of course, without the limitations of a LiveSQL-like toy ...<br /><br />But, maybe, the day will come ... one can never know ...<br /><br />And then ALL the professional (and expensive !) DBA-s will be considered useless, just like developers already are in so many places ...<br /><br />Thanks a lot & Best Regards,<br />Iudith<br />iudithhttps://www.blogger.com/profile/04905902445036068357noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-27419404954987719302016-10-17T07:21:06.968-07:002016-10-17T07:21:06.968-07:00I suggest that you should look at this situation (...I suggest that you should look at this situation (first and currently only release of 12.2 on the cloud, later "on-premise") very differently: getting 12.2 out on Exadata Express is accelerating the process and time by which 12.2 will be generally available.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-20315314991671369892016-10-17T07:15:37.812-07:002016-10-17T07:15:37.812-07:00Hello Steven,
Nice 12cR2 feature indeed :)
Howev...Hello Steven,<br /><br />Nice 12cR2 feature indeed :)<br /><br />However, if you already mentioned the "musical" name "ADEECS" ...<br />From some web posts I understood that by now Oracle<br />only offers version 12cR2 on the Cloud ...<br />I think that this will simply cause a very high delay in adopting it ... especially considering the fact that big customers generally move very slowly, while the not so big ones probably haven't even invested in Exadata, which is not a cheap toy, as we know ...<br /><br />So, except for the customers who are always running fast<br />and whose only concern is to be on the top of the technology,<br />the others will wait patiently for 12cR2 to "descend from the Cloud back to the Earth" ... if this will even ever happen at all ...<br /><br />Thanks a lot & Best Regards,<br />Iudith<br /><br /><br /><br />iudithhttps://www.blogger.com/profile/04905902445036068357noreply@blogger.com