Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> view resources intensive SQL query

view resources intensive SQL query

From: <chuaby_at_hotmail.com>
Date: 14 Sep 2006 20:08:22 -0700
Message-ID: <1158289702.309251.316990@i3g2000cwc.googlegroups.com> 





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
Received on Thu Sep 14 2006 - 22:08:22 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US