Skip to content

Performance

‘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 analysis and looking for files and processes relations may be quite painful.

To get started with performance checks and analysis,

… 

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 case of Forefront Endpoint Protection 2010 known as FEP 2010.

I have decided to create databases policies for FEP optimized by dbi

… 

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

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. 1. Statistics restore This method uses the procedure dbms_stats.restore_%_stats, where % can be table, schema, database, and fixed_objects. This is… 

Saving time and increasing service availability with MySQL Enterprise Monitor 2.3

Nowadays MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their data center, sometimes even without knowing it except when the MySQL service is no more available. In order to increase this service availability it is mandatory to have a monitoring solution. Regardles of you are using MySQL Server,

… 

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 activities based on either small or large I/O. ORION can, as any respectable I/O simulation tool, generate an adapted workload

…