Performance impact of MONITORING and GATHER

From: Leng Kaing <Leng.Kaing_at_hsntech.com>
Date: Tue, 15 Mar 2005 16:50:45 +1100
Message-ID: <18D551B1B928FF47A65B2D91F705906A0123E40F@HSNDON-EX01.hsntech.int>

Hi guys,

Apologies if I'm revisiting a beaten path but I've tried to search the archive, metalink and google and couldn't find my answer (or it may have been hiding). So I'll ask the question (again)...

What is the performance impact of turning on MONITORING at the table level? Ie. ALTER TABLE x MONITORING. Will it have a negative impact on our production system?

We'd like to make use the GATHER_STALE option rather than just blindly re-analyzing the entire schema. Is GATHER_STALE any more efficient than the normal estimate using dbms_stats.gather_table_stats command?

Are you using MONITORING and GATHER_STALE in your production systems in the first place?

TIA, Leng.

Leng Kaing

Hansen Technologies

Phone: +61-3-9840-3832

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 15 2005 - 00:55:55 CST

Performance impact of MONITORING and GATHER_STALE