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 -> Re: sql statements missing in continued tracefile

Re: sql statements missing in continued tracefile

From: Andreas Piesk <a.piesk_at_gmx.net>
Date: 28 Nov 2006 15:06:36 -0800
Message-ID: <1164755196.625997.292490@j72g2000cwa.googlegroups.com> 





DA Morgan schrieb:


>

> You mention AWR. Have you looked into ASH (Active Session History)?




actually i did but so far i haven't found the root of the problem with
it.


imagine 36000 identical statements per hour where only one runs too
long. to catch this one i need a detailed history with all wait events
and bind variables. IMHO only sql trace can provide that but i may be
wrong.



thanks & regards,


-ap
Received on Tue Nov 28 2006 - 17:06:36 CST












Original text of this message













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