Share your experience using Oracle Database

I use WebLogic as a web server for my internal applications, specifically Java-based internal applications. I am using WebLogic server for my applications that are hosted internally, not for the public.

The most valuable features in WebLogic Suite are its stability and security. My application is quite stable on this server. WebLogic has positively impacted my organization as it is a mature product. It is scalable and secure. I can deploy my applications instantly on WebLogic. Another team is also utilizing WebLogic.

RAC is the feature where I can distribute the load among multiple nodes, and it has helped our enterprise applications.

I am not directly involved in the pricing case of WebLogic, as the other team is looking at budgeting and costing. The licensing model is based on cores. It would be more feasible if Oracle allowed licensing on a socket-based model instead of cores.

I have been working with WebLogic Suite for the last six to seven years.

It is a stable product. I did not use any other server in comparison to WebLogic, so from my perspective, it is stable. I would rate it 8 out of 10.

RAC is the feature where I can distribute the load among multiple nodes, and it has helped our enterprise applications.

Oracle's technical support is adequate. I would rate Oracle's technical support about 8 to 9 out of 10. The response time is fine. In some cases, they support me on a 24/7 basis, round the clock.

Positive

As per my knowledge, the previous solutions were adequate.

By using the provisioning of Oracle ExaCC in my infrastructure, it takes half an hour to provision a new database and then plug in a new application.

I did not take part in the implementation of WebLogic in my company. However, I was involved in the deployment from scratch, including the installation, provisioning, deployment, and then management and administration.

Oracle Database is costly. I think it is an expensive product. However, I need the stability and performance when I am deploying applications for the banking sector. I need the performance, security, and reliability. These are the main features, and Oracle is, I believe, number one.

I am not using any cloud product of Oracle except Oracle Cloud at Customer. I am using Oracle Cloud at Customer.

I am still working with Oracle products. I am still using Enterprise Manager 14c. I am using Oracle Database, Oracle ExaCC, Oracle EBS, Oracle WebLogic, Oracle Enterprise Manager, and Oracle Linux. I can answer questions about my experience with WebLogic Suite. I use it in my company. I have not used WebLogic's diagnostic tools. I do not utilize its lifecycle management features. I do not have much experience with WebLogic Java EE support, as I just deploy the application and the other team utilizes this server. I am not directly involved in WebLogic. I have been using Oracle Linux myself. The deployment is local, on-premises. I have been working with Enterprise Manager as well. All the components of Oracle I am using are on-premises. I use Oracle 19c database, Oracle ExaCC, Exadata on Cloud at Customer. I have been using Oracle Linux, Enterprise Manager, and databases as well. I have been working with Oracle Database for about 20 years. My experience has been 100% positive with Oracle Database. I have utilized its Real Application Clusters along with Data Guard. I do not use Oracle's Advanced Analytics and machine learning features right now. I have given this review an overall rating of 9 out of 10.

The purpose of using Oracle Database in my environment is to store data and information related to the business. All kinds of information are stored in the form of tables. Different sets of information are stored in different tables, and they are linked to each other through primary keys or foreign keys. Some information from one table is included in another table in the form of a foreign key, connecting them to each other.

We can create views by combining more than one table so that we have separate information for our purpose and use. For further operations, we also create procedures and triggers. All these features are shown or operated through a Java application from the front end.

Regarding what I value about Oracle Database, as far as execution is concerned, I think it is one of the best databases I have come across. There are other databases such as PostgreSQL, MySQL, MS SQL, and Teradata, but among all, I found that Oracle Database is superior.

Oracle Database has extra features, functions, and statements that make it more flexible. I am familiar with Oracle Database Vault and Oracle Database In-Memory. I have experience creating procedures, queries, functions, triggers, and more as a core developer.

One existing feature that distinguishes Oracle Database from others is its ability to log errors in the database itself. We can directly log the errors, which I have observed and used.

Another improvement could be the ability to predict the actual time required to execute a particular query or procedure. This would be very helpful. If it has already been predicted that a particular query will take a specific amount of time, then there is no point in waiting for execution, especially during testing. For instance, if we are doing improvement or optimization for a particular query, and we are aware that this query will take one hour, we can stop it immediately and do more optimization instead of waiting.

I've been working with Oracle Database for more than 10 years.

Regarding the installation and deployment of Oracle Database, it is straightforward. There are no significant challenges. As core developers, we need to raise a ticket and get permission from higher authorities and management to install any software. The specific IT team handles the installation part on our behalf. We observe the installation process but don't perform it personally as we are not authorized. We are allowed to use only the software, so we can log in to our particular database and start working on it.

The installation of Oracle Database software takes just a few minutes.

I am using Oracle Database and PostgreSQL as my databases.

I have not used Oracle's Real Application Clusters. I have created procedures, but I would be very glad to use that feature. I have not explored Oracle's Advanced Analytics and Machine Learning features.

Oracle Database's cloud integration is quite flexible. Once logged in, functionality depends upon the access granted. With proper access, we can use any feature of Oracle Database.

Oracle Database's multi-tenant architecture is wonderful because once hosted on the cloud, it can be used by numerous users from the same locations and can be divided into multiple databases within one organization. It seems more flexible compared to on-premises installation. However, as I have not been a database administrator, I am not very familiar with organizing and providing access.

Regarding satisfaction with licensing costs for Oracle Database, I am not the right person to comment as these matters are handled by management and not disclosed to subordinates.

On a scale of 1-10, I rate Oracle Database 8.5 out of 10.