Official release of Lighty for PostgreSQL

Orachrome completes its range of products with Lighty for PostgreSQL, performance analysis tool for PostgreSQL databases.

The beta period is over, thanks a lot to all the beta-testers who send us their feedback to improve the software! From now on, the 1.1 release is available for purchase on our website. As for Lighty for Oracle, you can download a 30-day trial version to try out the software’s different features.

Its optimized graphical interface allows an efficient representation of the problems and an intuitive navigation through the different indicators.


La bêta de Lighty for PostgreSQL est ouverte !

La version bêta de Lighty for PostgreSQL est disponible !

Devenez bêta-testeur de ce nouveau logiciel de gestion de performance pour bases de données PostgreSQL.

Pour participer au test du logiciel, inscrivez-vous sur le site internet d’Orachrome (rubrique Télécharger). Après avoir rempli un court formulaire d’inscription, une clé d’activation valable 30 jours vous sera envoyée par mail.

Pendant la période de test, envoyez-nous vos retours, vos remarques et vos suggestions à l’adresse

Les bêta-testeurs qui nous auront aidé en donnant des retours se verront offert six mois supplémentaires lors de l’achat d’une licence d’utilisation à la sortie du logiciel.

N’hésitez plus, inscrivez-vous vite !



Beta release of Lighty for PostgreSQL is now available !

Become a beta-tester for this new performance management software for PostgreSQL databases.

To take part in the software’s tests, register on the Orachrome website (« Download » tab). After you fill a short registration form, you will receive by email a 30-day activation key.

During the beta period, send us your feedbacks, comments and suggestions at

Beta-testers who will have helped us by giving feedbacks will be offered six extra months when buying a user license after the software will be released.

Don’t hesitate, register now!

Coming soon : Lighty for PostgreSQL

Nous sommes très fiers d’annoncer la sortie prochaine de LIGHTY FOR POSTGRESQL !

Améliorez les performances de votre base de données PostgreSQL.

Prenez note ! La version bêta de Lighty for PostgreSQL sera disponible en téléchargement dès le 26 juin 2018 !

Cette version comprendra un panel de fonctionnalités de Lighty for Oracle, adaptées au SGBD PostgreSQL.


Principales fonctionnalités :

  • Compatible avec toutes les versions de PostgreSQL depuis la version 9.6
  • Octroi de licence par site, permettant de gérer un nombre illimité de bases de données
  • Une structure sans agents réseau qui assure une installation et une maintenance rapides et légères
  • Une Analyse de Performance multi-dimensionnelle qui permet une identification des problèmes et une résolution efficiente
  • Une interface graphique optimisée permettant une représentation graphique efficace des problèmes et une navigation intuitive entre les différents indicateurs
  • Gestion des performances de plusieurs bases de données
  • Outil de diagnostic de performance Multi-OS
  • Identification des problèmes en quelques secondes seulement
  • Rapports SQL personnalisables
  • Comparaison simple entre différentes bases de données




Proud to announce the upcoming release of LIGHTY FOR POSTGRESQL!

Optimize your PostgreSQL Database performance.

Make a note! Beta release for Lighty for PostgreSQL will be available for download on June 26 2018!

This release contains a range of features from Lighty for Oracle, adapted to PostgreSQL.


Have a glimpse of the main features:

  • Available on all PostgreSQL since 9.6 release
  • Offered with one license per installation location providing support for unlimited databases
  • An architecture without software agents, which ensures a quick and lightweight installation and maintenance
  • A multi-dimensional Performance Analysis, enforcing an efficient way through problem diagnose to resolution
  • An optimized GUI which ensures an efficient graphical representation of contention and a natural navigation throughout all indicators
  • Multi-database performance monitoring
  • Multi-OS performance diagnostic tool
  • React in seconds, not hours!
  • Customizable SQL reports
  • Easy comparison between different database activity

Orachrome become partner of the event CRIP 2018 @ PARIS

