In this blog, I will show how to configure a separate report database with downstream capture on an OTLP system , and how to maintain the archivelog transportation during a manual switchover.
Welcome to the 164th edition of Log Buffer, the weekly review of database blogs.
Recently I was looking into a long-running statement and noticed a curious thing. One moment, I had just over 4 billion buffer gets, and the next I had around 2 million. Beware that if you have had a statement running for some time, you cannot necessarily rely on the buffer_gets column in v$sql—it may be that it has run over the limit, been recycled, and is counting from zero again.
Welcome, readers, to the 163rd edition of Log Buffer, the weekly review of database blogs, your sieve
Oracle Open World 2009 is just few weeks away and I firmed up my presentation schedule now. I will present three “normal” presentations and couple unconference sessions. Before I get to the schedule, if you want to catch up with me during OOW — tweet me @alexgorbachev. You are likely to see me in the OTN Lounge or in “The Cave” if you know what I’m talking about. Here is a quick summary of my presentations.
Welcome to the 162nd edition of Log Buffer, the weekly review of database blogs.
One of the customers (actually a prospect) here in Australia asked me about minimal Oracle licensing on a quarter rack database machine. This prompted a thought of using Oracle Standard Edition instead of full blown Enterprise Edition with bunch of options. Before even going into possibility of using Oracle SE for the database machine, let’s see if we even want to.
Let’s go into the nitty-gritty… ODBM (Oracle Database Machine) v2 is twice as fast as version 1 when it comes to data warehousing. Compare to version 1, ODBM v2 runs OLTP traffic — “something that Netezza and Teradata can’t do at all… but we can do both [i.e. data warehousing] and we do both very well” said Ellison. So what’s inside?
In line with my prediction from few days ago, Larry Ellison is announcing the new Database Machine — the new version is targeting OLTP workloads and is based on Sun hardware. So what’s new in Exadata that I didn’t mention in the previous blog post? Ah, right — Sun FlashFire technology.
Welcome to the 161st edition of Log Buffer, the weekly review of database blogs … and the first one under my penmanship.