This has been a long day, started with gathering some news about the Enterprise Manager 12c and finished with a huge concert on Treasure Island. However the highlight of the day was clearly Larry Ellison’s Keynote. Since this afternoon (pacific time), Oracle is officially proposing a Public Cloud, which integrates an Oracle Social Network…
In my second blog about OpenWorld, I gave an overview of the Engineered Solutions portfolio, which just got enhanced with Exalytics. Today I’m going to focus a bit more on the Database Appliance product and how this box works. I had the chance to go a session called “New! Database Appliance: Secrets revealed”, which provided more information on its architecture and functionalities.
After that I want to highly a interesting use case made by DELL and pointing out the usage of the brand new Oracle Enterprise Manager 12c for Cloud computing.
But before that let’s have a look on the Database Appliance secrets…
So Oracle OpenWorld’s day 2 is now over…with some rain…
However we had some interesting sessions such Fusion Middleware, RMAN or NoSQL.
In this post I’m going focus on two of them, introducing a coming Data Center Management solution and giving a tour on the Oracle Enterprise Linux roadmap.
Finally after a 18 hours, doors-to-doors, journey I’m arrived in San Francisco for Oracle OpenWorld 2011. My trip started in Basel, making a stop in Paris and then an 11 hours flight to San Francisco. Even with the on-board movies this kind of flight are still quite boring, but the funny things is that I really though that I was flying with “Air Oracle“…
dbi services search and test all tools or functions possible to optimize or to win something to propose the best tuning possible in their client.
The property of Spare columns is not the most used in client environment that we have seen.
This article present a script to find the potential columns that can have the sparse property with the usage restrictions to make a space tuning in your database and especially for Data Warehouse (DWH).
The database example that we used, is AdventureWorksDW2008R2.
My colleague Hervé Schweitzer reported a very interesting issue to me. It is about the usage of Grid Control 11g while monitoring the available space on an Oracle database – in our case a 10.2.0.3 target database. This post continues my last post about the free space management in a tablespace in relation to the recycle bin management.
In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services.
When Integration Service is installed with the instance “TOTO” and that it is at the end of his life, we’ll see how to transfer information to the second instance “TITI”. We present you a small working method to transfer information correctly.
Only the folders transfert is presented in this article and the transfert of the SSIS packages are explained at the end.
Last week by a customer, we experienced an excessive redo log generation filling up rapidly the FRA (Flash/Fast Recovery Area) with archivelog files which caused the database to crash.
Last Week at my Customer, I used dbua to upgrade an oracle database 10h to 11g, the migration run successfully. But next day I had a monitoring message that the diag directory is groing very fast.
Aprés le post sur « Utilisons les securefile », revenons sur le sujet LOB avec une approche performance, stockage.
Nous rencontrons parfois des modèles de données étranges, nous aurions envies en tant que DBA de tout reprendre à zéro pour refaire un modele relationnel en 3em forme normal (3NF), plus efficace et mieux conçu dans notre « RDBMS » favori, mais la réalité étant ce qu’elle est nous devons faire avec et au mieux.
De plus Oracle n’est pas qu’une base de données relationnelle 🙂 on l’oublie trop souvent.
This post describes some basic Oracle database management issues database administrators might be confronted with. It is about space management and differences observed while monitoring the available space from several point of views (tablespace/datafile) in Grid Control 11g. It also relates and explains an issue (ORA-01652) observed on pre 11.2 Oracle releases (targets) concerning the tablespace/datafile space management and the recycle bin. First of all, a simple example: let’s check the used and available space…