Insights. One level above.
We know what above looks like. Explore the expertise built inside most demanding environments.
More than 9.9 million reads in the past 2 years See what readers open most
-
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. I checked the O.S settings, the required parameters, aso …, everything was fine. My OMS repository database (11.2.0.3) was ready.…

-
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).
-
SQL Server Tuning: Detect SPARSE columns candidate
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 usage restrictions…

-
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 my last post about the free space management in a tablespace in relation to the recycle bin management.

-
Changing the reference instance for SQL Server Integration Service (SSIS)
In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services. When Integration Service is installed with the instance “TOTO” and that it is at the end of his life, we’ll see how to…

-
Compression advisor: excessive redo log file generation
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.

-
Let’s work together
Ready to operate at
the next level?Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.
-
Most read
More than 360,000 reads in the last 30 days
The posts our readers open most: the all-time favourites, and what is trending right now.
All-time favourites
- Automate encryption-in-transit for SQL Server 124,231 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,760 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,132 reads
Trending, last 30 days
-
Take care while upgrading your Oracle DB with “DBUA”
Last Week at my Customer, I used dbua to upgrade an oracle database 10h to 11g, the migration run successfully. But next day I had a monitoring message that the diag directory is groing very fast.

-
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 relates and explains an issue (ORA-01652) observed on pre 11.2 Oracle releases (targets) concerning the tablespace/datafile space management and the…

Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.


