Oracle Database as our consultants live it every day: installation and patching, upgrades, RMAN backup and recovery, Data Guard, RAC, performance tuning, multitenant, licensing, and engineered systems such as ODA and Exadata.
By Franck Pachot . I’ve tried Windows 10 one month ago, and I had to roll back because VirtualBox failed to create host-only interfaces. Today, it forced me to upgrade again, so I tried a little further… and finally rolled back. Here is the list of issues I’ve seen in one hour of Windows 10 At boot I had the…
By Franck Pachot . Today, we can put our database on very efficient storage. EMC XtremIO is one of them. In this blog post, I’ll show how to look at the IO performance from Enterprise Manager, Orachrome Lighty, and XtremIO client interface. IOPS The XtremIO client has a nice dashboard that show immediatly the IO rate: The instant view shows…
By Franck Pachot . In a standby database (or in any database you recover) do you think the recovery uses buffer cache? And when you stop the apply in a standby database, do you think the datafiles are in a consistent state? We know the answer, but want to prove it. This is the kind of question you may have,…
By Franck Pachot . Look at the Oracle Download page: Standard Edition is there in 12.1.0.2 – more than one year after the release of the patchset for Enterprise Edition. It’s a new name – SE2 in short – and new rules. Let’s have a look at it. We waited for it after those rumors from July, and as expected…
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 . You have lot of db links between two databases, you think they are not used but want to be sure. It’s not difficult. When doing distributed transactions (which means running a transaction that involves remote databases through db links) the SCN of the database is synchronized. Comparing them can help. But let’s explain that. SCN synchronization…
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 . You don’t want to reload the datawarehouse database every night. And you may want to have it refreshed more often, in real-time during the day. There is another reason to capture all changes from the operational database: you want the history of all updates and not only the current value. This is why you use Change…
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…
By Franck Pachot . Yes, the topics for the OCM 12c upgrade are online and I’m already looking at the topics. I’m talking about the ‘Configure the Resource Manager’ one here. Configuring Resource Manager in commandline is not easy. At the OCM exam you can do things faster when you have a GUI. Of course, you need to know where…
