tags:

views:

134

answers:

3
Q: 

How to know which stored procedures are running in an Oracle database?

I need to know which stored procedures are running. It's not an option to "mark" the stored procedures changing their source.

Thank you very much.

A: 

This may be similar to another post.

http://stackoverflow.com/questions/250792/how-do-i-log-trace-oracle-stored-procedure-calls-with-parameter-values

Aethyrial  2009-07-09 19:30:39
Is not an option to modify the source code of the procedures...
german1981  2009-07-09 19:46:01
+1  A: 

Not sure about doing that for the entire database, but did you try using DBMS_TRACE?

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_trace.htm#CACEIHAH

Pop  2009-07-09 23:48:03
+2  A: 

This blogpost of mine tells you all about it: http://rwijk.blogspot.com/2008/11/executingpackagessql.html

Regards, Rob.

Rob van Wijk  2009-07-10 07:51:32
+1... nice - I hadn't considered the v$session plsql_entry_object_id and plsql_entry_subprogram_id limitations that you discuss
dpbradley  2009-07-10 12:35:42

related questions

Backup SQL Schema Only?
Sql to query a dbs scheme
Timer-based event triggers
Sql query, count and group by
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting
How do I use T-SQL Group By
What all do I need to escape when sending a (My)SQL query?
Split String in SQL
Datatable vs Dataset
ASP.NET MVC "CRUD" Database Sample
Convert HashBytes to VarChar
Best Book for a new Database Developer
What is the best way to avoid SQL injection attacks?
What language do you use for Postgresql triggers and stored procedures?
What is the best way to handle multiple permission types?
How do I index a database field
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
Is there a version control system for database structure changes?
How to export data from SQL Server 2005 to MySQL
ASP.NET Site Maps
Decoding T-SQL CAST in C#/VB.net
Flat File Databases in PHP