Database Administration & Monitoring

12cR2 DBCA can create a standby database

By Franck Pachot . Do you like DBCA to create a database from command line, with -silent -createDatabase? On a simple command line you can provision a database, with oratab, tnsnames.ora directory creation and any setting you want. And you(…)

Oracle Public Cloud: LIOPS with 4 OCPU in PaaS

By Franck Pachot . In the latest post I've run a cached SLOB workload on Oracle Cloud IaaS to measure logical reads per seconds on a system covered by 2 processor licences (so 4 OCPs). Just(…)

SQL Server AlwaysOn – Distributed availability groups, read-only with round-robin capabilities

This blog post comes from a very interesting discussion with one of my friends about the read-only capabilities of secondary replicas in the context of distributed availability groups. Initially, distributed availability groups are designed to address(…)

Oracle Public Cloud: 2 OCPU for 1 proc. license

By Franck Pachot . I've blogged recently about the Oracle Core Factor in the Clouds. And then, in order to optimize your Oracle licences, you need to choose the instance type that can run faster on(…)

Oracle 12c – RMAN list failure does not show any failure even if there is one

By William Sescu Relying to much on the RMAN Data Recovery Advisor is not always the best idea. In a lot of situations,  it tells you the right things, however, sometimes it tells you not the optimal things, and sometimes,(…)

Exadata Express Cloud Service: SQL and Optimizer trace

By Franck Pachot . The Oracle PDBaaS is for database developers. And database developers may need to trace what happens with their queries: SQL trace and Optimizer trace. Let's see what we can do on Exadata Express Cloud Service(…)

Oracle – RMAN Backups to CIFS

By William Sescu Not to often, but sometimes you need to offload your RMAN backups and your DataPump exports to CIFS. You might run out of space on your NFS server, or you are a Windows shop who has only(…)

Oracle Public Cloud 12cR2: TDE is not an option

By Franck Pachot . In Oracle Public Cloud, Transparent Data Encryption is not an option. You can use it because it is included in all database services for all editions. You have to use it because the database won't allow(…)

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