Oracle can't pick up third party patches and incorporate them into their proprietary version (for example: patches from MariaDB). They can only incorporate their own changes, and changes that other sign over.
My goal with open sourcing my software are to make the (software) world just a little better, i do that by writing the best software i can and hope that as many people possible use it, if i write the best ftp library in the world and you need a ftp library for your proprietary program i hope you use mine instead of an inferior implementation.
In my world view i do not loss anything by you making a proprietary forks of my work (i still have my version of my work with my license) but you and your users are getting a better product.
If you think that quality is important, but that as important as that is that users should have control over the software they use, as part of the control they should have over their own lives, then I think a copyleft license is a good tool to help achieve that.
There are a lot more examples of this.
On the other hand look at how RMS/FSF talks about LLVM and BSD[2], i am a developer there prefers the MIT license for my software, and for me FSF and GPL are a lot more dangerous then apple and there open source license.
[0] http://www.mysql.com/about/legal/licensing/oem/#4 [1] http://doc.qt.io/qt-5/licensing.html [2] https://lwn.net/Articles/582242/