After Hours

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion

Locked

The Blog of a Lazy Lurker

By Lazy Lurker ·
Tags: Off Topic
blog root

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Uh-oh. A blog post ...

by Lazy Lurker In reply to The Blog of a Lazy Lurker

I will get to being lazy a some point soon.  I promise.<br />
<br />
So what to I do?  I am an Oracle DBA.  Mostly, I have been
relegated to the realms of physical and support work.  I got
dragged there --kicking and screaming -- about six years ago.  All
the application design work I loved was ripped from my grasp. 
Begging and pleading got me a lot of empty promises, but here I
remain.  Why?  Why must I here and manage this end of the
databases and instance?<br />
<br />
Because I'm good at it.<br />
<br />
Damn.  Shot in the foot by competence yet again.<br />
<br />
<br />
Well, perhaps I can share something with you that SOMEONE can use.<br />

Collapse -

Locking madness

by Lazy Lurker In reply to The Blog of a Lazy Lurker

OK, what gives today?  I actually had to fix a  major
production issue.  That makes two (or maybe three) this
month!  Somebody is playing with my karma over here.<br />
<br />
It was actually pretty simple.  Citrix-deployed app lost contact
with the user but did not clean up.  So a phantom session was
sitting holding a lock.  The tricky part was wading through the
pile of queued up requests to find the locking session.<br />
<br />
It would be a snap -- except for an outstanding bug in my
version.  An old favourite script does not work in this version
because when I try to join multiple copies of V$LOCK, I get
locked!  Major bummer.<br />
<br />
Fortunately, I reworked the script months ago.  I select
everything from the views into a temporary table first, then work with
that.  The bug does not get in my way; I get my answer faster than
I can notice the lag.<br />
<br />
A few judicious "alter system kill session" commands and I get moved a
few places away from the top of the "Who to fire next?" list.<br />
<br />
<br />
I will post the script if the following can be done:<br />
<br />
1) I can find a place to put it<br />
2) I can figure out how to put it there<br />
3) I can be bothered to try (hey, I'm lazy, remember)<br />
<br />
<br />

Related Discussions

Related Forums