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: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 28 Nov 2006 15:18:11 -0800
Message-ID: <1164755889.62297@bubbleator.drizzle.com>


Andreas Piesk wrote:
> 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

gv$active_session_history

contains the following columns:

WAIT_CLASS      VARCHAR2(64)
WAIT_CLASS_ID   NUMBER
WAIT_TIME       NUMBER
TIME_WAITED     NUMBER

Not there?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Nov 28 2006 - 17:18:11 CST

Original text of this message

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