Limitations of mysql in Comparison with Oracle

* Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
* Large Database size is supported more in Oracle in contrast to MySql.