DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Stored Procedure

  1. 02-06-2004, 12:40 AM #1
    Rohit's Avatar
    Rohit
    Rohit is offline Member
    Join Date
    Aug 2002
    Posts
    176

    Stored Procedure

    How do we find the stored procedures that are currently executing...



    Thanks
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed
    Reply With Quote Reply With Quote
  2. 02-06-2004, 02:05 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    I don't think you can easily identify a proceudre is running or not.
    BUT you ca use dbms_application_info.set_module in your package/procedure to set the module and action. which can be quried V$SESSION's MODULE column.

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    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