FAQ
Well, yes, that could happen if the dynamic sampling level was high and the query was rarely executed or a one-off. Neither of these is necessarily the case when you see a long execution plan and a mention of dynamic sampling in the footnote.

Original Message --------
Subject: AW: Dynamic sampling
From: Petr Novak
To: william_at_williamrobertson.net, ORACLE-L
Date: 11/11/2010 07:40
But what if the the dynamic sampling consumes more resources the the statements itself ? I have also seen such database. It is better to have correct statistics.

Best Regards,
Petr
________________________________________
Von: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org]" im Auftrag von"William Robertson [william_at_williamrobertson.net]
Gesendet: Donnerstag, 11. November 2010 08:02
Bis: ORACLE-L
Betreff: Re: Dynamic sampling

What have the number of lines in the plan and the predicates section got to do with dynamic sampling? Are you saying dynamic sampling is a bad thing? It seems like an excellent feature to me.

William Robertson

-------- Original Message --------
Subject: Dynamic sampling
From: Hemant K Chitale
To: ORACLE-L
Date: 11/11/2010 03:43
AARGH!
What you do when DBMS_XPLAN.DISPLAY_CURSOR shows a 190 line Plan with 205 entries in the Predicates section and then adds "dynamic sampling used".

Just venting my frustration.
--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 11, '10 at 7:55a
activeNov 11, '10 at 7:55a
posts1
users1
websiteoracle.com

1 user in discussion

William Robertson: 1 post

People

Translate

site design / logo © 2022 Grokbase