Gather Stats and auto_dop

From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Tue, 31 Mar 2020 10:12:12 +0200
Message-ID: <e91f0eb4-760c-04cd-b2f6-6bf5c09f4908_at_bluewin.ch>

Hi,

IHAC who is using AUTO DOP (parallel_degree_policy = auto) . It does not seem to work with gather_stats.
Probably because Gather_stats generates a parallel hint. What kind of setup would allow gather_stats to use Auto_dop?

--

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 31 2020 - 10:12:12 CEST

This message: [ Message body ]
Next message: Jonathan Lewis: "Re: Obj$ table"
Previous message: Lothar Flatz: "Re: Obj$ table"
Next in thread: Mladen Gogala: "Re: Gather Stats and auto_dop"
Reply: Mladen Gogala: "Re: Gather Stats and auto_dop"

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

Original text of this message