Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

How do I get the session id of particular package

This is a discussion on How do I get the session id of particular package within the Oracle forums, part of the Databases category; 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 ...

Geeks Talk > Databases > Oracle How do I get the session id of particular package

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   04-18-2007

ssusmitaa Junior Member   Join Date: Mar 2007 Location: india Posts: 1 Thanks: 0 Thanked 1 Time in 1 Post

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.

The Following User Says Thank You to ssusmitaa For This Useful Post:

ashish kumar

Sponsored Links

#2 (permalink)   04-24-2007

arun_official_contact Junior Member   Join Date: Apr 2007 Location: bhubaneswar Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

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 (permalink)   04-25-2007

Barbie Expert Member   Join Date: Dec 2006 Location: Chennai Posts: 197 Thanks: 2 Thanked 16 Times in 14 Posts

Re: How do I get the session id of particular package where shall we find those details in TOAD?

#4 (permalink)   04-29-2007

balasubramanian.j Junior Member   Join Date: Apr 2007 Location: india Posts: 11 Thanks: 0 Thanked 1 Time in 1 Post

Re: How do I get the session id of particular package Quote: Originally Posted by ssusmitaa 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 (permalink)   06-25-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

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 (permalink)   06-25-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

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

Geeks Talk > Databases > Oracle

« Query | hi »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Quiz Package (100 Questions) Free Download	admin	Downloads	135	6 Days Ago 05:36 AM
Session Manager	Lokesh M	ASP.NET	1	06-04-2008 09:52 AM
Oracle Package.function	Yajnas	Oracle	2	06-25-2007 03:10 AM
Today's package includes both StarPort Professional which will allow you to create vi	JobHelper	Geeks Lounge	0	02-19-2007 07:40 AM
Oracle package question	always_rgsm	Oracle	5	01-23-2007 08:35 AM

All times are GMT -4. The time now is 01:11 AM.