Database Administration & Monitoring

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

Database Diagram using SQL Developer

By Mouhamadou Diaw Last Day a client asked me if I can generate a relational diagram for an oracle schema. He was just preparing a migration and wanted to see how tables are organized in the schema. In this(…)

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

Can I do it with PostgreSQL? – 9 – Temporary tables

It has been quite a while since the last posts in this series, so here is what we looked at until now: Can I do it with PostgreSQL? – 1 – Restore points Can(…)

Amazon AWS instances and Oracle database performance

By Franck Pachot . When you run Oracle Database on Amazon AWS you Bring Your Own Licenses depending on the number of virtual cores (which are the number of cores allocated to your vCPUs). Behind the instance types, you have(…)

Introducing high-availability and multi-subnet scenarios with SQL Server on Linux

On my first blog about SQL Server on Linux, I introduced the new high availability feature which concerns only SQL Server failover(…)