Skip navigation.

Grumpy old DBA

Syndicate content
Updated: 22 hours 9 min ago

Final version of RMOUG 2015 presentation and script files are here ...

Sat, 2015-02-21 16:46
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 anyone has any problems using this and sorry I thought I would get this updated and available Thursday.

Thanks so much to RMOUG!

John
Categories: DBA Blogs

Just a few days left to submit abstracts for GLOC 2015

Wed, 2015-02-04 14:09
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.  Please consider attending even if you do not submit a presentation proposal!

Call for abstracts is GLOC 2015 abstract call

Thanks! John
Categories: DBA Blogs

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 12.1.0.2 using ASM and also OEM 12.1.0.4 ).

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)
from
(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
FROM DBA_HIST_ACTIVE_SESS_HISTORY ash
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
WHERE SAMPLE_TIME > TO_DATE('06-NOV-2014 14:00', 'DD-MON-YYYY HH24:MI')
AND SAMPLE_TIME < TO_DATE('06-NOV-2014 15:00', 'DD-MON-YYYY HH24:MI')
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')
AND SAMPLE_TIME < TO_DATE('06-NOV-2014 15:00', '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