2016

Uncategorized

Datapump or Flashback Database

datapump2 1

Do you need Datapump? At nearly every customer I’m visiting there is a need to take export dumps of the entire database every single day. But why? You probably know the answer: because the application team requested it to reset a schema or a table to an earlier time in the event due to a user failure, batch error or whatever. My next question is this: “How often did you reset a table or a schema within the last 12 months?” Answer: “Not a single time… but we had to do it some years ago with one of our databases.

Datapump or Flashback Database Blogbeitrag lesen »

Uncategorized

inMemory on Oracle RAC

In my last blog I described my first experience with inMemory at a customer side. I was really impressed about the massive performance gain and the ease of use. Now it’s time for a second trial. As stated earlier the customer was using a single instance database as test environment but the production and preproduction were running on Oracle RAC. This again shows how important it is to have the same environment for preproduction and production – or better for test as well as that whould have shown the non comparable results early enough and not just before it went

inMemory on Oracle RAC Blogbeitrag lesen »

Scroll to Top