Middleware is where applications meet infrastructure. Here our consultants write about WebLogic, JBoss EAP, WildFly and Tomcat in real production environments: installing and clustering them, patching, deploying applications and finding out why something stopped working.
J’ai eu le plaisir de suivre une formation chez Oracle University à Colombes (Paris). En tant que stagiaire, le cours s’intitulait Oracle Weblogic Administration Essential. Ce post traite de la notion de cluster Weblogic. J’y expose les avantages du clustering weblogic, les principaux éléments à connaître ainsi qu’un exemple de configuration via la console d’administration.
Oracle has introduced three new caching features in its Oracle 11g release:
In this posting, I will present the query result cache feature.
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 not include JRE” or “This zip file includes the JRE”. On linux, the choice is limited because the only version available doesn’t include Java Runtime Environment. And
…
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).
dbi services search and test all tools or functions possible to optimize or to win something to propose the best tuning possible in their client.
The property of Spare columns is not the most used in client environment that we have seen.
This article present a script to find the potential columns that can have the sparse property with the
…
Last week by a customer, we experienced an excessive redo log generation filling up rapidly the FRA (Flash/Fast Recovery Area) with archivelog files which caused the database to crash.
During the last weeks, I was confronted to an uncommon bug during the database upgrade from security sensibledatabases.
The upgrade was sticking for hours on the script c1101000.sql. which tried to fill the column DBID with the database DBID of the tables AUD$ and/or FGA_LOG$.
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. 1. Statistics restore This method uses the procedure dbms_stats.restore_%_stats, where % can be table, schema, database, and fixed_objects. This is…
Discussing with some tuning gourous we were made aware about this feature. It is not so far from the adaptive cursor sharing perfectly described in Chris’s blog : http://antognini.ch/papers/BindVariablePeeking_20090718.pdf
This feature, compares the real execution (number of returned/actual rows “A-rows”) with some expectations (number of expected rows “E-rows”) and chooses another plan for the next executions if the difference between
…
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 activities based on either small or large I/O. ORION can, as any respectable I/O simulation tool, generate an adapted workload
…
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 order to simulate Oracle database I/O workload on filesystems, ORION cannot be used since it only uses raw or block…
As you certainly already have heard Oracle 11g came with a new feature called “Instance caging”. This feature allows Oracle DBA to easily manage Oracle Instance CPU-consumption. How does it work? Quite easily … see below
