I/O

odacli create-database -io doesn’t work for older databases in 19.9

Introduction On ODA, you create your databases with odacli create-database. You can create a complete database, and it takes about 10 minutes, and you can also create an instance-only database. It will simply and quickly create a record in the(…)

FIO (Flexible I/O) – a benchmark tool for any operating system

I have just attended an interesting session held by Martin Nash (@mpnsh) at UKOUG 14 – Liverpool: “The least an Oracle DBA Should Know about Linux Administration” . During this session I(…)

Bug on Oracle 11.2 “ORION FAILS WITH ORA-27061”: Patch available!

In march 2011, my colleague Gregory Steulet published an article about Simulating and testing I/O performances with Orion. In this article, he wrote about a bug concerning Orion on Oracle(…)

Stéph@TechEd 2012: Episode2 – SQL Server 2012 & Windows Server 2012

Today it’s the real beginning of the TechEd with several sessions in parallel.

Using IOzone for Linux disk performance analysis

Who never had to measure the disk performances on a system? Speaking about Linux performance monitoring includes a significant part on disk performances. If you are facing applications or databases running slower than expected or than on other environments, you(…)

Simulating and testing I/O performances with ORION

Since Oracle 11.2, Oracle provides ORION in the RDBMS binaries (in ${ORACLE_HOME}/bin). ORION is an I/O calibration tool allowing to simulating and testing I/O performances an Oracle database would be confronted with.   ORION basically supports four kinds of database(…)

Simulating database-like I/O activity with Flexible I/O

You do not want to install or configure swingbench, load runner etc. – just to test the performance of your I/O system based on filesystems? Then Flexible I/O is the right tool for you. This post provides an overview. In(…)

How to avoid strange figures in the Oracle optimizer system statistics

Have you ever noticed strange figures while collecting the Oracle optimizer system statistics ? If so, you need to provide the optimizer with the correct number. In this posting, I will show you how.