Database Administration & Monitoring 12cR2 real-time materialized view (on query computation) 17.02.2017 by Oracle Team By Franck Pachot . Materialized views is a very old feature (you may remember that it was called snapshots a long time ago). It has all advantages of a view, as you can define any select statement that joins, filters,(…)
Database Administration & Monitoring Oracle 12cR2: AWR views in multitenant 19.12.2016 by Oracle Team By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object(…)
Database Administration & Monitoring 12cR2: Upgrade by remote clone with TDE in DBaaS 23.11.2016 by Oracle Team 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.
Database Administration & Monitoring 12cR2: Upgrade by remote clone – workaround ORA-17630 in DBaaS 20.11.2016 by Oracle Team 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(…)
Database Administration & Monitoring 12cR2: How long to upgrade a PDB? 20.11.2016 by Oracle Team 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(…)
Database Administration & Monitoring 12cR2: Upgrade by unplug/plug in the Oracle Cloud Service 19.11.2016 by Oracle Team 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(…)
Database Administration & Monitoring 12cR2: CREATE_FILE_DEST for PDB isolation 16.11.2016 by Oracle Team 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(…)
Database Administration & Monitoring 12cR2 Single-Tenant: Multitenant Features for All Editions 14.11.2016 by Oracle Team 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:(…)
Database Administration & Monitoring 12cR2 new index usage tracking 13.11.2016 by Oracle Team 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(…)
Database Administration & Monitoring 12cR2 has new SQL*Plus features 11.11.2016 by Oracle Team By Franck Pachot . 12cR2 is there. What's new in SQL*Plus? For sure, you can't expect lot of things from it. The new command line is the SQL*Developer sqlcl which aims to be 100% compatible with SQL*Plus with lot of(…)