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

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

Here is a way to use the old search interface for oracle doc ( thanks Natalka )!

Aha! Found the old search interface :

for 11.1: http://www.oracle.com/pls/db111/search
for 11.2: http://www.oracle.com/pls/db112/search

Great Lakes Oracle Conference 2015 call for speakers now open

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

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

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


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

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, (more...)

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

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

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

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

Please look at latest Oct 2014 Oracle patching

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

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

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

big thanks to Jim Czuprynski for NEOOUG meeting presentations

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?

Thanks Jim!

keeping my fingers crossed just submitted abstract for RMOUG 2015 Training Days …

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

have fun anyone heading out to OOW 2014

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

long project nearing completion at work and a good book available

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

Well dang sessions got rejected ( yes again ) at Open World 2014 … makes me grumpy

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!

so who is using oracle result caching? ( makes me grumpy )

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

how to hint … a reminder

From Jonathan Lewis: how to hint part 1

A good primer there ...

no oracle for you this weekend … does not make me grumpy

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

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