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
-
A SQL statement is slow and suddenly fast? Have a look at “Cardinality Feedback”!
Discussing with some tuning gourous we were made aware about this feature. It is not so far from the adaptive cursor sharing perfectly described in Chris’s blog : http://antognini.ch/papers/BindVariablePeeking_20090718.pdfThis feature, compares the real execution (number of returned/actual rows “A-rows”) with some expectations (number of expected rows “E-rows”) and chooses another plan for the next executions if the difference between the…
-
Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!
Are you often trying to find some functionalities into ORACLE 10gR2, ORACLE 11gR2 or MySQL documentation ? Of course each time you are looking for this documentation you find unofficial documentation which is never corresponding to the version you are looking for.. we have the solution, three firefox add-ons that will allow you to easily find the right official Oracle…

-
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…
-
Simulating database-like I/O activity with Flexible I/O
You do not want to install or configure swingbench, load runner etc. – just to test the performance of your I/O system based on filesystems? Then Flexible I/O is the right tool for you. This post provides an overview. In order to simulate Oracle database I/O workload on filesystems, ORION cannot be used since it only uses raw or block…
-
Oracle 11g Instance Caging – limit database CPU consumption
As you certainly already have heard Oracle 11g came with a new feature called “Instance caging”. This feature allows Oracle DBA to easily manage Oracle Instance CPU-consumption. How does it work? Quite easily … see below

-
Oracle index compression: eliminating duplicate column values
Index compression comes from Oracle 8i and has quite the same mechanism as table compression. Index compression eliminates duplicate column values in the leaf blocks. Let’s see how it works:
-
How to debug a Data Pump error
Recently, I had an Oracle error with Data Pump at a Customer, which was not easy to localize. Here is the error I received during a DBIOWNER schema export with Data Pump: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_STATISTICS] ORA-00942: table or view does not exist
-
DBMS compression: determining a table’s compression ratio
According to the Oracle documentation, the dbms_compression procedure allows to determine the compression ratio for a table without creating it. Let’s have a look at it.
-
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
-
MySQL Workbench 5.2: changing the life of MySQL developers and DBAs
MySQL Workbench provides several necessary tools in order to manage a MySQL environment. MySQL Workbench 5.2 is available for Windows, Mac and Linux platforms, it encapsulates three main functionalities: 1. SQL Development: Allows connecting to existing databases and run SQL Queries, SQL scripts, edit data and manage database objects. This functionality replaces the ones previously provided by the Query Browser…

-
SQL Developer 3.0 : prêt pour les DBA
La nouvelle version d’Oracle SQL Developer (version 3.0.03.45) est prête pour les administrateurs de base de données/DBA (voici une vidéo sur cette version). Elle s’est vue agrémentée d’outils nécessaires aux tâches d’administration. Les tests ci-dessous vous présentent, à travers quelques copies d’écrans, les fonctionnalités de l’outil, en espérant vous donner l’envie de l’adopter.

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

