matching sql_ids to the sql_ids of the recursive dynamic sampling

  • From: Mathias Zarick <Mathias.Zarick@xxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 20 Aug 2014 14:15:37 +0000

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

Other related posts: