Category: Database

Database posts

Posted in Database Oracle

How to find Oracle’s Database Edition version – Comment trouver la version Edition d’une base de données Oracle.

Here is the SQL command that show you important information about Oracle’s engine, such as the edition (Enterprise, Standard, Lite …). Voici commande sql qui…

Continue Reading
Posted in Database Oracle

Définition d’un deadlock Oracle (ORA-00060)

Juste pour faire le point avec mes amis développeurs. Un deadlock n’est pas un problème Oracle (ou autre SGBD) ou système mais un problème de…

Continue Reading
Posted in Database MaxDB

Monitor MaxDB state

It’s quite simple to get vital information from a MaxDB database all you have to do is run the command “info state” when connected to…

Continue Reading
Posted in Database MaxDB

Fully recover MaxDB database following data corruption – Restauration complète d’une base MaxDB suite à une corruption de données

I had to fully recover my MaxDB database due to a data corruption. Hopefully, I had a full backup dating from before the data corruption….

Continue Reading
Posted in Database MaxDB

How to check MaxDB’s log backup mode – Verifier le mode de sauvegarde des logs MaxDB

Automatic log backup ensure that a log segment of the log area is saved as soon as it has been filled. This log segment is…

Continue Reading