Standard Edition

Statspack with Oracle Database 19c and Multitenant

Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this(…)

Move a PDB from a server to another one using NFS

Introduction Multitenant brings new possibilities regarding Oracle databases, and one of them is to move a database from a container to another quite easily. When containers are on the same server, it’s very easy, but when the containers are on(…)

Oracle Standard Edition on AWS ☁ socket arithmetic

By Franck Pachot . Note that I’ve written previously about Oracle Standard Edition 2 licensing before but a few rules change. This is written in May 2020. TL;DR: 4 vCPU count for 1 socket and 2 sockets count(…)

Max PDBs in Standard Edition

By Franck Pachot . Here is a small warning. In Standard Edition, you may expect that the features that are not available for your edition are blocked, but in 12.2 you can create more than one PDB in Standard Edition,(…)

12cR2 Single-Tenant: Multitenant Features for All Editions

By Franck Pachot . Now that 12.2 is there, in the Oracle Public Cloud Service, I can share the slides of the presentation I made for Oracle Open World:(…)

Standard Edition 2 testing the 16 thread limitation

By Franck Pachot . From 12.1.0.2 the Standard Edition - now called Standard Edition 2 - has a few limitations that were not there in SE and SE1. One of them is the limitation to 16 threads. Let's see how(…)

You are in Standard Edition, when to worry?

By Franck Pachot . A previous blog post explaining what happens for those in 'Standard Edition One' had a "don't worry" in the title because you can upgrade to SE2 with minimal additional cost - except(…)

Invisible indexes: it’s online in 12c – even in Standard Edition

By Franck Pachot . Do you think that online operations are available only on Enterprise Edition? That changed in 12c, there is an operation that is online (without the need for the ONLINE keyword) and available in Standard Edition and(…)

Oracle Standard Edition Two

By Franck Pachot . Look at the Oracle Download page: Standard Edition is there in 12.1.0.2 - more than one year after the release of the patchset for Enterprise Edition. It's a new name - SE2(…)