We are pleased to announce our coming to the CRIP 2018 annual convention in Paris, the future of IT and digital.

On this occasion, we will present Lighty For Oracle, Orachrome’s flagship solution for the administration, tuning and monitoring of Oracle databases.

In order to be closer to our customers, we will involve a client and partner to expose his experience feedback and a case in which Lighty was a must-have for the exercise of his work.

Also present at the show, we will be happy to receive you to answer your questions and special requests during these two days under the banner of performance and digital innovation.

Do not hesitate and come to meet our experts.

Lighty 1.6.0 : New Features

This version come with new Features :

  • Monitoring: allows you to have email alerts for 3 metrics (CPU, Active Sessions, I / Os)
  • The SqlReportWizard: Allows you to create your own reports, or to duplicate and modify existing reports
  • Improvement of the comparative tab and the activity viewer: button previous and next day, possibility to compare the current source over different periods
  • Improvement of the sql plan: you can click on an object (name of the object in blue) and see its characteristics displayed in a sql report (when available)
  • Job Report that also allows you to stop / restart a job
  • Compare AWR reports
  • Generate statspack report in sqlreport, using an ssh connection (to be configured in the database info window)
  • Coloring by event class in the event system graph and adding a grouping type by class
  • Possibility of defining the number of retention days of the L-ASH data for each database (information window of the database)
  • Accessible Help Offline



Lighty 1.4.4, Orachrome new revolution

The last month, Orachrome announcing Lighty 1.4.3. Today his successor appeared with more features !

The new version 1.4.4 will save you time.

Now you can import and / or export your connections between Lighty software. The export can be done in CSV. You can also kill a session from the interface.

In addition you will have more detailed information about your databases. A new button « on / off » will allow easier access to tracks of a session. Furthermore, you can launch a snap Statspack / AWR and L-ASH / ASH from the interface. It will allow you to have an account customizable schedule your sessions.

Have you got questions ? Contact us at or +33 4 84 25 11 28.

Follow us Twitter, Viadeo et LinkedIn !

ANOUNCING : Lighty for mobility performance monitoring !

Engagement, quick win and win-win relationchip, are the values that Orachrome try to build with customers.

Lighty, have for target to give the best delay of Return On Investment (R.O.I.) for partners (customers, suppliers, partners,…).

March 2016, the new version (1.4.3) including news fonctions than improved Lihgty in a mobility situation.

Severals buggs, particulary ID Hardware problems are fixed, and many new functions are available.

DOWNLOAD IT NOW ! Try the best tool to pilot the Oracle Database !


Quickly diagnose problems on your oracle db thanks to the real-time feature of Lighty

Most of the time, when we have to make a real-time analysis, the first thing we look at, is the database activity from ASH (Active Session History). In many cases, this is enough to have à good explanation of what happens.

Lighty allows you to view the ASH activity through the « Activity Viewer » tab as well as special reports (Current activity (ASH)). You can also install L-ASH if you are not licensed for ASH
But sometimes we need to have an overall view of the current activity and quickly have answers to questions as:

  • Are the I/Os efficient ?
  • What are the top events ?
  • Are there blocking sessions ?
  • Is the server overloaded ?
  • What are the on going operations ?
  • Who is using the temporary space ? PGA ?
  • What are the active sqls ?


One more reason why it is recommended to clone a database instead of importing datas for testing

Some days ago, a customer encountered an application hang in its production database.

A little version upgrade was in progress. The upgrade was done online during the day because of the small ddl changes.

There were 4 ddls to execute. The first 3 were ok but the problem occurred when the last one started.

It’s just a column update to allow null values.

Normally, the sql runs in a few milliseconds as it modifies only the dictionary.

alter table TABLE_NAME modify COLUMN null;

But this time, the sql took nearly 25 minutes to run with a lock in the library cache, preventing access to the table and causing the application hang.

The entire table was read and all blocks have been modified. The table contains more than 100 million rows.

So, why ?