Data Management

Top 6 Features of Oracle Database 12c

 Oracle Database 12c gives you a lot of new features and enhancements, making it easy for you to consider upgrading.

Exciting things are in store for users of Oracle Database 12c.  It simply makes it easier for you to be on the cloud.

But what are the top features of this new Oracle product? Read on and be amazed!

1.     Duplicate indexes are now allowed.  With the previous editions of Oracle Database, creating duplicate indexes leads to an error.  Now duplicate indexes are possible, allowing you to create both b-tree and bitmap indexes in the same column, for instance.

2.     Pluggable databases.  Talk about portability.  With pluggable databases, you can create container databases that will have all the data you need, then create a pluggable database that you can later unplug and place in another container database.  The pluggable database is functional and usable in just seconds!

3.     PL/SQL Security.  The new Database 12c also helps make PL/SQL procedures design and code development for Oracle databases easier and more secure.  Now you can assign a role to a certain code unit, allowing you to know who can access that unit of code.

4.     Concurrent execution of union branches.  It used to be that union queries were executed one after the other.  Now it is possible for Oracle to execute union queries at the same time.  This could help lessen the amount of wait time as well as improve your SQL elapsed time.

5.     Global Data Services.  Instead of just balancing the workload of different instances, Oracle Database 12c can now work among different databases with Global Data Services.  It can also help you direct applications to a database that can best serve it using Global Data Listener, thus giving you more availability.  This is because instead of letting the connection fail, it will be redirected to another database.

6.     New Recovery Manager.  The new RMAN can make it easier to restore a single table.  Instead of using a tablespace restore, you can now just use RMAN.  Oracle has enhanced this so that RMAN now supports native compression even during active duplication, helping you clone databases effortlessly.

Notable minor enhancements in Database 12c:

  • Database 12c supports IPv6, an important move since IPv4 addresses are fast becoming exhausted.
  • Parallel upgrades are now possible with Database 12c, allowing to roll upgrades out without any downtime.
  • Store passwords in automatic storage management, allowing you to execute grants in only one instance.

Oracle Database 12c gives you a lot of new features and enhancements, making it easy for you to consider upgrading. These new features enable you to easily manage a cloud database as well as give you the chance to enhance resource utilization.

Be sure to take advantage of these with Four Cornerstone’s help.  Either with Database 12c or earlier iterations, Four Cornerstone can help you with:

  • Data warehouse and data-mart schema design & ETL developments
  • Database logical area work
  • Relational schema & entity design
  • SQL design and code development for MySQL databases
  • Transaction SQL design & code development for MS-SQL Servers

Contact Four Cornerstone today and experience the benefits that you can only get from Oracle Database 12c without having to wait!

Uncategorized

Performance Boost in MySQL 8.0.35…

Oracle has recently published interesting performance numbers that show MySQL 8.0.35 Enterprise Edition about 25%, or higher, faster than MySQL Community Edition.   A great...

Keep Reading

Uncategorized

Security Trends For 2024: SBOMs

A recent article on Forbes, linked below, lists five security trends that are likely to be important in 2024. Of course, AI-related security topics top...

Keep Reading

Uncategorized

Getting started with your first…

Anyone looking at writing their first Generative AI application should read this to save time. In June 2023, Google Cloud published a useful blog post,...

Keep Reading

Uncategorized

Read-Write and Read-Only query splitting…

Optimize the usage of the standby (secondary) read-only MySQL InnoDB Cluster servers by automatically and transparently distributing read-queries to them. A great feature in MySQL...

Keep Reading

Uncategorized

Considering Cloud Diversification?

Moving an enterprise to a Public Cloud can quickly feel like moving into a locked-in relationship with the Cloud vendor. One solution to diminish this...

Keep Reading

Uncategorized

Gartner: Global cloud consumption will…

Gartner forecasts that 2024 will see a 20% global cloud consumption increase from 2023 to $679B, while 2023 has seen an 18% increase from 2022...

Keep Reading

Uncategorized

ByteDance: Use AI for tuning…

ZDNet is reporting that a ByteDance (the maker of TikTok) Linux kernel developer has proposed to implement AI to tune the performance of Linux systems...

Keep Reading

AI Governance

What is AI TRiSM?

If reading now about AI TRiSM for the first time, it might be good read on and learn what it’s about because it leads the...

Keep Reading

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Live Chat | Emergency