Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

performance Tuning 10g reference poster
 
Oracle training in Linux 

commands
 
Oracle training 

Excel
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> package will not re-compile
acesiowa
post Dec 3 2008, 01:27 PM
Post #1


Advanced Member
***

Group: Members
Posts: 42
Joined: 24-January 08
Member No.: 16,432



In our development environment we need to re-compile packages as we change our code. Once in a while a session will hold onto a package, like it is being used, restricting me from compiling it.

Is there a way to find out what SID is holding on to the package in order for me to kill it?


--------------------
acesiowa
Go to the top of the page
 
+Quote Post
acesiowa
post Dec 3 2008, 01:37 PM
Post #2


Advanced Member
***

Group: Members
Posts: 42
Joined: 24-January 08
Member No.: 16,432



QUOTE (acesiowa @ Dec 3 2008, 01:28 PM) *
In our development environment we need to re-compile packages as we change our code. Once in a while a session will hold onto a package, like it is being used, restricting me from compiling it.

Is there a way to find out what SID is holding on to the package in order for me to kill it?


Just the name of the view will work. I don't want to take up any more time than in neccessary. With the name of the view, I can figure out what columns I need.


--------------------
acesiowa
Go to the top of the page
 
+Quote Post
acesiowa
post Dec 3 2008, 02:05 PM
Post #3


Advanced Member
***

Group: Members
Posts: 42
Joined: 24-January 08
Member No.: 16,432



QUOTE (acesiowa @ Dec 3 2008, 01:38 PM) *
Just the name of the view will work. I don't want to take up any more time than in neccessary. With the name of the view, I can figure out what columns I need.



select x.sid
from v$session x, v$sqltext y
where x.sql_address = y.address
and y.sql_text like '%<package name>%';

figured it out

thanks anyway


--------------------
acesiowa
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 18th April 2014 - 03:00 AM