matching sql_ids to the sql_ids of the recursive dynamic sampling

From: Mathias Zarick <Mathias.Zarick_at_trivadis.com>
Date: Wed, 20 Aug 2014 14:15:37 +0000
Message-ID: <DA06C082C7430A439612B1F8B412F588A0673C1A_at_smxc002.trivadis.com>

Hi List,

we need to troubleshoot a problem around excessive dynamic sampling and library cache locks at my client. Probably we are facing a bug 14542720.
For the moment I'm looking for a way of how to match the sql_id's that have used dynamic sampling during parse to the sql_ids of the dynamic sampling itself (those queries with the SELECT /* OPT_DYN_SAMP */ ...)

any idea?
TIA Mathias

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 20 2014 - 16:15:37 CEST

This message: [ Message body ]
Next message: Jeremy Schneider: "Re: OFA and Linux FHS (or other unix standards)"
Previous message: Rich Jesse: "Re: OFA and Linux FHS (or other unix standards)"
Next in thread: Jure Bratina: "Re: matching sql_ids to the sql_ids of the recursive dynamic sampling"
Reply: Jure Bratina: "Re: matching sql_ids to the sql_ids of the recursive dynamic sampling"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message