So you think you have disabled ASMM/AMM oracle automatic SGA sizing behavior?

I polled my session attendee's at Hotsos 2014 ( Three approaches to shared pool monitoring ) and asked them who was using automatic stuff versus who was doing it all manually?

My guess is that there were about 100 people in the room and it looked like automatic "won" but not by much.  Maybe 55 percent automatic and 45 manual ... so there are still a whole bunch of people nervous about using that functionality.


managed to make it to Dallas sunday morning … Hotsos 2014 is rolling

It was a little dicey sunday morning with weather in Ohio but I caught very early flight and made it down to Dallas well before noon.  Lots of turbulence in the airplane ride and bounced around some but all in all not bad.  Lots of people traveling ran into hitches one way or another but by the end of the day Monday most everyone seems to be here now.

Even better I had (more...)

Pretty close to getting out speaker notifications for GLOC 2014 …

Our official notifications should be out by mid week ( next Wednesday ) and we appreciate all of the people submitting abstracts.  Thank everyone of you very much from all of us involved in the conference.

Wow this is going to be another outstanding conference.  Darn going to have to not accept a large number of quality presentations also.  We do not have the time or room to run all the sessions (more...)

emergency monitoring and forcing a flush of the shared pool … use with caution ONLY if really needed

Flushing the shared pool has an impact on systems forcing at least the re parsing of sql statements and new ( perhaps even changed ) execution plans.  Use with caution on any production environment and test/test before deploying anything like this.

The usual approach for a system suffering from shared pool fragmentation and/or 4031 is to identify sql not using bind variables and consider implementing ( after logon session based database trigger best ) (more...)

How many times can you practice and revise a presentation?

Well the obvious answers are "it depends" and "how far away is the actual presentation"?  For Hotsos 2014 I had the vast majority of the work done in early December 2013 ... not bad for a presentation not delivered until March 3 2014.

That was after a couple of series of revisions and after all this was based on a presentation originally done at Oracle Open World 2011.

It makes even an experienced and grumpy (more...)

linkedin endorsements make me … grumpy … sometimes

Well I don't really mind endorsements for skills that are in my current toolset.  It is a nice compliment to get endorsements from people that you know well or have work with or are working with.

On the other hand endorsements for things that you have never worked on in your life seem a little strange.  I now have several endorsements for Oracle HR ... never ever in my life touched that not even (more...)