DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Cannot Change Function definition (session locks)

  1. 03-21-2007, 02:26 PM #11
    daljitsb
    daljitsb is offline Member
    Join Date
    Jul 2003
    Posts
    136
    Quote Originally Posted by davey23uk
    well there is, cos you cant change it can you - the evidence speaks for itself
    Alright.
    Is there a way to find out which session/user/sql is using it at a given moment.

    -D
    Reply With Quote Reply With Quote
  2. 03-21-2007, 03:13 PM #12
    BV1963
    BV1963 is offline Senior Member
    Join Date
    Nov 2001
    Posts
    335
    Subject: COMPILATION OF PACKAGE IS HANGING ON LIBRARY CACHE LOCK AND LIBRARY CACHE
    Doc ID: Note:1054939.6 Type: TROUBLESHOOTING
    Last Revision Date: 18-MAY-2004 Status: PUBLISHED
    One, who thinks that the other one who thinks that know and does not know, does not know either!
    Reply With Quote Reply With Quote
  3. 03-23-2007, 07:48 AM #13
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    why not just query the SID, owner, object from v$access?

    To see if somebody is accessing those object.
    ---------------
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width