Is there any event like library cache lock/pin in
v$session_wait for the hanging session?

If yes, you need to find which session holds the lock
and kill it.

Jack
--- "Lages, Carl" <[Email Address Removed] wrote:
> Yeah that did it. Friday afternoon braindeath.
> Thanks,
> Chris
>
> -----Original Message-----
> From: Sarnowski, Chris [mailto:[Email Address Removed] Sent: Friday, August 31, 2001 2:31 PM
> To: LazyDBA.com Discussion
> Subject: RE: cannot drop package
>
>
> Is the package currently being executed? Check the
> 'OBJECT' field of v$access for the package name.
>
> HTH,
> -Chris
>
> > -----Original Message-----
> > From: Lages, Carl [mailto:[Email Address Removed] > Sent: Friday, August 31, 2001 2:16 PM
> > To: LazyDBA.com Discussion
> > Subject: cannot drop package
> >
> >
> > Hi,
> > I am trying to drop a package and my session just
> hangs. I
> > have tried using
> > toad and sql*plus and from different pc's. I also
> tried to
> > create or replace
> > the package and that just hangs also. I have the
> correct
> > permissions. I
> > checked for a lock onthe object but there were
> none. What
> > else could I try?
> > The sql is fine because if I try to create the
> package under
> > a different
> > name it works.
> > Thanks in advance,
> > Carl
> >
> >
> >
> >
> > --------
> > Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> LEGAL NOTICE - Unless expressly stated otherwise,
> this message is
> confidential and may be privileged. It is intended
> for the addressee(s)
> only. Access to this e-mail by anyone else is
> unauthorized. If you are not
> an addressee, any disclosure or copying of the
> contents or any action taken
> (or not taken) in reliance on it is unauthorized and
> may be unlawful. If you
> are not an addressee, please inform the sender
> immediately.
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
Oracle LazyDBA home page