Ask a Question

Question

sql query

pts.

Tags:

Database

IBM DB2

Oracle

what is the query to find which user is executing what sql statement

Asked: November 11, 2005 1:09 AM Last updated: November 15, 2005 1:05 PM

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

Kurthp 195 pts. · Accepted Answer · 2005-11-15T13:05:48+00:00

Thanks. We'll let you know when a new response is added.

The following rudimentary script will show you the basics. You can expand on this to show what you need.

select b.sid, b.username, a.sql_text
from v$sqlarea a,
v$session b
where a.address=b.sql_address

Oracle’s Enterprise Manager ‘Top Sessions’, ‘Top SQL’ provides a good gui interface.