Oracle Database

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.

Backup and recovery

Performance

New features

Patch management

Upgrade process

Patch management

Support

Documentation

Resource management, balanced out of the box or controlled with features.

Improved data protection with PDB separation of content.

Easy movement of content.

GUI to manage users across PDBs but not Common Users.

Ability to identify parameters to sync across the PBDs.

GUI to compare resource balance.

Performance / it is fast.

Very reliable.

We are using active data guard / and running reporting against DR minimizing the load on production.

Be able to have multiple masters across DC's right now when we switch to DR there is a 5 minute downtime, we would also want to be able to split our load between 2 DC.

Adaptive Plans - very nice.

Ability to do pluggable databases if desired.

I like the D&T Pack of OEM

Allow Developers better access to OEM.

Agent solution of OEM can cause slowdowns.

Oracle rarely has issues or unplanned downtime. I have come across some bugs with older versions of Oracle, but these are usually related to false error reporting and are well documented.

Oracle has good and reliable performance. The design of separating the undo and the redo logs makes it so that we never have the issues of an uncommitted transaction filling up the redo and halting the database.

Oracle has good documentation available on their website. The Oracle support portal is usually the best place to get information when troubleshooting a problem.

Oracle does not integrate well with Microsoft Active Directory. From my understanding, in order to connect using LDAP, or integrate Active Directory users, we need to use Oracle's own LDAP product. I may be mistaken on this, but we have always resorted to using tnsnames and local Oracle users, because it doesn't seem easy to integrate with AD.

Some of the documentation is too wordy. Though I appreciate complete documentation, sometimes information is repeated. For example the RMAN documentation has overviews then the full content, so when I was trying to learn about it by reading through the whole document, I felt like it could have saved time for me if information was more concise.

Oracle patchset updates are somewhat tedious to install, which is why we don't do them that often. You need to make sure the OPatch software is updated, then you need to install the binaries, then run an update script on the database.

Upgrade: Oracle 12c allowed us to upgrade 45 databases with no issues from 11.2 to 12.2 using DBUA.

RAC: We were able to implement two 4 nodes Oracle 12c RACs on linux. The implementation was straight forward and similar to Oracle 11 but with fewer issues.

Multitenant: Oracle 12c multitenant feature will allow us to run many more databases on the same hardware.

After upgrading to 12.2 we started receiving many ORA 600s. The fix was required us to reorg the offending table/indexes.

Fast

Convenient

Crazy good

No issues.

I wish it indicated when network is slow.

Missing UI to write complex queries.

Active-active data accessibility

Autonomous patching

Almost zero down-time

Built-in replication features for disaster sides should be considered for new releases.

For storing and processing spatial information

For storing and processing sensory data. This provides scoring of driving quality and obeying the driving rules set by the user company.

Providing back tracking reports for the user companies.

It is very expensive to maintain and operate.

Performance

Ease of maintenance

Up time

Monitoring

Easy communication with support

Cost

Oracle database is very fast and efficient, battle tested and has been in the industry for a long time, meaning they have a good understanding of the markets demands.

Security plays a major role. It ensures that data is not tampered with through prompt updates.

It is hard to administrate and critical for the business if it does get down, works perfectly with AIX and can be boosted with powerha or Oracle Rac. It's important to be with Oracle because you have big support and the liability that the database will always improving their performance.

Oracle is one of the biggest and more stable databases, but it's a kind hard to learn how to use it and administrate it. It becomes involved with many library's and files on the operating systems so you will have to have a good knowledge of Oracle and the OS.

The new oracle 12c is always getting updates and patches for improve their functionality and security, it can be used for little, middle, big and very big databases, if you are looking for a new implementation or migrating to Oracle is worth it, it is a little hard to understand and get knowledge, but after you got it, you will have speed on the queries and security of your data.

It's quite stable, as it has been around for such a long time, and that too for obvious reason because it's good, and reliable.

It works well with many different products, and easy to integrate with new and upcoming products, along with old legacy products which definitely only work with Oracle.

Lots and lots of support and documentation for it, out in the world, easy to get help.

Not the best documentation. Like I said, there is tons and tons of documentation for it, so its only easy when you know what you are looking for. It's hard to browse through to get a simple solution.

Too expensive, and not affordable but all companies such as start ups, as licensing and support both are way too expensive.

Initial setup/config takes way too long. Even when you know what you're doing, it still takes multiple hours.

Automatic Memory Management - Optimize use of Memory

Automatic Statistics Collection - Reduce the hardship of writing jobs to collect stats

Runtime Stats - Perform Optimized execution plans

PDB Cloning with custom objects - Benefit enterprise to deploy standard accounts and schemas

Rolling OJVM Patching - to eliminate complete outages

System Enqueue Latch Management - Avoids outages

Availability

Ability to handle hybrid workloads

Great support

Cost

Ease of upgrades

Service request response

We have data guard running to keep our standby databases current as a failover for our production environments. This setup runs very smooth and strengthens our confidence that the systems will be available even in the event of an outage.

The performance of Oracle Database 12c for the processing of data and reporting is fast in all of our environments across the board from small to very large.

Would like to see improvements in the area of reclaiming free space in the table spaces after a purge of data or large delete.

Proven Technology. Market Leader.

Easy to manage, install, upgrade, and migrate

Many solutions for high availability

Cost factor is bit too expensive compare to other RDBMS solutions

Support needs to improve

After sales support is needed

Very stable

User friendly

Lots of people with knowledge

Blends very well with Java.

Very good service support

It's relational

Performance concerns

Backup concerns

Performance

Upgrades

Multi tenant architecture

Cloud

Sharding

Free in-memory option

Document based

We can use container and pluggable DB.

Can restore a table easily using RMAN.

Online migration of Table Partition or Sub-Partition.

Temporary undo

Just need to improve schema restore using RMAN, like table restore in 12c.

Concepts need to be more detailed

Possible mirroring on Pluggable DB

Ease of upgrade

Performance

Stability

Better patching without taking database down

Additional dynamic parameter changes

ETL speeds have increased with the 12c database.

Queries for large extracts run more efficiently than previous platforms.

Oracle SQL Developer is easy to use and includes important query building tools.

More initialization is required compared to previous database vendors.

Some syntax issues, more training required for end users.

Partitions

Backup and recovery

Performance reporting

Premium support

Auto partition drop is needed

Datapump direct integration with S3

Better archiving features

It's reliable and executes its function without major hiccups and shutdowns

Increases data security, especially the confidential information obtained from clients, and prevents unauthorized access

Integrates well with other Oracle family software, thereby improving the business process agility and outcomes

Sometimes its inhibited by poor internet connections or when there is an internet shutdown

Requires a practitioner who is conversant with Oracle Database software to get the best out of the software

It's reliable and executes its function without major hiccups and shutdowns

Increases data security, especially the confidential information obtained from clients, and prevents unauthorized access

Integrates well with other Oracle family software, thereby improving the business process agility and outcomes

Sometimes its inhibited by poor internet connections or when there is an internet shutdown

Requires a practitioner who is conversant with Oracle Database software to get the best out of the software