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 -> log all sql commands

log all sql commands

From: lenny <non.te_at_la.dico>
Date: Tue, 31 Jan 2006 17:59:21 +0100
Message-ID: <MHMDf.5445$6e2.4794@news.edisontel.com> 





Is it possible to log all the sql that oracle 8i runs ?
maybe add the querys in a db and delete them when older than a selected 
time.


there are some problems on the server and we want to check if there is a 
strange query that block all the server (linux) for a lot of minutes.



thanks


Lenny 
Received on Tue Jan 31 2006 - 10:59:21 CST












Original text of this message













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