From a business stand point, the ability to go to market, compliance and business enabling is what matters most. Oracle database has rich functionalities that helped us design a system that meets our business' changing needs. However I was responsible for maintaining service levels. My focus was on how to provide consistent response time and the throughput amidst changing business needs and growing data. Oracle database offers one of the industry's best diagnostic infrastructure that enables expert DBA to know exactly how system behaves under different workload, thus able to proactively prevent any performance bottlenecks or quickly respond to exceptional situation or even be able to predict future performance.
Improvements to My Organization
Databases are usually unknown to business users. The business users draw value by using the system to operate the business processes and making the decision at various stages. Businesses do not expect exceptions in their daily routine from a computerized system. Having said that, consistently performing systems enables businesses to serve the customer in consistent manner.
Room for Improvement
Today we do lots of database consolidations, which means multiple applications reside in the same physical databases using one or more schema. I would like to see some seamless feature to simply drag and drop all the objects belong to one application from one database to another database.
Use of Solution
I have used Oracle database releases from 8i to 11g since 2001. We used it primarily as a database component of Oracle Application 11i. Subsequently we continue to expand the usage to many new application systems including business intelligence and B2B applications.
Oracle databases are the most reliable, accompanied by good documentation and support. We never encountered an issue during the deployment which was due to a product issue.
Any system goes through a phase of stabilizing which takes a fair amount of time. Fortunately, with Oracle database, this time has reduced significantly.
Not in our line of business.
Customer Service and Technical Support
Since 2001, I have enjoyed reliable service from Oracle Support.
We always used Oracle Database. We also have SQL Server databases serving many small-medium scale applications. And they perform better as well. In my experience, SQL server databases offers stable database environment. It is easy to use and quick to learn for new DBAs with same windows UI.
Initial setup was certainly complex, specifically from the application standpoint. We had deployed many new modules that Oracle Application 11i offered in their version 11.5.4. These products had significant impact on database performance. There were also many customizations in the application system. It took us almost 6 months to establish consistently performing system environment.
In Singapore we implemented through Oracle Consulting. They are one of the best in the industry with a huge amount of dedication.
Oracle database is one of the best database systems with largest population of experts around helping the global communities. Hence the knowledgebase is rich and vast. However, workout a strong business case in order to get it approved by the sponsor. As a technology expert, IT function needs clear strategy while selecting one product over another.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Mar 24 2014