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
-
Diving into Databases
By dbi services, we are a few poeples passionate by diving.We take this opportunity to let you dive into the two databases lakes Oracle and SQL server and see their similarities and differences. For this first level of diving (named ODD), we will not going too deep and not have narcosis or databases toxicity.As always, we’ll start with a short…

-
Oracle 11g R2: catupgrd.sql running for hours
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$.
-
Inside Grid Control
Lors de mon activité de consultant, et suite à un bug qui n’affiche pas correctement le nombre de CPU (OMS 10.2.0.5, agent 10.2.0.5 et linux x86_64), je me suis intéressé à la manière dont Oracle Enterprise Manager Grid Control (OEM GC) récupérait les informations de mémoire et de cpu sur les différents hôtes surveillés par ce dernier.

-
Oracle Basics (3) – Database startup and shutdown
It’s already quite a while that I posted my last article on the Oracle basis, so I decided to take some times in the train to continue this small serie.This time, I’m going to speak about one of the root of Oracle administration, starting and shutting down a database.Startup and shutdown processes within oracle databases are splitted in different steps…

-
A brief PowerShell 2.0 overview
SQL server 2008 has PowerShell and at the end of this article, I speak of this topic but to use correctly Powershell, you must have a basic notion about this technologie. In microsoft Techdays in Basel, Marc van Orsouw presents Powershell.I think it was a nice opportunity to presents you an overview of Powershell based on this presentation with adding…

-
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…
-
Pourquoi mettre une base de données Oracle en force logging ?
Certaines requêtes DDL offrent la possibilité de ne pas générer des enregistrements dans les redo log via la clause NOLOGGING. Le mode nologging permet donc dans certains cas d’accélérer des traitements, ceux-ci pouvant facilement être récupérables à travers des mécanismes externes à la base de données. Ce mode peut cependant avoir des conséquences fâcheuses comme nous allons le constater et…
-
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
-
Stop looking for Oracle Fusion and Oracle Grid Control documentation: use the dbi services firefox add-ons!
After my last post title “Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!” Some of you asked me for firefox search add-ons for Oracle Fusion Middleware (http://download.oracle.com/docs/cd/E17904_01/index.htm). This add-on will provide you a fast a reliable way to find easily what you are looking for in the official oracle documentation.

-
Il était une fois … SQL Server!
Cet article propose une introduction à Microsoft SQL Server en peignant son historique et en procurant un rapide aperçu de son architecture et des termes associés à cette technologie.

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