Wow I had a great time presenting at RMOUG 2015. The room was absolutely packed and I felt presentation went pretty well ( so let's see what the evaluation numbers show ).
Here is a link (Final version presentation and supporting files
) to zip file containing the final version of the presentation as well the script and sql file shown at the end of the presentation. Please let me know if (more...)
The Cleveland based Great Lakes Oracle Conference 2015 is going to be a big event. Hoping to pass 350 in attendance its going to be two days of track based sessions and a 1/2 day of workshops on monday.
Full details here GLOC 2015
We have a great set of abstracts in already and we want you to consider submitting one before we stop accepting them ( February 9th 2015 ) is last day. (more...)
Please join us next friday for our 1st 2015 regular meeting. Mark Rabne our resident Oracle technical geek will be taking us through major 2014 Oracle technology and application announcements. Kind of a recap of Oracle Open World 2014 major items plus some additional ones after that.
It's the usual deal at the Rockside Road Oracle office so free lunch at noon and networking opportunities. Meeting starts at 1 pm.
Our March meeting will be (more...)
There have been some really strong albums that impressed me this year. I tend to like loud rock stuff but do mix it up somewhat. What follows is just some ramblings:
The Drive By Truckers have a tremendous album out "English Oceans" if you like rock this is a no brainer.
Jolie Hollands "Wine Dark Sea" album is stunningly magnificent. It varies quite a bit rocks out and blues it out and then just charms (more...)
Best wishes for everyone heading into 2015!
I am looking forward to RMOUG Training days 2015 ( speaking there ) while the planning for our conference here in Cleveland GLOC 2015 kicks into high gear.
Our conference has call for abstracts open now and conference registration is also open. For us the registrations typically don't start rolling in big time until March timeframe.
Please consider submitting a presentation abstract!GLOC 2015 speaker applicationGLOC 2015 (more...)
Geez Louise I guess I coulda/shoulda known about this before now.
At some point the oracle software ( 11.2 ish ? 11.1 ish ? ) now starts getting worried and kind of grumpy.
You apparently can get ORA 700's under certain circumstances. It's not a huge problem apparently ( yet ) when the software decides to let you know ... ( but it might become one later maybe ? ).
I saw this one on a new (more...)
Calling all geeks speakers big data nerds and application whiz kids the Great Lakes Oracle Conference ( GLOC ) is open for abstracts/presentation proposals ( May 18-20 2015 ).
This is a growing high quality regional conference in Cleveland where we are hoping to pass 350 ( 400? ) in attendance this year. We have Kerry Osborne and Steven Feuerstein doing keynotes and on Monday 1/2 day workshops before the conference kicks into high (more...)
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 ) ...