IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New got a lead
[link|http://asktom.oracle.com/pls/ask/f?p=4950:8:10565570903886826970::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:839412906735|Ask Tom "Questions on Locking"]
SELECT (SELECT username\n          FROM v$session\n         WHERE SID = a.SID) blocker,\n       a.SID,\n       ' is blocking ',\n       (SELECT username\n          FROM v$session\n         WHERE SID = b.SID) blockee,\n       b.SID\n  FROM v$lock a,\n       v$lock b\n WHERE a.BLOCK = 1\n   AND b.request > 0\n   AND a.id1 = b.id1\n   AND a.id2 = b.id2


I had to change username to osuser to get the results I needed as our software logs everybody in as the same username.

In order for Joe User to run it, I had to then do:
grant select on v_$session to gl_prod\n\ngrant select on v_$lock to gl_prod
I'm not sure why it's v_$ instead of v$, but since it worked I'm not going to worry about it.
Darrell Spice, Jr.            Trendy yet complex\nPeople seek me out - though they're not sure why\n[link|http://spiceware.org/gallery/ArtisticOverpass|Artistic Overpass]                      [link|http://www.spiceware.org/|SpiceWare]
New I can't do that
I'm not sure why it's v_$ instead of v$, but since it worked I'm not going to worry about it.
I'd have to know. It's like having a song stuck in my head and I can't remember who it's by. I can't drop it until I know.
===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
New I seem to recall
One refers to in-memory ONLY Oracle settings and the other refers to both real on-disk ones.

But I could be wrong.
New It does bug me, but
this coming week I'll be flying solo for IT support. Our PC guy's new son arrived a couple weeks early so he's out, our junior programmer's finally got the paperwork cleared to bring his wife over from Vietnam so he's out, and the manager's on vacation. I'll have forgotten about v_$ by the time I can look into it.
Darrell Spice, Jr.            Trendy yet complex\nPeople seek me out - though they're not sure why\n[link|http://spiceware.org/gallery/ArtisticOverpass|Artistic Overpass]                      [link|http://www.spiceware.org/|SpiceWare]
New It's a synonym
[link|http://www.ittopics.com/default.aspx?page=ed51cde3-d979-4daf-afae-fa6192562ea9&article=cd6af968-f287-4033-ba92-1f5bd09ab5e5|Oracle Dynamic Performance Views: V$ Views, V_$ Views and GV$ Views]
The actual dynamic performance views are identified by the prefix V_$. Public synonyms for these views have the prefix V$. Database administrators and other users should access only the V$ objects, not the V_$ objects.
Darrell Spice, Jr.            Trendy yet complex\nPeople seek me out - though they're not sure why\n[link|http://spiceware.org/gallery/ArtisticOverpass|Artistic Overpass]                      [link|http://www.spiceware.org/|SpiceWare]
     way for end-users to view Oracle record locks? - (SpiceWare) - (5)
         got a lead - (SpiceWare) - (4)
             I can't do that - (drewk) - (3)
                 I seem to recall - (broomberg)
                 It does bug me, but - (SpiceWare)
                 It's a synonym - (SpiceWare)

It's administration policy.
134 ms