|Subject:||view resources intensive SQL query|
|Date:||14 Sep 2006|
May i know are there any tables in Oracle 8i where i can check what are
the SQL queries submitted (not necessarily current active session but
queries run for the last weeks too ) by users but are very resource
intensive ? this will help to highlight to users by identifying the
query, space used by that query etc and to look into tuning this query.
for some advice please