Re: New to RAC and need some ideas/suggestions

From: Chris Taylor <>
Date: Thu, 23 Aug 2012 07:24:30 -0500
Message-ID: <>

Thanks David, that is a big help.

On Wed, Aug 22, 2012 at 5:39 PM, Herring Dave - dherri <> wrote:

> I realize this is a day late and possibly session history is lost due to
> memory space pressures, but one of the first things I do when I believe ASH
> may help is snapshot GV$ACTIVE_SESSION_HISTORY doing a CTAS. That way I
> won't loose any data before I have a chance to analyze it.
> If you know the SQL_IDs then you can obviously lookup in your CTAS on
> those to check ranges of times and concurrency. Or you could get the
> OBJECT_ID for the object in question and check the CTAS ASH table by
> CURRENT_OBJ#. To me ASH data is the best way to go for getting at the
> session info in this case.
> Acxiom Corporation
> TEL 630.944.4762
> MBL 630.430.5988
> 1501 Opus Pl, Downers Grove, IL 60515, USA

Received on Thu Aug 23 2012 - 07:24:30 CDT

Original text of this message