Hi,
Sorry I did not read his reply.
Yes, it may be reaped with it even in 11g. Also, I think you can
extract the recusive/sampling sql if possible. Try top_level_sql_id and sql
_id columns of dba_hist_active_sess_history view.
To add more, if the parallel SQL containes ORDER BY clause, in this case
database does implicit sampling which may suitable for your case.
On Thu, Feb 7, 2019, 18:49 Norman Dunbar <oracle@xxxxxxxxxxxxxxx wrote:
Hi Chinar,
On 07/02/2019 14:25, Chinar Aliyev wrote:
Hi.
Is it parallel query? Could you please post execution plan of it here?
Yes, parallel is involved as the tables are very large. Sorry, I can't
post an execution plan here though. :o(
Stefan has pointed me in the direction of a possible bug/feature though,
which might account for the disc accessing and dynamic sampling.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG
Company Number: 05132767
--
//www.freelists.org/webpage/oracle-l
