view resources intensive SQL query

Giganews Newsgroups
Subject: view resources intensive SQL query
Posted by:  chua…@hotmail.com
Date: 14 Sep 2006

Hi

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

Replies