Database Administration & Monitoring

12cR2: Upgrade by remote clone with TDE in DBaaS

By Franck Pachot . Upgrading from 12.1 to 12.2 is easy in Oracle Public Cloud DBaaS because you are in multitenant. Here is how to clone a 12.1 PDB to 12.2 service.

12cR2: Upgrade by remote clone – workaround ORA-17630 in DBaaS

By Franck Pachot . Easier than unplug/plug, you can move pluggable databases with remote cloning. It's the same idea but you don't have to manage the files yourself: the are shipped through database link. However, this uses the 'remote file(…)

12cR2: How long to upgrade a PDB?

By Franck Pachot . In the previous post I described how simple it is to unplug a PDB and plug it into a newer version CDB. One goal of dictionary separation in the multitenant architecture is(…)

12cR2: Upgrade by unplug/plug in the Oracle Cloud Service

By Franck Pachot . 12.2 is available in the Oracle Public Cloud DBaaS. If you have a 12.1 DBaaS service, there's no button to upgrade it. I'll describe all the possible upgrade procedures and the first one, and the most(…)

First installation of SQL Server on Linux REHL 7.2

As you certainly know Microsoft announced yesterday the first preview of SQL Server vNext on Linux. Obviously we are far from a final version suitable for production and the list of unsupported features will probably be good indicator of the(…)

SQL Server 2016 SP1 and unlocked enterprise features!

Starting with the release of SQL Server 2016 SP1, you will probably notice that the standard edition will benefit from a lot of features previously available only on Enterprise edition. Such features concern different areas as performance,(…)

Run SQL Server everywhere!

Running SQL Server everywhere is not a dream anymore!  Microsoft has just announced the first release of SQL Server CTP1 on Linux today! But that’s not all! SQL Server Vnext is also available on Windows,(…)

12cR2: CREATE_FILE_DEST for PDB isolation

By Franck Pachot . Two years ago I filled an OTN idea to 'Constrain PDB datafiles into specific directory' and made it an enhancement request for 12c Release 2. When you provision a PDB, the PDB(…)

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:(…)

12cR2 new index usage tracking

By Franck Pachot . A common question is: how to know which indexes are not used, so that I can drop them. If you tried to use index monitoring you probably have seen the limits of it which make it(…)