Yann Neuhaus

Oracle Enterprise Manager 12c – Database Target remains in Pending state (SLES x86_64 target)

Last month I was confronted to a very interesting and strange problem while deploying a Cloud Control 12c infrastructure. One of my monitored server was a SuSE Linux Enterprise Server (SLES) 64 bits on which a 11.2.0.3 Oracle database was(…)

Replace a voting disk is so easy with Grid Infrastructure 11.2 & ASM!

For a few day we had a quick request at a customer which was to replace a voting disk in an ASM disk group. The current ASM disk group (redundancy normal) had 3 disks : two located in one data(…)

Configuration of tmpfs on SLES 11 for Oracle 11.2 and AMM

This post presents the configuration of the tmpfs filesystem size on SLES 11 in order to use the Oracle 11.2 Automatic Memory Management feature (AMM) through the Oracle instance parameter memory_target.

Why Perl is my choice for scripting

I have been advising to use Perl for a long time in order to automate Oracle processes and operations. This week however, I tried for once to write a small procedure on a simple Linux shell (ksh and bash). This(…)

Oracle RunInstaller crashes while installing Cloud Control 12c on OEL 5.7

A few days ago I downloaded the Cloud Control 12c binaries for Linux x86_64 from the Oracle Technet. My friend, Hervé Schweitzer, configured an OEL 5.7 VM for test purpose and I was quite eager to install this new software.

Partition exchange preview in MySQL 5.6

MySQL 5.6 proposes improved partition maintenance through "partition exchange". Even if not yet available, dbi services performed some tests on the MySQL Community Edition5.6.2 m5 release (still under Development).

Database space management issue with Grid Control 11g

My colleague Hervé Schweitzer reported a very interesting issue to me. It is about the usage of Grid Control 11g while monitoring the available space on an Oracle database – in our case a 10.2.0.3 target database. This post continues(…)

Oracle space management & recycle bin

This post describes some basic Oracle database management issues database administrators might be confronted with. It is about space management and differences observed while monitoring the available space from several point of views (tablespace/datafile) in Grid Control 11g. It also(…)

How to retrieve previous table statistics using Oracle dbms_stats

Sometimes, you need to modify the statistics of a table. There are various reasons: either for the performance analysis or because the execution plan changed. Oracle offers two methods: statistics restore or statistics export. Both are in the dbms_stats package.

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