RE: Oracle Tuning Question

Hi Bradly,
I successfully found the below script at the web site given by u and that solved
my problem. Thanks a lot for ur kind help.

 select sa.sql_text,s.username,s.machine,s.program  from v$sqlarea sa,v$session s
 where s.sql_address=sa.address
 and s.sql_hash_value=sa.hash_value
 order by sa.buffer_gets desc

Murtaza.

>Ali:
> Have you looked at the scripts offered by dbasupport?
>They should prove useful.
>
>http://www.dbasupport.com/scripts/Administration/Session_Management/

-----Original Message-----
Sent: Saturday, June 17, 2000 5:05 AM
To: Multiple recipients of list ORACLE-L

Hi Jared,
Thank you for this script but I think i was not clear while explaining my problem. Through v$sqlarea view i detected some high resource usage SQL. Now i want to know from which machine or terminal this sql statement is coming from. All end users of the database use the same schema so i want to know from which machine that SQL statement is coming from. I want to know the machine or terminal name so that i can identify which particular application is submitting the high resource SQL statement. By the way that high resource SQL is a cartesian product and our programmers are having difficulty identifying from which application that SQL statement is being submitted. Any help is this regard would be highly appreciated. Received on Sun Jun 18 2000 - 10:20:07 CDT