Application integration & Middleware ‘Query result cache’ in Oracle 11g 05.01.2012 by Nicolas Jardot 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.
Operating systems Linux: easing the process and performance monitoring with htop 02.01.2012 by David Hueber 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(…)
Database management Forefront Endpoint Protection (FEP) 2010 and database policies 01.01.2012 by Stéphane Haby 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(…)
Technology Survey SQL Server 2012 Express LocalDB RC0 is Available 09.12.2011 by Stéphane Haby Since a few days, Microsoft® SQL Server® 2012 Express LocalDB Release Candidate 0 is online.
Application integration & Middleware Oracle SQL Developer & SQL Data Modeler on Ubuntu 28.11.2011 by Jérôme Witt 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(…)
Technology Survey SQL Server 2012 ‘Denali’: the Release Candidate is available 21.11.2011 by Stéphane Haby We looked forward to and it has finally arrived... Since Friday, Microsoft® SQL Server® 2012 Release Candidate 0 is online.
Database management SQL Server 2012 ‘Denali’: a new panel of DMVs 17.11.2011 by Stéphane Haby 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(…)
Hardware & Storage Block Corruption Oracle 10g vs Oracle 11g 11.11.2011 by Oracle Team 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(…)
Database management Oracle RunInstaller crashes while installing Cloud Control 12c on OEL 5.7 07.11.2011 by Yann Neuhaus 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.
Application integration & Middleware Partition exchange preview in MySQL 5.6 25.10.2011 by Yann Neuhaus 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).