Re: New to RAC and need some ideas/suggestions
- From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
- To: Herring Dave - dherri <Dave.Herring@xxxxxxxxxx>
- Date: Thu, 23 Aug 2012 07:24:30 -0500
Thanks David, that is a big help.
Chris
On Wed, Aug 22, 2012 at 5:39 PM, Herring Dave - dherri <
Dave.Herring@xxxxxxxxxx> 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
> DBA
> Acxiom Corporation
> EML dave.herring@xxxxxxxxxx
> TEL 630.944.4762
> MBL 630.430.5988
> 1501 Opus Pl, Downers Grove, IL 60515, USA
> WWW.ACXIOM.COM <http://www.acxiom.com/>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
