You can use Performance Manager and a chart named top sql You can also
dynamic view v$sqlarea:

Select *
From v$sqlarea
Where command_type = 3 -- for select statements
-- for insert statements you will use 2 If you would like to display all
activity on your db omit the where clause

Best Regards
Krystian Zieja / mob

-----Wiadomo¶æ oryginalna-----
Od: Mary Chibwana
[mailto:oracledba-ezmlmshield-x32748058.[Email address protected]
Wys³ano: 29 lipca 2005 16:58
Do: LazyDBA Discussion
Temat: sql statements

Please help

Iam using oracle 9i.
I would like to check for the sql statements that are running
on the database and how much of the resources they are using.


Maria


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page