Results 1 to 6 of 6

Thread: How do I get the session id of particular package

  1. #1
    Junior Member
    Join Date
    Mar 2007
    Answers
    1

    How do I get the session id of particular package

    I face some problem regarding oracle package execution. One of the currently running package has locked some table. So I want to kill the session. How do I get the session id of particular currently running package.


  2. #2

    Re: How do I get the session id of particular package

    The DBA option in TOAD can help you on this. Here you can view each and every details of a particular session. For further details let me know.


  3. #3
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    Re: How do I get the session id of particular package

    where shall we find those details in TOAD?


  4. #4

    Re: How do I get the session id of particular package

    Quote Originally Posted by ssusmitaa View Post
    I face some problem regarding oracle package execution. One of the currently running package has locked some table. So I want to kill the session. How do I get the session id of particular currently running package.
    Hello ssusmita,

    U have to use the dynamic views to resolve this problem.

    U can find the information abt the query package by v$sql or v$sqltext view. There it shows which session is executing that package. Based on which query ur v$session to identify the username , serial# and the sid with which u can kil that session.

    Hope this helps..
    Balasubramanian.J


  5. #5
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: How do I get the session id of particular package

    You can get the session id of particular currently running package.
    But that session id is not of the package ,but of the user who is executing it.


  6. #6
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: How do I get the session id of particular package

    You can find the session sid and other info from this query.

    select sid , serial#, username , osuser, machine , status, program, module
    from v$SESSION


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact