Oracle Database Erfahrungen

Develop, create, innovate a database quickly and efficiently is achieved with Oracle DataBase.

Kommentare: Oracle Database is a powerful, flexible and enriched tool with unparalleled coding for database creation at different scales.

Vorteile:

There are many advantages of Oracle Database, I can say that its performance and use of resources for me is of a competent efficiency since it is a multiplatform system. Its data dictionary is extensive giving extraordinary support to the programming language, thanks to the fact that 80% of Oracle's internal codes are the same as those established in the operating system platforms, which allows creating data and tables quickly and easily according to the needs you want to achieve in a company or organization. The Forms, SQLFORMS are very simple and effective for the design of screens, the best of all is that, after defining the form you can work on it without generating codes, this at user level is very useful. It can be used both for personal information and for large data stores. is run in high and low range equipment, this is a great advantage. As I said at the beginning there are many advantages of Oracle to create a reliable and secure database.

Nachteile:

Just as it has a simple and adaptable interface, it's necessary to have a broad knowledge of programming and creation of tables to take advantage of the entire box of functionality that Oracle has. It's worth it.

Oracle Database: Still a Leader in DBMS and SQL Databases

Kommentare: Great experience using Oracle in academia. Concepts such as SQL tuning and optimization, indexing, cloud integration, ER-Design, SQL injection attacks, ... can be effectively demonstrated to students using this RDBMS.

Vorteile:

Oracle Database has been my number one choice when teaching enterprise application development. Although it is a bit heavy and not that easy to deploy, students can get a lot of advantages learning a highly demanded DBMS platform that really adds a lot on their resume. The SQL concepts are easily tested against the database using the SQL Developer software. Moreover, JDBC drivers allow seamless integrations and very high performance when using Java to connect to the database on the client side, or when relying on the Java Servlets and Java Server Pages middleware on the Application server. Using Oracle with Java based technologies was definitely a very compatible option that simplifies and speeds up the development process.

Nachteile:

As stated, Oracle is not very easy to install and configure by novice developers. It is a bit heavy on low end devices.

Oracle Database - Daily Use

Kommentare: We use Oracle every day throughout our entire company. Customer database maintenance, ordering product, processing payments all happen through Oracle.

Vorteile:

I like that this software is a workhorse and really is capable of everything. I also like that it is customizable to the needs of the company using it.

Nachteile:

It really takes a lot of specific training and experience to get to know this system really well. There are a lot of little caveats and silly rules to follow to get things where they need to be. Once you learn the tricks of the trade it's no problem but it is not intuitive or user-friendly at all.

Oracle Database Review

Kommentare: Overall it is a good database for clients whose applications needs to handle the heavy load of data.

Vorteile:

Oracle database supports PL/SQL which allows user to write complex queries in procedures/functions which relatively gives better performance. Oracle database can be better equipped and scaled for heavy load applications. we have lot of documentation in the internet for oracle database usage. Oracle Drivers(API) are available for all the Programming languages which makes easy to connect database from the code. It has reliable security configuration which makes database administrator life easier. This is platform independent and can be installed in any OS(Windows, Linux ). It supports CSV, Excel and Plain Text files for Uploading. It also supports inbuilt AQ (Advanced queue) which can be used for event based applications.

Nachteile:

Licensing cost is not greatly affordable for smaller size companies. Query performance is slow for tables which has millions of rows unless you optimize(tune) the query. Oracle Customer Service response is not that friendly.

Best Database “Oracle”

Kommentare: I can say that it is the best database when I compare it with other databases.

Vorteile:

To increase the performance, Oracle has some features as partitioning and compression. Also it secure the information with encryption technology.

Nachteile:

Some features have additional license. So if you want to add additional features you pay more.

Review for Oracle Database

Kommentare: The overall experience with the Oracle Database was excellent.
I did my college semester project with it and my final year project has it in it too.

Vorteile:

