Oracle Team

How to do a Filesystem Resize (ext3/ext4) on Redhat running on VMware

By William Sescu A filesystem resize can be done in several ways, online, offline, with LVM2 or without LVM2.  However, this blog will describe how to do an online resize of ext3/ext4 filesystems where a virtual disk (vmdk) is online(…)

Exadata X-5 Bare Metal vs. OVM load testing

By Franck Pachot . In a previous post I tried to compare a single thread workload between Exadata X5 Bare Metal and Virtualized. The conclusions were that there is no huge differences, and that this kind(…)

Oracle serializable is not serializable

By Franck Pachot . Did you know that when you set isolation level to SERIALIZABLE, it is not serializable but SNAPSHOT? This isolation level is lower than serializable. I've never thought about it until I read Markus Winand(…)

DBA essentials workshop with release Oracle 12c is Available

It’s with pleasure to announced dbi services have upgrade the infrastructure for Oracle DBA essentials workshop. We have migrate the release of Oracle 11g R2 to the latest version Oracle 12c features and install the last PSU (April 2016).

Shrinking Oracle VM VirtualBox with Zerofree

In this blog I would like to talk about Shrinking a Virtual Machine with Oracle databases and MySQL which is install. Unfortunately, whilst Virtual Box will dynamically expand the hard drive as it’s required, it won’t dynamically shrink it(…)

Exadata X-5 Bare Metal vs. OVM performance

By Franck Pachot . The Exadata X5 can be installed Bare Metal or Virtualized. The latter one, Oracle VM allows to create multiple clusters on one machine, is more complex for installation and for storage capacity planning. But it allows(…)

Large Pages and MEMORY_TARGET on Windows

By Franck Pachot . In a previous post about enabling large page on Windows Server, I explained that it's possible to use large pages with Automatic Memory Management (AMM, where sizing if SGA and PGA is(…)

Redo log block size on ODA X6 all flash

By Franck Pachot . On the Oracle Database Appliance, the redo logs are on Flash storage (and with X6 everything is on Flash storage) so you may wonder if we can benefit from 4k redo blocksize. Here are some tests(…)

ODA X-6 log file sync with NVMe flash

By Franck Pachot . The new ODA X-6 has been announced last month with two smaller configurations and smaller prices: 2S and 2M. Small, but high performance configuration: all SSD, and I/O transfer optimized for Flash with PCIe bus and(…)

AMM and ASMM derived parameters

By Franck Pachot . The latest DBA Essentials Workshop training I've given raised a question about PGA_AGGREGATE_LIMIT. The default depends on PGA_AGGREGATE_TARGET. So how is it calculated in AMM where PGA_AGGREGATE_TARGET is dynamic? Is it also(…)