Locks and Who & finger command
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Locks and Who & finger command

  1. #1
    Join Date
    May 2003
    Posts
    46

    Locks and Who & finger command

    When there is blocking locks, users coming and pressurising to find who is locking etc....using TOAD, ps-ef|grep spid etc I can find out what user is doing, what module is affected but difficult to find out who is the actual user caz it gives generic os username, oracle username, (caz many people share same name).

    Is there any way to find out actual user using like WHO -T or finger or any other better way.

    Any help?

    Ramg

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    You also have machine and terminal in v$session, if it helps.
    Otherwise if all are using same OS user and same DB user, with what data would you like to describe the user.
    Hash value of DNA code?
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

Posting Permissions

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



Click Here to Expand Forum to Full Width