1. It did almost everything I wanted to did for my semester project and what it wasn't able to do was always added in the next update. A pleasant surprise. 2. PL/SQL was so difficult for me . But still the documentation made it easy. 3. It's core is a relational database, which is a mathematical model and makes it easier for people from science and mathematics background to understand and use.

Nachteile:

1. Felt a bit overwhelming in the first few days of its use. 2. So many features and syntax are prone to be forgotten. 3. Expensive if you want to use a particular or minority of features.

Experience with Oracle Database

Kommentare: We have used it more for the implementation of highly transactional systems.

Vorteile:

You can create a database in which you are controlling all aspects of it, allowing you to better manage the resources you have.

Nachteile:

Database administration can become more complex than it should.

Senior Software Developer - Creating Tables, Triggers and Views

Kommentare: I was having issues getting it to work with Entity Framework as far as retrieving meta data when the database entities were changed.

Vorteile:

The DBMS has many features and they are very efficient.

Nachteile:

The error messages seem a little vague at times and really don't describe the problem.

Oracle database Middleware & Cloud services

Kommentare: By using oracle database, Meterial management and costing is shown on one window.I immediate realize the product cost and price.Handling All productions Operation Due to its middleware services at one place.

Vorteile:

The most important services is middleware, 3-4 madule can connect and generate output as per desired, For Costing point of view, We can connect Meterial Management system & inventory Management system and Billing management system to produce final costing of a product.Secondly its very easy to modify the oracle forms, reports and Formulas.Through multiple languages we can modify Oracle forms.Third its cloud services, for multi-branches organization we can avail its cloud services, from these services we can collect data form every branch at one window. We can cloud partial data for public and complete data for employees based on organization behaviour.

Nachteile:

Complexity is the main issue of oracle data base, Non technical user cannot use it properly.During Development Error Expectation is high due to its Senstivity of character.

Productive Data Managing Platform

Kommentare: The solution gives us an reliable storage option, where all the data is effortlessly managed.

Vorteile:

The establishment of a data back up makes the application reliable and assertive.

Nachteile:

The development of an AI requires some significant upgrade.

Best Enterprise database solution

Kommentare: I have more than 3 years of experience in database industry. In my experience , I can say Oracle database is the best enterprise grade database for any industry. As a service integration company, we always recommend clients to have Oracle databases in their environment. During my career, I have never seen a any data loss incident related to Oracle database. Oracle database has very larger community as well. So it was very easy to troubleshoot issues, even without paid vendor support

Vorteile:

+ Enterprise features such as High availability, Concurrency, Disaster Recovery. + Comprehensive documentation from Oracle. + Best vendor support -paid + Best security features such as encryption, data masking , redaction and auditing + Maximum Availability architecture to provide best protection to our data + Performance monitoring capabilities

Nachteile:

+ Enterprise licence are very costly. + Data Gurad licence sold separately. + Not easy to Install,configure and maintain, need high skilled resources.

User Friendly and Has Cool Tools

Kommentare: Good experience overall. I like how easy it is to search for what I need from this database. This database is pretty convenient once you get used to it. Only problems I have are occasional slowness, but that might be a connection or table design thing.

Vorteile:

It's easy to find all triggers, procs, views, and tables on the left side. There are also great tables like all_tables and all_source that make it easy to search our entire database for the proc or table I'm looking for. There's a super convenient button that changes the case of all code you highlight in the editor, so you can type in the case that's convenient for you and update everything with the button. I also like that you can pin your query results so they don't go away if you re-run the query or run a different one on the same tab. Each set of query results can be named, so you can run, pin, and rename everything you need, and paste your results somewhere when everything is done running.

Nachteile:

There are more slowness problems in this database than in sql server for large tables. I'm not sure if it's due to table design though. I have to be more careful how I write queries here since some of them can run for hours.

Nice tool

Vorteile:

Perhaps the most well tested relational database for large installations. It can handle a huge amount of data and perform well under load Reliability!!! Without a doubt, the Oracle database series (I think it's up to Oracle 12c now) is the `godfather' of commercial transaction and government RDBMS software. With it's different version releases, the software has been around close to 40 years!!! It's the originsl flagship product of the Oracle corporation.

Nachteile:

It's expensive. So, if you don't need to support a lot of data and transactions per second you should seriously consider a cheaper option like MySQL or a nosql database like MongoDB. Installation Time per individual instance!!! I've automated the whole thing from a fresh install of a Linux Operating system and it still takes at least ~3.5 hours to install it, although I've done it in as little as 2.5 hours, but it depends on where the package repository is, and how version control is being handle! (POINT THE MATTER IS, IT CAN TAKE VERY LONG TIME FOR MERE INSTALLATION) On Windows operating systems it can take up to 8 hours or more, your first time around!

Highly reliable database.

Kommentare: This is where I started learning and using databases, that means this was the base of all. I was used to write queries and try those out with oracle.

Vorteile:

Most importantly, this supports various data types like text, binary data and numbers and oracle can handle large amount of data efficiently. Also we can easily integrate it with multiple programming languages where I used it in multiple projects with different languages. This supports data backup and replicas and it make sure the availability of data in an unexpected condition.

Nachteile:

As a drawback what I see is the resource consumption of the tool. It takes lot memory and CPU power and that makes my old laptop slower.

Enterprise level RDBMs; perhaps suitable for enterprises only

Kommentare: Oracle is an old elephant that is recommended for large enterprise systems only. So I am satisfied with its performance in larger projects whereas it is not suitable for smaller projects. I use it only when its really needed. For smaller projects i go for MySQL etc.

Vorteile:

Oracle has the advantages of being a mature and stable RDBMS with a lot of features. Unlike its open-source counterpart MySQL; it has better features for point in time recovery; performance and stability. It makes it suitable for Enterprise level projects where performance is a must alongside stability.

Nachteile:

It's not easy to set up in a test environment and containers. Cloud-based setups for this are much expensive. Secondly, you need a lot of client software for backups and interaction with DBMS. Secondly, it overindulges when its about resources and starves other processes thus needing expensive servers with more resources.

Robust and reliable

Vorteile:

Oracle is a versatile, robust and reliable database. Can be used for a variety of work loads like OLTP and OLAP. Provides options for easy installation and maintenance but can also be tweaked by advanced users.

Nachteile:

License management is complex. If licenses are understood properly and not managed or tracked, it may lead to legal/financial implications.

Excerpt on Oracle Database

Vorteile:

1. Within the Oracle databases, the application can use multiple schemas. 2. Database tables are assigned to table spaces such that their extent size reflects the size of the table 3.Ability to create all functions and procedures inside Packages [No stand Alone Implementation], and those which define the interface of the package to the outside can be declared in the package header 4. By using Dynamic SQL we've replaced bulky queries by input based optimized queries. 5. Using Oracle's 'Advanced Queuing' we implemented Asynchronous calls in the database enabling us to run processes in the background, when a separate process got executed in the foreground.

Nachteile:

These days capabilities like Oracle are being provided by other open source DB's like Postgres etc at a very nominal cost.

Oracle Database Review from an Senior Oracle DBA

Kommentare: I have used oracle for Datawarehouse, transactional systems, golden gate replications, among others. It is the core database of the company I currently work for.

Vorteile:

I have been working as a Database Administrator since 2011, Oracle is by far the best relational database I have used. It works better on unix-like systems, it is very fast, has lots of parameters to tune to your specific needs and it also has a lot of features like partinioning, high availability soluctions like RAC and Dataguard that make this the best database on the market for mission critical systems.

Nachteile:

The online documentation needs improvement, sometimes it is incomplete, there are not enough examples for some features. Customer Support is erratic, sometimes it´s great and sometimes not so much, it depends on the support tech.

Oracle review

Kommentare: I have been using the oracle database since my carrier beginning. It was using to load the transactional data to oracle tables and making the business use cases to perform the improvements.

Vorteile:

I have been working on the data warehouse projects using the oracle as warehouse database. It is easy to understand and loading into the oracle data base. We can create temp tables and backup tables on the fly for business calculations and remove after the data load into target tables. I would recommend to use Oracle database to use for data warehouse projects.

Nachteile:

I feel that if we can add fast export into files Like fast export and multi load processes. We do have this process in oracle using the bulk load too.

Best RDBMS in the market

Kommentare: Oracle RDBMS is a very vast topic, and it has been an adventure for me to explore its features and how it can be used to simplify the business needs of my customers.

Vorteile:

The high availability features like RAC, the replication features like GoldenGate, the different reporting capabilities using views and DBA_ views, the manageability using Oracle Enterprise Manager, all these make it the most loved Database flavor among its customers. Other flavors of databases are dwarfed when compared to its functionality.

Nachteile:

Oracle RDBMS gives too much importance to data consistency, and can sometimes look complex when trying to solve simple recovery issues. That is one reason why some customers are afraid to use this otherwise powerful software.

High security, simple database operations, and advanced functionality

Kommentare: The database software Oracle is incredibly effective and high-performance. The best feature of Oracle is its connection feature, which makes it easy to connect the database to a project and save data from a project in the Oracle database. It also supports a variety of various platforms.

Vorteile:

It's a fantastic database with a wealth of functionality that is optimised, and I am the one that utilised it for a few years before moving to the cloud. Because of Oracle's excellent support and ability to manage complicated IT applications, database operations are straightforward to do and data processing is quick.

Nachteile:

As it's not an open-source database, we will always have to pay up front when putting a small-scale application into place. I experienced no further drawbacks, therefore if at all possible, utilise this.

Reliable DBMS and Data Warehouse Solution!!

Vorteile:

1. Robust Data Backup and recovery Options is the major capability of Oracle2. Flexible to implement or host in both Cloud as well as in on premise.3. In Built Data Movement tools like Export and Import Data Pump, which help is secured Data copy4.Java Support is the key feature that differentiate this from other databases5. Operational Data Stores can be maintained and is so reliable6. Access controls are at a granular level and too secure

Nachteile:

Complex Architecture, Average Customer Support , Price is expensive, not an easy DB for Begineers

Enterprise level Secured RDBMS, with many constraints and features

Vorteile:

Oracle still hold most of the market share for providing enterprise level RDBMS but there was a time when everyone was using Oracle, I learnt about database by using syntax's written in oracle. Easy to use, toad type tools will make your life easier, it will provide you easy graphical interface to write sql codes. sometimes I feel oracle put lots of constraints in their database but that is because you need to maintain a clean and organized database

Nachteile:

length of procedures names has a limitation, it needs to change ,sometimes i try to write descriptive name and it will not allow me

A very reliable database

Kommentare: In my personal opinion, we ourselves have the possibility to mention that this is a great tool that has become quite useful in our organization because its technical support is also one of the best out there and it is quite useful for ourselves and that it is extremely reliable. , scalable and available.

Vorteile:

What I love the most about this tool is that Oracle database is quite efficient and high performance database program. It is also compatible with various different platforms and the best thing about Oracle is the connectivity feature. Besides that we have the possibility to mention that it is also quite flexible and easy to use, which means that it is very useful for ourselves.

Nachteile:

In my personal opinion, we ourselves have the possibility to mention that it is a great tool, in addition, that we have not found a failure in this instrument because we use the Oracle database in order to preserve the entire database of the company. company.

Oracle Database - Still hasn't lost its charm in RDBMS area !

Kommentare: The best traditional RDBMS , May be well suited for transactional database setup.

Vorteile:

The traditional database enables you to configure the data storage and SQL concepts to store the data in efficient way .

Nachteile:

The latest cloud databases in the market and its features are so attractive and easy to use capabilities make us to go away with oracle.