Skip navigation.

Grumpy old DBA

Syndicate content
Updated: 10 hours 54 min ago

If you are in Cleveland don't miss our January 23 2015 NEOOUG meeting!

Fri, 2015-01-16 14:09
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 Big Data ish related ( and we have a great announcement coming up on a workshop for our May GLOC 2015 conference ).
Here is the info on Jan 23 2015 meeting

I hope to see you there!
Categories: DBA Blogs

OT: On a musical note for 2014's year ending

Fri, 2014-12-26 12:32
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 you at times.

Taylor Swift knocked it out of the ballpark with 1989.

Also digging new one by Lana Del Rey.

Discovered one that I should have known about a long time ago "Gov't Mule" album Live with a little help from our friends is straight out loud good rock and roll well put together.

My latest addition that I am just listening to is the Delphines "Colfax" this one strays fairly close to some kind of cross between rock and roll and folk/country but seems like a well put together sophisticated album that is a little slower paced than many.

Categories: DBA Blogs

Happy holidays from the grumpy old dba!

Thu, 2014-12-25 08:57
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 application

GLOC 2015 conference registration ( May 18-20 2015 )
Categories: DBA Blogs

ORA 700's make me grumpy ( well or at least confused )

Wed, 2014-12-03 09:16
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 test vm I am setting up ( Database using ASM and also OEM ).

ORA 700 [kskvmstatact: excessive swapping observed]

So anyway I started doing some looking around at the memory config stuff after seeing that ( but that's a longer story ).

Categories: DBA Blogs

Great Lakes Oracle Conference 2015 call for speakers now open

Sun, 2014-11-23 12:17
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 gear for the next two days.

Call for presentations information here: GLOC speakers

Please consider joining us in Cleveland and hope to see you there!

John Hurley @grumpyolddba and NEOOUG President

Categories: DBA Blogs

rmoug 2015 presentation ready to go ... makes me ( not ) grumpy

Sun, 2014-11-09 19:04
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 ...

Categories: DBA Blogs

handy ash queries to look at blocked sessions ( how many when for what event ) ...

Sun, 2014-11-09 15:13
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, ash.sql_opname
WHERE ash.SAMPLE_TIME >= TO_DATE('01-NOV-2014 13:00', 'DD-MON-YYYY HH24:MI')
  and ash.sample_time <= to_date('08-NOV-2014 17:00', 'DD-MON-YYYY HH24:MI')
-- and ash.event like 'enq: TX - row%'
and blocking_session is not null
group by to_char(ash.sample_time,'MM/DD/YYYY HH24:MI:SS'), ash.event, ash.sql_id, ash.sql_opname, ash.blocking_session, ash.blocking_session_serial#
order by 1) ash_data,
v$sqlarea sqlinfo
where ash_data.sql_id = sqlinfo.sql_id
and sessions_blocked >= 1
order by what_time


For example once you have narrowed it down to something interesting looking ( who is blocked / what sql_id / what event ) ... you can use something like this.  I am now looking at any active history information on what the blockers were doing or waiting on.

select * from DBA_HIST_ACTIVE_SESS_HISTORY where ( session_id, session_serial# ) in (
SELECT blocking_session, blocking_session_serial# FROM DBA_HIST_ACTIVE_SESS_HISTORY
and event like 'enq: TX - row%'
and sql_id = '0kbzgn17vbfc5' )
and SAMPLE_TIME > TO_DATE('06-NOV-2014 14:30', 'DD-MON-YYYY HH24:MI')
order by sample_time
Categories: DBA Blogs

setting pctfree to 0 for regular indexes ... ( not familiar with this theory ) ... help!?

Fri, 2014-11-07 12:31
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 stick with the tried and true default values here.  I also am skeptical of this belief.

It seems to me like a very small amount of potential tangible gain in space usage while causing potential problems down the road.

Even if this theory is somehow true ( don't think so ) ... what happens in the future when something changes in the application and what one was initially told ( only inserts and deletes ) changes.

Anyone seen / heard /debunked this theory?  Any idea of where it comes from?

Thanks John   
Categories: DBA Blogs

getting re certified for 12c ( makes me grumpy ) ...

Wed, 2014-10-22 08:02
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 yes real classes with live instructors so it made sense to actually take the tests my students were taking.

But it's been a really long time now since I did the 10g new features class and did the 10g OCP upgrade exam.  I thought about doing the 11g upgrade at one point ( and attended the 11g new features class ) but never finished it.

Oracle has recently announced a change in policy where old certifications will start "aging out" / expiring.  I don't like this change at all but well it's probably time for me to do the 12c new features class and get 12c certified.

So now it's going to be somewhat of a nightmare to jump through all the hoops.  I have paper copies of ( some of anyhow ) the OCP's and text exams.

You used to take the tests at Sylvan Prometric sites but now there seems to be some other players involved in this whole thing.  Plus I don't have access to any of the old work emails.

This is probably going to make me a wee bit grumpy getting this all sorted out but maybe please please someone inside at oracle might bail me out?

Update on 10/24/2014: So false alarm this is getting sorted out much faster than I was imagining thanks to the oracle university support team.
Categories: DBA Blogs

Please look at latest Oct 2014 Oracle patching

Wed, 2014-10-15 11:23
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 ...
Categories: DBA Blogs

grumpy old dba goes to the mountains ( have to ski somewhere )?

Sat, 2014-10-11 14:47
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 to present at the same time as people like Alex Gorbachev / Bill Inmon / Heli Helskyaho ... so well maybe room is a little sparse but I will be attempting to bribe people into attending my session so we will see how that goes.

Thanks RMOUG!

PS on another topic more news soon on our GLOC 2015 conference coming up in May 2015!

Categories: DBA Blogs