Re: New to RAC and need some ideas/suggestions
Date: Thu, 23 Aug 2012 07:24:30 -0500
Thanks David, that is a big help.
On Wed, Aug 22, 2012 at 5:39 PM, Herring Dave - dherri < Dave.Herring_at_acxiom.com> 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.
> DAVID HERRING
> Acxiom Corporation
> EML dave.herring_at_acxiom.com
> TEL 630.944.4762
> MBL 630.430.5988
> 1501 Opus Pl, Downers Grove, IL 60515, USA
> WWW.ACXIOM.COM <http://www.acxiom.com/>