have fun anyone heading out to OOW 2014

For anyone who has never attended a San Francisco Oracle Open World you really should go at some point.  The city is beautiful and the event well organized if a little on the chaotic side.

I have been lucky enough to attend quite a few of them over the last 10 years but missed out last year and also will be missing out this year.

It has been just once that one of my (more...)

long project nearing completion at work and a good book available

For any long time fans of the grumpy old dba blog, you may remember I changed jobs in June of 2013.  Sometimes changing jobs allows you to slowly come up to speed in a new environment but the last change involved me jumping right into a project that was already kind of rolling.

It has been a long year on the same project and a lot of time involved.  Not exactly what I (more...)

Well dang sessions got rejected ( yes again ) at Open World 2014 … makes me grumpy

Two volleyed in for Open World and two shot down in flames.

Not that I had high expectations after so many tries.  I did get one accepted "once" ... ha ha!

so who is using oracle result caching? ( makes me grumpy )

Not giving out too many details ... but some people trying to use this feature ( cough cough ) have had issues.

Getting an oracle 600 and having to restart a database instance is not necessarily good right?

Some things sound so good "in theory" and maybe in some distant release the ( oracle code issues ) will be all worked out.

Now staying away from using it ... ( cough cough ) ...

how to hint … a reminder

From Jonathan Lewis: how to hint part 1

A good primer there ...

no oracle for you this weekend … does not make me grumpy

Taking a long three day weekend and going to ( try anyhow ) to not even log into work network and not read email or ... anything.  Wow that's some bold action eh?

Tomorrow going to be competing in the Cleveland feis ( Irish step dancing competition ) with both daughters.  We are competing in parent child with a three hand reel for the Leneghan Academy of Irish dance.  Probably may the be (more...)

last post on GLOC 2014 conference … new technical stuff coming soon

One of the presentations I am going to work on next will be in the SQL Plan Management interaction/intersection area with AWR information.  At GLOC 2014 Craig Martin had a very nice one that kind of is kick starting my interest in coming up with some relevant / worthwhile.

For the conference itself it was an epic "best ever" kind of event that made one feel both valued/valuable for despite all the hard work (more...)

Very proud of my peeps … GLOC 2014 is rocking

At this time ... Friday night ... 2 1/2 days before Great Lakes Oracle Conference 2014 kicks off ( GLOC 2014 ) things are rocking and rolling.

We have a new grand total of attendee's and registrations ... sitting at 321 at the moment.  This is big for us ... top quality speakers / great workshops / most affordable conference ever.

So proud of everyone involved in bringing this conference together.  Lots of people to thank but number (more...)

going through Tom Kyte’s book chapter by chapter

One of the ( many varied ) things going on at my work place involves a lunch work/study group.  It probably would not surprise too many people to find out this was my idea to get going.

We have a core group of about 8 of us mostly DBA types but also a couple of developers.  Every two weeks we get together to discuss/review a chapter from Tom Kyte's ( latest version ) (more...)

missing my local conference makes me a little grumpy

Our big event here is a 2 1/2 day conference ( Great Lakes Oracle Conference aka GLOC ) is coming up soon in mid May and I am going to miss the first two days of it.  Not happy exactly but I do have a reasonable excuse.

My oldest daughter finishes her sophomore year at college ( Fordham in NYC ) and needs to get picked up ( and dorm room packed up ) and carted (more...)

adding NOT NULL columns to an existing table … implications make me grumpy

This is DBA basics 101 in the oracle world but well also something that we grumpy DBA types forget from time to time.  We have an existing table in a schema that is populated with data.  Something like this say:


create table dbaperf.has_data ( column_one varchar2(10) not null, column_two number(10) not null);

insert into dbaperf.has_data(column_one, column_two) values('First row',13 (more...)

another month almost gone … another presentation done at NEOOUG

Geez this month really just flew by it started with my presentation at Hotsos 2014.  Pretty well attended waiting for final evaluation information.  Then work work work ...

This Friday ( today 3/28/2014 ) I did my Hotsos presentation again but this time at my local user group.  I added "just three more slides" to try to give some additional information on PGA and program connections to people aka developers coming in cold (more...)

some days it is harder to be grumpy than others …

The official notification is out and the nomination that was submitted to recognize me as an Oracle Ace has been approved.  This is certainly an honor and along with my continued role at NEOOUG I am hoping to leverage this status to continue to help grow our user group and our yearly conference Great Lakes Oracle Conference ( GLOC )

Speaking of that our abstract selection has been finalized and you can see all (more...)

is this old school … using dbms_shared_pool keep to pin plsql code in shared pool?

These days with the shared pool area getting so large many people ( including me ) tend to think of reserving/pinning plsql code into the shared pool as an old school "probably no longer necessary" approach.  Of course many 11g systems are now running with 4 gb shared pools ( and much more sometimes ).

In my recent hotsos session I polled the attendee's and ( kind of as expected ) confirmed that most (more...)

final version of my Hotsos 2014 presentation

This is the "really really" final version because it was updated and some additional references added even after the presentation was delivered.

Hoping to do it at Open World 2014 so ... I guess this is the early version of that presentation eh?

You can find it here: Three approaches to shared pool monitoring Hotsos 2014

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.

(more...)

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...)