concurrent statistics gathering

From: Wilhelm Klotz <willyk_at_kbi-gmbh.de>
Date: Tue, 19 Mar 2024 08:42:21 +0100
Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAAJxRhRLvfEhBnlOLJd92a2XCgAAAEAAAAKnKWD47XF5LgJVjiq53Rq4BAAAAAA==_at_kbi-gmbh.de>



Hi,  

anyone using concurrent statistics gathering, as described in https://blogs.oracle.com/optimizer/post/concurrent-statistics-gathering ? Any tricks / hints and tips?  

We are on Oracle 19.20, with large OLTP databases (many db objects, partitioned tables) on Solaris and Linux. Statistics gathering is not really "concurrent", as after some time there is no really concurrent processing anymore. Support is not really helpful until now.  

Thanks and Regards

willyk

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 19 2024 - 08:42:21 CET

Original text of this message