Blog

integration and implementation of technology-focused business solutions

April 2017

New Oracle 12c R2 features for on-premise customers

April 22nd, 2017

At LSG Solutions, a key part of our work is anticipating new releases from Oracle and defining how they will help our customers. One such release, Oracle's 12c Release 2 (also known as detailed release 12.2.0.1), is now available for on-premise customers.

Previously only available to cloud customers, this version's new features continue Oracle's commitment to streamlining systems for business.

Here are a few important features included in this release.

Hot Cloning

In this version, there is no need to put the source into read-only for cloning. You can refresh a clone and relocate a PDB. This allows for a smoother software development cycle, as well as more efficient integration and delivery.

Expanded Partitioning

Without impacting current DML operations, 12.2.0.1 allows you to convert non-partitioned tables to partitioned tables online. They can also be set to read-only status to prevent inadvertent DML action.

These expanded partitioning features increase the manageability of various applications and continue to drive down the cost for storing volumes of data.

Vault Simulation Mode Protection

Security continues to be a top priority in this version. Vault simulation mode protection allows customers to test realms and command rules protections without denying access to the user.

Violations are logged on a simulation log file for tracking.

This feature increases efficiencies, which allows you to move new realms and command rules to production more quickly.

Approximate Query Processing

Being able to quickly access accurate information from your database is essential for business agility. This new feature allows approximate results of large volumes of data with little deviation from the exact numbers.

Again, aggregation of data in this manner speeds up processing time and makes better use of resources.

As with every new release, we know you may have questions specific to your business and systems. Please contact us for more information. We can help you plan next steps to support your business.

Comments: None

Will you need to switch to Oracle’s Standard Edition 2?

April 4th, 2017

Effective December 2015, Oracle launched Standard Edition 2 (SE2), intended to replace Standard Edition 1 (SE1).

We’ve recently seen an increase in customers asking questions about upgrading to this version. So, with that in mind, let’s take another look at SE2.

Oracle has always offered a database option for small and medium sized businesses with Oracle Database Standard. When compared to Oracle Enterprise, the cost savings alone made it the obvious choice for targeted users.

Customers using Standard Edition 1 (SE1) should be aware that this version is no longer supported. For customers using other versions, they may be seeing limitations on performance and limited processor capability.

Oracle says that SE2 is:

  • An affordable, full-featured database
  • Built for ease of use, power, and performance
  • Available on servers supporting a maximum of two sockets
  • Optimized for small business
  • Zero-cost license migration from either SE or SE1

SE2 vs. Enterprise Edition

It’s important to understand the differences between Oracle’s two types of databases.

SE2

This version is the small business edition. It is scalable as your business grows. However, you should be aware of possible licensing requirements when changing from one version to another.
Affordability is a hallmark of this version. Prices range from $700 to $17,500. Though it has a maximum support of two sockets, this is typically a good option for small and medium sized businesses.

Enterprise Edition

For those businesses needing greater scalability, Enterprise Edition will be the better choice. This version is available on single and clustered servers. There is no socket limitation.
Cost is a consideration with this version, as prices range from $4,750 to $47,500.

Migrating from SE1 to SE2

As Oracle moves forward with SE2, customers may have questions about migrating from their old edition to the new. Oracle says they expect this to be a seamless process. Though, as with any new database, delays or challenges may arise. It is important to fully understand the transition, and how it will affect your business before the migration.

We at LSG Solutions look forward to speaking with you and working with you through this change. Please contact us with any questions or simply to discuss your options.

Comments: None

CONTACT

501 E. 15th St., Suite 200B
Edmond, OK 73013
(405)285-2500
info@lsgsolutions.com