Cloud

Am I a DBA 3.0 or just an SQL*DBA?

By Franck Pachot . There are currently a lot of new buzz words and re-namings which suggest that our DBA role is changing, most of them escorted with a #cloud hashtag. Oracle Technology Network is now called Oracle Developer Community.

Oracle Cloud: script to stop all PaaS services

By Franck Pachot . With metered cloud services, keeping all your instances running may become expensive. The goal is to start them only when you need them. Here is a script that stops all instances you have on the Oracle(…)

APEX Connect 2017 – Day 3

For the last conference day, after the Keynote about “JavaScript: The next Language YOU should learn” by Dan McGhan , I decided to attend presentations on following topics: – Upgrade your APEX app with zero downtime by using EBR(…)

Google Cloud Platform instances and Oracle Database

By Franck Pachot . When it comes to choose a cloud instance to run Oracle Database, you want to be able to run your workload on the minimum CPU cores. This is why in a previous(…)

Oracle 12cR2, RAC, Cloud, ACFS, PDB thin clones and asmadmin

By Franck Pachot . In the Oracle Public Cloud, fast provisioning gets all its meaning when creating a RAC database service: in one hour you can get an operational highly available multitenant database. You can even create it in Data(…)

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

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

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

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