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…
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
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 11.2.0.2 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.
What is finally the primary objective of a database? Storing Data 
The question is, how Oracle makes it. For many beginners a confusing topic is
to get the picture between physical storage and logical one. So how does it works?
Are you experiencing network access issues after a migration to Oracle Database 11g Release 2 (11.2)? If yes, you probably have to allow the concerned PL/SQL packages to access your network again. This posting will show you how.
Are you confronted with Developper or Application Owner wich want to have very soon a test database available, to test the new developped code or to validate some code change before to implement it ? With Data Guard 11g you can offer this possibility with one click or command line.
Aprés une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour générer des documents xml est en erreur. Le format des dates a changé qu’a fait le DBA ?
