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 devices (scratching the filesystem). To simulate Oracle database I/O behaviour on filesystems, we can use…
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
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:
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
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.
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 stand-alone application.
2. Data Modeling: Helps to create and manage models, allows forward & reverse engineering and provides capability to compare and synchronize schemas
3. Server Administration: Helps to configure a database server, to setup user accounts and browse status variables and server logs
Let’s have a look deeper in each of those features:
I was upgrading Netbackup yesterday to version 7.0.1 and faced a quite “funny” issue with the OpsCenter. The installation failed on pre-requirements checks saying that no space was available. Nothing strange at this point…except that we still had about 79GB free space!
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.
The chrismas period is over and it is now time to enjoy the several gifts brought by Santa Claus. Under my Chrismas Tree I discovered this year an iPad.
Running Linux servers configured with Huge Pages was not always adapted when both 10.2 and 11.2 databases had to be started in parallel. Since 220.127.116.11 this situation changed !
Last week I encountered the following problem while installing Oracle 11g R2 on AIX 6.1 TL06 SP2. I met all the PreReqs of the installation document, but at the end of the installation process, I got the following error message:
Error in invoking target ‘agent nmb nmo nmhs’ of makefile ins_emagent.mk’
Le stockage des LOB est souvent négligé lors de la création des tables. Hors les choix de stockage ont un impact sur la performance d’accès aux données. nous allons voir rapidement dans cet article l’avantage à utiliser le stockage SecureFiles proposé par Oracle à partir de la version 11gR1.