Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

find out a process that update an specific table

896976Jun 18 2015 — edited Jun 18 2015

How I can find out the name of the process that updates an specific table in the database.

I try things like this

SELECT * FROM all_tab_modifications

   WHERE table_name like 'GOBS%'

it shows the inserts, updates counts but not the name of the process that actually does the update

Thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2015
Added on Jun 18 2015
2 comments
1,172 views