Autonomous Data Warehouse – the new kid on the block. But does it really live up to the hype – will it make your analytics platform run faster or is it just more sales hype?

The most common question I get asked is “should we look at ADW”.
The second most common question (once I’ve said yes to the first one) then is “why”?

Let’s see how it really performs with some simple, reproducable tests that you can compare to your on premises databases, too.

(more…)

  • OAC has been working fine for….180 days….and now won’t start!
  • Service appears to come up OK, but no services accessible & reboots don’t fix it.
  • The short answer – DBCS “as provisioned” has a 180 day expiry on all schemas – and officially there’s no way to unexpire the accounts without changing the passwords, which’ll break “everything”.
  • This post shows how to identify & debug the problem, fix it quickly and simply, and then prevent it happening again!

(more…)