The AQ notification process has changed from release 10gR2 to 11gR1. The most notable change is the switch from using DBMS_JOB jobs to DBMS_SCHEDULER jobs. The number of available jobs to run the notifications is limited to the number of JOB_QUEUE_PROCESSES that have been set up for that instance, and each job dequeues one message. In 11gR1 the notification process is very similar but instead of creating a DBMS_JOB job it creates a DBMS_SCHEDULER job. This, in itself, is not very different but here’s the big difference:
I got a special press badge this year, I felt I had to do something about it so I decided to make short interview with few people that I’m running into during this Oracle Open World. I have already blogged about my Sunday’s interviews but I created a Youtube playlist where you can see them all (use arrows on the sides).
Thanks to all the bloggers for coming and sponsors for sponsoring! If you were on that meetup – make sure you blog about it, post you photos and publish the photo on *your* t-shirt to the community (yeah, you can take it off the wall this one time).
I had had some experience with silent (and not always successful) installation of Oracle versions 8 and 9, but thanks to an excellent post, Oracle Silent Mode, Part 1: Installation Of 10.2 And 11.1 Databases by Grégory Guillou, I got a new splash of joy using silent installations. RDBMS, Oracle Grid Control, agents, scheduler agents, collaboration software, etc., can be installed using the silent installation in latest versions. This post is about silent installation of one of the new Oracle 11g Rel.2 options called Oracle Restart.
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.
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.