Oracle Database and schemas...please help!
-
Haven't worked with Oracle is over a decade, I'm afraid.
-
I guess no one have knowledge on this subject. This is a first. Hmmm.
-
@MrWright4hire said in Oracle Database and schemas...please help!:
I guess no one have knowledge on this subject. This is a first. Hmmm.
Oracle is super rare in the SMB market. Even in the enterprise space I've rare seen it. Where it exists it's primarily legacy stuff that people want to replace. It would be pretty surprising to have much info on it here.
-
Is there any suggestion as to what field of DB is in the now since Oracle is out?
-
It's not that Oracle is out. Loads of enterprises depend on it. It's depressing to support though, because mostly you are on projects that got stuck with it. It's rarely the database that people choose when they have a choice. Even in big finance it was considered the database of last resort. SQL Server, Sybase, PostgreSQL, MySQL/MariaDB, Cassandra and such here all choices first.
-
You need to define your purpose first. Learning database in vacuum is rather random. What is your goal in learning a database.
-
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
-
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
Same as SQL Server in that way.
-
@scottalanmiller said in Oracle Database and schemas...please help!:
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
Same as SQL Server in that way.
But the price is way different. Enterprise base license per unit (sockets * cores per socket * core factor) is $47,500, plus another $10,500 for updates/support.
So for 4 machines with a low core count to save money:
4 servers * 2 sockets per server * 8 cores per socket * 0.5 core factor=32
32*$47,500=$1,520,000
-
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
Same as SQL Server in that way.
But the price is way different. Enterprise base license per unit (sockets * cores per socket * core factor) is $47,500, plus another $10,500 for updates/support.
So for 4 machines with a low core count to save money:
4 servers * 2 sockets per server * 8 cores per socket * 0.5 core factor=32
32*$47,500=$1,520,000
Yeah. That's because no one uses Oracle by choice. Only those that are stuck and have no option. So they can charge anything that they want.
-
@scottalanmiller said in Oracle Database and schemas...please help!:
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
Same as SQL Server in that way.
But the price is way different. Enterprise base license per unit (sockets * cores per socket * core factor) is $47,500, plus another $10,500 for updates/support.
So for 4 machines with a low core count to save money:
4 servers * 2 sockets per server * 8 cores per socket * 0.5 core factor=32
32*$47,500=$1,520,000
Yeah. That's because no one uses Oracle by choice. Only those that are stuck and have no option. So they can charge anything that they want.
Ya it's insane. Large systems like that get so entrenched that it's easier to pay the licensing than to leave.
-
I always wondered why DB2 wasn't more popular. The free version offers much more than Oracle and it's easier to work with (at least in my opinion).
edit: more popular than Oracle. It's still really popular. #6 in rankings http://db-engines.com/en/ranking
-
@stacksofplates and @scottalanmiller the ranking still shows Oracle as #1. Somebody has to be spending the money on the product if it's still listed as #1. Am I missing something here?
Scott, the reason why I would like to learn DB is to try a different field. I need to build up my certs on my resume. I'm tired of doing contract work here in Ontario. I want to permanent gig.
So what DB certs do any of you gents suggest to go for? I'm curious as to what your thoughts are. -
@MrWright4hire said in Oracle Database and schemas...please help!:
@stacksofplates and @scottalanmiller the ranking still shows Oracle as #1. Somebody has to be spending the money on the product if it's still listed as #1. Am I missing something here?
What defines number one? It's certainly not the most used. It's nowhere close. How do they collect that data? They don't have access to my info or any other database user that I know. So how do they get that info?
And number one doesn't make something a good career. Are there Oracle DBAs out there? Yes. And there many new ones? No.
-
Number nine DBMS on that list isn't even a DBMS. Seems sketchy.
-
Also MySQL and MariaDB are the same product. Put them together and Oracle isn't on top even in that list.
-
But more importantly than position is change rate. Oracle shows as falling for years. A falling system has incumbent specialists in the field with seniority and experience that you will never get. How do you plan to unseat them when there are fewer and fewer jobs in the field year over year.
-
@scottalanmiller said in Oracle Database and schemas...please help!:
@MrWright4hire said in Oracle Database and schemas...please help!:
@stacksofplates and @scottalanmiller the ranking still shows Oracle as #1. Somebody has to be spending the money on the product if it's still listed as #1. Am I missing something here?
What defines number one? It's certainly not the most used. It's nowhere close. How do they collect that data? They don't have access to my info or any other database user that I know. So how do they get that info?
And number one doesn't make something a good career. Are there Oracle DBAs out there? Yes. And there many new ones? No.
http://db-engines.com/en/ranking_definition
Just general popularity.
-
All I'm hearing are good points as to why Oracle sucks and dying. Nothing about other DB alternatives. I'm open for suggestion. I'm looking on some feedback as to which DB is best to get a cert for. I don't want to get a cert that's turning legacy the day after I received it.
-
@MrWright4hire said in Oracle Database and schemas...please help!:
@stacksofplates and @scottalanmiller the ranking still shows Oracle as #1. Somebody has to be spending the money on the product if it's still listed as #1. Am I missing something here?
Scott, the reason why I would like to learn DB is to try a different field. I need to build up my certs on my resume. I'm tired of doing contract work here in Ontario. I want to permanent gig.
So what DB certs do any of you gents suggest to go for? I'm curious as to what your thoughts are.Big ones are things like Amazon Aurora/Redshift (or any Amazon product), Google Spanner, Sybase, etc.
I don't know if they have DBA's that specialize in things like Elasticsearch and MongoDB. I think it's similarly following the DevOps movement like with SysAdmins.
However, I could be 100% wrong as I'm not a DBA.
