Oracle

Waiting for row lock. But which row is locked?

By Franck Pachot . When you are waiting on a locked row, the locked resource is the transaction that has locked the row. We have no information about which row is locked. Here is how to get it from V$SESSION.

DataBase Cloud Service performance – Network

By Franck Pachot . In previous posts, I've installed SLOB on the Cloud Services, measured IOPS and(…)

Windows 10 – I tried and came back

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

Measuring IOPS on XtremIO

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

set state=apply-off and datafile consistency

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

Oracle Standard Edition Two

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

DataBase Cloud Service performance – CPU

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

DataBase Cloud Service performance – IOPS

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.

SLOB in the Cloud: how to check Cloud Services performance

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

SCN synchronization in distributed transactions

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