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 -> LONG RUNNING QUERIES

LONG RUNNING QUERIES

From: D S Tharpe <i5t_at_ornl.gov>
Date: 1998/08/22
Message-ID: <35DF364E.167EB0E7@ornl.gov>#1/1 






In monitoring an ORACLE database, is there anyway to proactively
check for long running queries (> 15 seconds in OLTP) without a
user calling and saying "my response time is so slow". How can I 
monitor the system for long running queries and know which
query(ies) is/are the culprits?



TIA,



D. Tharpe
Received on Sat Aug 22 1998 - 00:00:00 CDT












Original text of this message













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