Pros
Not many pros. I suppose the benefits are good. Tuition reimbursement was useful. Training opportunities are great if you want to learn Oracle tech and your management allows you to train.
Kontras
Oracle is becoming irrelevant and is grasping to rise back to its heyday but they are doing this with their old tactics of browbeating employees and customers and that's not the way things work anymore. There is a huge internal conflict between the newer OCI teams and legacy Oracle teams that fund the growth in Cloud. This is ripping the company apart. If you spend any serious amount of time here, it will damage your marketability on the open market. Much of the tech is not widely used and is not the latest and greatest. Managers and up do not learn how to manage and direct at a level that other companies are hiring managers (financials, project management, workforce management, etc) There is no real career advancement - titles might change for the better but the role stays the same. There are very few chances for lateral movement and even fewer chances for management promotions - unless you know a VP. Unless you are in OCI, there are limited raises and equity.