Oracle

CBO parse time – matching time with transformation

By Franck Pachot . By a strange coincidence, I've encountered several cases of long parse time recently. That was the occasion to give a closer look at a CBO trace enhancement that came with April 2016 PSU: Bug 16923858 Diagnostic(…)

Exadata Express Cloud Service: MAX_PDB_STORAGE

By Franck Pachot . The separation of roles between system DBA and application DBA is the way to go for agile development and the PDBaaS managed service is an excellent way to play with this concept: You are PDB administrator(…)

Running SLOB on Exadata Express Cloud Service

By Franck Pachot . The Exadata Express Cloud Service is a managed PDBaaS: Oracle is the system admin and the CDB database administrator, you are the PDB administrator. You connect with a local user, PDB_ADMIN, which is no SYSDBA privilege(…)

Oracle Core factor and Oracle or non-Oracle Cloud

By Franck Pachot . Oracle Database licensing can be based on two metrics: Processor or Named User Plus (NUP). NUP also necessitate to count the processors because there is a minimum number of NUP per processor. Then it is very(…)

Exadata Express Cloud Service: PDB_ADMIN privileges

By Franck Pachot . I usually explain that the main point about Multitenant Architecture is the separation of roles between a system DBA who manages the container, and is responsible for its availability, and application DBA who owns all the(…)

NLS defaults for LANGUAGE and TERRITORY

By Franck Pachot . When you set NLS_LANGUAGE then the values of NLS_DATE_LANGUAGE and NLS_SORT are set to their defaults for the LANGUAGE you set. When you set NLS_TERRITORY then values of NLS_DATE_FORMAT, NLS_NUMERIC_CHARACTERS, NLS_CURRENCY and NLS_ISO_CURRENCY are set to(…)

IT-Tage 2016 Informatik aktuell: feedback

Today, to finish the year, I post a brief personal impression of the IT-Tage 2016 in Frankfurt at the Hotel Maritim, where I was also be a speaker. I presented 2 sessions on SQL Server: “SQL Server Errorlog(…)

RMAN> TRANSPORT TABLESPACE

By Franck Pachot . In a previous post I explained how to use transportable tablespace from a standby database. Here I'm showing an alternative where you can transport from a backup instead of a standby database.

Oracle Database 12c Release 2 Multitenant (Oracle Press)

By Franck Pachot . Here it is. The multitenant book is out for sale...

Upgrade to Enterprise Manager 13.2

I will describe how to upgrade Enterprise Manager 13.1.0.0 to the new 13.2.0.0 version. At the beginning we have to ensure that we applied the latest PSU on the repository database. It is mandatory to apply the following patch before(…)