Oracle software provides great granularity in setting up the environment as per our needs and requirements. Customizing the solutions based on the problem areas comes with great ease and performance.
Performance issues could be easily found out using the tools like OEM and profiler options. Crontab allows us to make sure that all the jobs are properly schedule.
There isn't much that I dislike with Oracle. It would have been great to have the GUI on the Oracle similar to SQL Server management studio to manage the databases much efficiently and automate lots of stuff more efficiently and faster. Re-inventing the wheel kind of scenarios are some of the examples that we could have eliminated if we would have had a comfortable GUI tool to run on.
It's a great product and perfect fit for the Production environment for Mission-Critical databases.
We are utilizing the Oracle databases as a backend to Support Linkedin.com customer facing website. We have one of the largest GoldenGate implementations at LinkedIn having multi-colo setup. This is setup across 4 Datacenters across the Globe to provide high availability. We also have Active DataGuard setup across all the databases on all the colos to provide read traffic their dedicated instance. Also, having the nodes used for the Database backup and recovery purpose in times of disaster.
We also have the downstream functionality and support to our downstream customers like Teradata, Hadoop and Reporting environments to do near-live analytics of the data and run business critical reporting which goes to the Senior Leadership and Board level for analyzing the company's performance, objectives and goals.
We also have the custom scripting and Audit on top of our existing configuration to support what we already been provided by Oracle.
Automation using shell, perl and python scripts have been of a great deal using Oracle to setup lot of jobs which perform routine DBA tasks.