Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Virginia
    Posts
    11

    Unanswered: Orphaned/phantom sessions?

    Hello,

    We had a session that the SysAdmin killed in UNIX via 'kill -9' instead of letting us kill it via onmode. However, the end user is having a problem logging in. It appears that the old session still has a lock out there somewhere. Is there a simple way to figure out which lock this orphan session has and kill it?

    Thanks

  2. #2
    Join Date
    Nov 2004
    Posts
    7

    Post

    HI,

    Use the query below to identify what locks this session had, maybe you will need restart the IDS to normalize this situation.

    -- Begin
    select substr(trim(dbsname) || "." || trim(tabname),1,30) as banco_tabela,
    substr(rowidlk,1,8) as linha, type as tipo,
    substr(sid,1,8) as sessao, substr(username,1,8) as usuario,
    substr(is_wlock,1,1) as blk,
    substr(waiter,1,8) as sesblk
    from syslocks l, syssessions s
    where l.owner = s.sid
    order by 4
    -- End

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •