which view to check queries 1

[huchen]

I want to see the queries other people issued to the database and forgot which system view I should check. Could you give me a hint?
Here is what I want to do: one process in my application takes long time and I want to find out which query is the cause.
Thanks a million!!!!!!

 

[Scunningham99]

hi

there are a few

v$session_longops for queries over i think 4 or six seconds..

select * from v$sql --to view no of parsed loads, sorts, disk reads of a particular sql statement for performance issues

select * from v$sqltext --to view sqltext of sql statement

select * from v$sqlarea --This view lists statistics on shared SQL area and contains one row per
--sql statement. It provides statistics on SQL statements that are in memory
--parsed and ready for execution!

select * from v$sql_plan --to view the exact execution for each SQL statement in the library cache! (to view its cost CBO path etc.)

hth

Sy UK

 

[huchen]

Thank you very much! These are all I want.