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