Have enjoyed being an Oracle DBA ...
November 12, 2018
Have enjoyed being an Oracle DBA ...
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database 12c
We have Oracle databases from version 10 to 12. We built an all-new database on version 12, and we plan to upgrade 11 to 12. We use Oracle databases for PeopleSoft, Hyperion, and database warehouses.
- Restore a single table through RMAN
- Data redaction is a security feature we have been waiting to implement in our non-production environments
- 'Generated as identity' column saves the effort of creating a trigger to track the sequence
- JSON support is what the developers enjoy here in IT
- The STATS of tables was off once a while, which caused performance degradation. I wish the auto STATS job can acquire more accurate table stats
- Recommended SQL profile made performance even worse sometimes. I haven't got a chance to try it on Oracle 12c, maybe it works better now. We'll see.
- I wish Oracle patching could be made easier. We have too many DBs and servers.
- Oracle delivers what it promises in functions and performance. We have enjoyed using it
- Cost is always an issue. If cheaper DBs can provide what we need, they will be considered.
- Some applications require Oracle to run at the backend. SAS is becoming a popular model where we don't have to care about the backend database.
1. The commercial application required an Oracle database running at the back end
2. Existing Oracle expertise makes it easy to manage an Oracle database
3. Confidence in Oracle databases: No need to worry about performance, scalability.
2. Existing Oracle expertise makes it easy to manage an Oracle database
3. Confidence in Oracle databases: No need to worry about performance, scalability.