All articles

‘Query result cache’ in Oracle 11g

Oracle has introduced three new caching features in its Oracle 11g release: Query result cache Client OCI result cache PL/SQL function result cache In this posting, I will present the query result cache feature.

Linux: easing the process and performance monitoring with htop

I'm pretty sure that most of you already struggled with some low performance systems. In order to analyse such cases several tools and utilities, like top, nmon, fuse or lsof are available under Linux. However trying to dig in processes(…)

Forefront Endpoint Protection (FEP) 2010 and database policies

I have seen at a customer that the SQL Server's policy doesn't follow the Microsoft's recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn't exist in(…)

SQL Server 2012 Express LocalDB RC0 is Available

Since a few days, Microsoft® SQL Server® 2012 Express LocalDB Release Candidate 0 is online.

Oracle SQL Developer & SQL Data Modeler on Ubuntu

Oracle SQL Developer and Data Modeler are becoming more and more popular as they are both cost-free and available on many Operating Systems (Linux/Unix,Windows and Mac) with different installation types: "This zip does(…)

SQL Server 2012 ‘Denali’: the Release Candidate is available

We looked forward to and it has finally arrived... Since Friday,  Microsoft® SQL Server® 2012 Release Candidate 0 is online.

SQL Server 2012 ‘Denali’: a new panel of DMVs

Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.Since few months, I test the future new version SQL Server 2012 codename Denali and(…)

Block Corruption Oracle 10g vs Oracle 11g

Ayant rencontré récemment des problèmes de blocs corrompus sur des bases Oracle en version Oracle 10g et Oracle 11g, des différences notables sont apparues notamment au niveau de la vue v$database_block_corruption. Je vous livre dans ce post le résultat(…)

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).