IssueRaiser

Oracle: Doesn't scale down.

Oracle: Doesn't scale down. Lacks a lot of convenience features (BOOLEAN, DATE, IF (NOT) EXISTS, …). You need a team of DBAs to manage it and have a good relationship them (send birthday cards for their kids, I'm not making this up). You need to have people on your team with a good understanding of Oracle. Then the speed and information you can get out of it is amazing — given your corporate structure gives you access to a good disk subsystem. Support is a waste of time (we have a priority 1 bug open for more than half a year). 11.1g was so buggy that your DBAs would forbid us to go to 12.1c (BETWEEN AND wasn't working correctly). I just wish they would open source their JDBC driver and accept pull requests. Scale: about 10 TB, tables with between 500M and 1.5B rows, slow disk subsystem (SAN with about 150k IOP/s)

Posted by needusername on Jun 12, 2015, 1:02 PM

Tags

Related issues

Raise real-world problems, find people facing the same issue, and discuss solutions.6,000 issues0 comments

reliability (Other)

Oracle: Doesn't scale down.

needusernameJun 12, 2015, 1:02 PM

Oracle: Doesn't scale down. Lacks a lot of convenience features (BOOLEAN, DATE, IF (NOT) EXISTS, …). You need a team of DBAs to manage it and have a good relationship them (send birthday cards for their kids, I'm not making this up). You need to have people on your team with a good understanding of Oracle. Then the speed and information you can get out of it is amazing — given your corporate structure gives you access to a good disk subsystem. Support is a waste of time (we have a priority 1 bug open for more than half a year). 11.1g was so buggy that your DBAs would forbid us to go to 12.1c (BETWEEN AND wasn't working correctly). I just wish they would open source their JDBC driver and accept pull requests. Scale: about 10 TB, tables with between 500M and 1.5B rows, slow disk subsystem (SAN with about 150k IOP/s)

Comments (0)

No comments yet. Start the discussion.

Comment on this issue