By Franck Pachot . This post is not about technical limitations: Oracle Database is supported in most hypervisors (certified or not) so anybody can provide a DBaaS through a virtual machine as long as it run a supported OS, has enough CPU, memory, and storage, and open the required ports to access to the database (ssh and listener). But you…
By Franck Pachot . You don’t need good performance only for your system. You need reliable performance. You need performance predictability. In a previous post I’ve measured physical IO performances of the Oracle Cloud Service, with SLOB. And performance is very good. And I continue to run the following SLOB configuration: UPDATE_PCT=25 RUN_TIME=3600 WORK_LOOP=100000 SCALE=90000M WORK_UNIT=64 REDO_STRESS=LITE LOAD_PARALLEL_DEGREE=4 This is…
By Franck Pachot . We experienced the first planned outage this week-end, so let’s see how it is notified and what happens. EMEA Commercial 2 – Amsterdam Outage notification before: subject: Announcement: Upcoming Mandatory Maintenance for Oracle Cloud e-mail date: 16 Octobre 2015 1:49 message: Start Time / End Time: Saturday, October 17, 2015 9:00:00 PM CEST – Sunday, October…
By Franck Pachot . In previous posts, I’ve installed SLOB on the Cloud Services, measured IOPS and CPU. There’s another resource that is even more important in a cloud environment: network. Tuneling port 1521 over ssh I’ve create a virtual instance by default where only ssh is opened: I don’t want to open other port, so I’m using it with…
By Franck Pachot . In the previous blog post I’ve measured the physical i/o performance, with SLOB. We can run the same with a small size of data and a large buffer cache in order to measure logical reads (LIOs) and CPU performance. What is an OCPU? Except if you are licensed in NUP, you are already used to pay…
By Franck Pachot . Having a database in the cloud is very nice. You add storage with a few clicks. You don’t have to think about the storage type (DAS, SAN, NAS), size of disks, stripe size, SSD, etc. But do you have the performance you expect? I’ve tested I/O in the Cloud that just opened for Europe, so that…
By Franck Pachot . You buy resources on the Cloud, but they are mutualized, thanks to virtualization. Are you sure you have the resources you paid for? When it comes to Oracle databases there are 3 ways to test performances: Run an application, or a simulation of an application, such as the excellent SwingBench from Dominic Giles Run low-level calibration…
By Franck Pachot . When we give our trainings (dbi services workshops) we signal our best practices with this logo. It’s our know-how, acquired through experience, consulting, service desk, exchange at events, beta testing, etc. that we share with our customers. Let’s have a look at a few points that we recommend to change if you provision a database with…
By Franck Pachot . My first trial was not very good because I had access to Schema as a Service only. Which is not new. But Oracle Cloud Services is becoming now a reality, available for trial and available for general availability. Let’s see now how to use Database as a Service. Creation My goal here is to see what…
