Of all the frustrating, partially-completed features Oracle has released, this is the most frustrating. Did I mention this frustrating feature is frustrating when you get bitten by it?What am I referring to? FLASHBACK QUERY on a table that lives in a database with a large UNDO_RETENTION specified with lots and lots of UNDO_TABLESPACE space. Why is this behaving this way? Silly me, I really should read Oracle docs more carefully.Here’s what they say at Managing Undo for Your Database…There you have it folks. Please don’t get bitten with this the way I did.
Heads to everyone who hasn’t got a message on Twitter or didn’t read Justin’s blog post — we are moving completely indoor (guess why?). It’s now LJ’s Martini Club & Grill @ Metreon 2nd Floor but same address — 101 4th Street, San Francisco, CA 94103.
As I’ve done my presentation this morning, I’m free for the rest of the day and I stopped by OTN Lounge where the cool stuff is almost ready to go — final tweaks and preparation before 4 days of rocking. I’ve spoke to Justin Kestelyn of Oracle Technology Network and here what he has to say about this year’s OTN activities at the Oracle Open World.
Most of this week I spend in San Francisco — I arrived on Wednesday with couple other Aussie Oracle ACE Directors, Chris Muir and Marcel Kratochvil. This year I have my whole family traveling with me so it should be fun.
This post originated from a quick discussion we had internally on how to quickly and easily compare schemas between two Oracle databases. I learned about Sheeri Cabral’s post with a quick comparison solution for MySQL databases and I though of using a similar approach for Oracle. I did some testing and it worked quite well. There certainly are tools in the market, free or not, that do this for us, and even generate scripts to correct differences. The steps below only go as far as to tell you what the differences are. However, they don’t require any additional tool and can be easily executed in any *nix or Windows environment.
Welcome to the 165th edition of Log Buffer, the weekly review of database blogs.
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