Infrastructure at your Service

Category Archives: Oracle

Mehdi Bada

Managing Oracle Big Data Cloud – CE with REST API

By | Big Data, Cloud, Oracle | 2 Comments

In this blog post, we will see how to manage Oracle Public Cloud Big Data service Compute Edition with REST API. Scheduling the start/stop/restart of a metered PaaS in the Oracle Cloud can be interesting for managing efficiently the consumption of your cloud credits. We should first have a look at the official documentation so as to understand what the API is composed of. https://docs.oracle.com/en/cloud/paas/big-data-compute-cloud/csbdp/QuickStart.html  Use the following URL composition to get access to REST endpoint: https://region-prefix.oraclecloud.com/resource-path According…

 
Read More
Franck Pachot

Oracle Database Multilingual Engine (MLE)

By | Oracle | No Comments

My ODC appreciation blog post was about Javascript in the database running in the beta of the Oracle Database Multilingual Engine (MLE). Here I’ll detail my first test which is a comparison, in performance, between a package written in Javascript, running in the MLE, and one written and running in PL/SQL.  

 
Read More
Franck Pachot

ODA X7

By | Oracle | 7 Comments

ODA X6-2 So, the ODA X6 End of Life seems to be planned for October, and be careful, as far as I know, this concerns also the storage expansion. The main feedback from the X6-2 series were: not enough cores when consolidating multiple databases in M, L and HA not enough storage on HA when compared with X5-2 Standard Edition on HA would be great for cheaper RAC The position of the ‘Large’ version of…

 
Read More
Mehdi Bada

Oracle Big Data Cloud Service – Compute Edition

By | Cloud, Oracle | 4 Comments

In this blog post, we will see how to create a Big Data cluster through the Oracle Cloud Services. If you want more details about the Oracle Big Data cloud services offering, you can refer to my previous blog Introduction to Oracle Big Data. First, you need to create your trial account through the following link: https://cloud.oracle.com/tryit. Note that, when you create your trial account, all information (phone number, address, credit card…), must be from…

 
Read More
Mehdi Bada

Introduction to Oracle Big Data Services

By | Big Data, Oracle | No Comments

Since few years, Oracle decided to move forward in the Big Data area, as their main competitor. The goal of this blog post is to explain you, how the Oracle Big Data offering is composed. As the Oracle Big Data offering is continuously improving, I’m always open to your feedback Oracle Big Data offering is split in 2 parts: On-Premise Public Cloud Note: It’s important to know, that the 2 main Big Data distribution on…

 
Read More
Franck Pachot

When deterministic function is not

By | Oracle | No Comments

When you declare a function-based index, the function is deterministic, which means that calling it with same arguments will always return the same result. This is required because the indexed values, which are the result of the function, are stored in the index. But what happens if you declare a function deterministic when it is not?  

 
Read More