Tuesday, September 18, 2007

Getting ready for 11g, how's your /dev/shm?

WOW I'm busy! Thats a good thing but it sure slows down my blog posting. I apologize for that. I've been working on my latest rant essay to post here, but it's not done yet, and I really should do something Oracle 11g related, so here it is!

As you may know, 11g now manages both the SGA and the PGA automatically though some new parameters, memory_size and memory_max_size.

Memory_size replaces sga_size and pga_aggregate_target, combining the two into one memory pool for Oracle to manage (well, not really one big memory pool, they are still separate, but Oracle deals with all the details under the covers).

Memory_max_size is roughly like sga_max_size + pga_aggregate_target, gobbling up memory for future use should you use it.

So, why the comment about /dev/shm? If you are going to move to 11g's flavor of memory management on Linux, then you might run into this little error:

ORA-00845: MEMORY_TARGET not supported on this system

and you might say to yourself, "Wow, that stinks, I can't use memory_target on Linux."

Well, thats not quite the case. In fact, the problem is likely that /dev/shm is not configured big enough. You will get this error if /dev/shm is not configured large enough to handle the memory you are allocating with memory_target. So, if you are planning on using these new features, be preparing now and increase the size if /dev/shm.

More on this and many other topics in my new Oracle Database 11g New Features book which is available for pre-sales now on Amazon.com. It will be out VERY SOON!!!

Wednesday, September 05, 2007

Greetings from Denver

I'm in Denver this week teaching a class. Wow, what a week. I flew to Denver in my airplane to teach. It was about a 4.5 hour flight and it was great! Nothing like flying over the rockies at 12,500 feet to get your blood pumping! Especially when the reported density altitude at the airports nearest to you (which are at about 7500 feet) is something on the order of 9,800 feet MSL (above sea level). You just hope your fuel calculations were right!!

Today has been the anti-technology day. Everything has broken and all at once. My wireless would not work, my cellphone would not dial out, we are using iSQLPlus here and that went south... UGH!

On a good note, I finished up the last chapter in Oracle Database 11g!! Yeahhhh.... So now it's a process of going through the edits and getting it ready to print. I love the writing but hate the editing process!!!

I'll try to post a new 11g feature shortly...
 
Subscribe in a reader