All ready to roll with RMOUG 2015 Training days presentation "OS Truth, little white lies, and the Oracle Wait Interface".
Best of course to come to RMOUG 2015 Training days ... but this is link to pdf version of the presentation here: John Hurley RMOUG 2015
If you are out there ( very excited personally my first time at this conference ) please kick me and say hello. Ok maybe skip the kicking part ...
Licensing may be required ... please check if applicable.
A query like this can be used to check how much blocking and what session it was ... ( so then you can drill into those blockers sessions ). Probably can be done easily with some kind of rollup query?
Adjust SAMPLE_TIMEs in where clause below.select ash_data.*, substr(sqlinfo.sql_text,1,70)
(SELECT to_char(ash.sample_time,'MM/DD/YYYY HH24:MI:SS') what_time, count(*) sessions_blocked, ash.event, ash.blocking_session, ash.blocking_session_serial#, ash.sql_id, (more...)
One of my coworkers has this theory ( habit ) of creating new regular indexes on regular table columns. Not compressed indexes or anything special.
He is currently believing ( back from somewhere / not sure of the origin ) that "if a table only gets inserts and deletes" that any indexes created on that table should be set with pctfree set to 0.
I do not agree. In my opinion one should (more...)
So let's be honest at the beginning here.
I have way too many professional certifications for any reasonable semi honest human being. Along with two old Solaris admin certifications 7 and 8 I am ( besides an MBA degree ha ha ) OCP in 7.3 / 8.0 / 8i / 9i / 10g. At one point a ways back I was teaching all the OCP curriculum for a local community college (more...)
This one looks like the real thing ... getting advice to "not skip" the patching process for a whole bunch of things included here.
I'm just saying ...
So in a slight reversal of submit so many presentation abstracts get rejected so many times the Rocky Mountain training days 2015 will be featuring me! Wow pumped yikes this should be a ton of fun!
Ok to be totally honest Maria Colgan is keynoting not me ( shocking news still trying to get over it ).Rocky Mountain training days 2015
Looks like a top batch of speakers and topics ... I only have (more...)
Jim the smooth talking always motivated Oracle Ace Director did two great presentations for us here at NEOOUG on Friday September 19th.
His presentations can be found 12c SQL that almost tunes itself
and 12c How hot is your data?
The Rocky Mountain Oracle Users Group has been big and organized for a very long time. I have never been out there ( my bad ) but am hoping to change that situation in 2015.
Abstracts are being accepted for Training Days 2015 ... my first one is in there now thinking about a second submission but my Hotsos 2014 presentation needs some more work/fixing. Ok lets be honest I need to shrink it (more...)
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...)
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...)
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!
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 ) ...
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...)
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...)
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...)
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...)
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...)
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...)
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...)