Infrastructure at your Service

Cloud Archives - Blog dbi services

Alain Lacour

APEX Connect 2017 – Day 3

By | Development & Performance | No Comments

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 – Understand and make use of CSS(3) – Best Practices for APEX Administrators – APEX Version Control and Team Working – Database Cloud Services with APEX – Date, Time, Calendar and Co with APEX I also…

 
Read More
Franck Pachot

Google Cloud Platform instances and Oracle Database

By | Cloud, Database Administration & Monitoring | No Comments

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 post I measured how many logical reads per seconds can be achieved with a SLOB workload, on AWS which is often the first considered, and will probably do it on Azure in the future. I did the same on the Oracle Cloud which…

 
Read More
Franck Pachot

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

By | Cloud, Database Administration & Monitoring | No Comments

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 Guard for Disaster Recovery. Now, Oracle is pushing ACFS to store the datafiles rather than direct ASM. Especially in multitenant because a great feature is thin cloning: CREATE PLUGGABLE DATABASE AS SNAPSHOT COPY. However, I encountered an error when…

 
Read More
Franck Pachot

Oracle Public Cloud 12cR2: TDE is not an option

By | Cloud, Database Administration & Monitoring | No Comments

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 you to create, or import, non encrypted tablespaces. This is controlled by a new parameter, encrypt_new_tablespaces, which defaults to CLOUD_ONLY;  

 
Read More
Franck Pachot

Exadata Express Cloud Service: MAX_PDB_STORAGE

By | Cloud, Database Administration & Monitoring | No Comments

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 but not the CDB administrator. Here is an example about tablespace creation/deletion, and the kind of problems that may arise with this architecture.  

 
Read More
Franck Pachot

Running SLOB on Exadata Express Cloud Service

By | Database Administration & Monitoring | One Comment

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 but has a PDB_DBA which has nearly all DBA rights, but with some features disabled by lockdown profile. I have no worry about the performance on this service: it is an Exadata X5 half rack bare metal (my guess),…

 
Read More
Franck Pachot

Oracle Core factor and Oracle or non-Oracle Cloud

By | Database Administration & Monitoring | 3 Comments

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 important to know how to count processors. The time where a machine had 1 socket with 1 processor with 1 chip with 1 core running 1 thread is really old past. Today, we have physical machines with multi-core processors,…

 
Read More
Franck Pachot

Exadata Express Cloud Service: PDB_ADMIN privileges

By | Database Administration & Monitoring | No Comments

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 application objects, and is responsible for data integrity and performance. The Exadata Express Cloud Service is the implementation of that: a CDB managed by Oracle and a PDB that you administrate. But the fact that the system is shared,…

 
Read More