view resources intensive SQL query

Giganews Newsgroups
Subject: view resources intensive SQL query
Posted by:  chua…
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
Thank you
Boon Yiang