From MohanR@STARS-SMI.com Fri, 28 Dec 2001 13:10:25 -0800
From: "Mohan, Ross" <MohanR@STARS-SMI.com>
Date: Fri, 28 Dec 2001 13:10:25 -0800
Subject: RE: DBA_TAB_MODIFICATIONS - Performance impact?
Message-ID: <F001.003E3EF7.20011228125520@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: DDL alter in execute immediate pl/sql procedure - dynamic sql



<FONT face=Arial color=#0000ff 
size=2>LoL  timed sadistics????

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Brian MacLean 
  [mailto:bmaclean@vcommerce.com]Sent: Friday, December 28, 2001 3:36 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  DBA_TAB_MODIFICATIONS - Performance impact?
  Anybody 
  using the "ALTER TABLE <tablename> MONITORING;" functionality?  
  Just wondering what the performance impact of implementing the features 
  outlined in MetaLink Doc 102334.1 was.  Or is this another performance 
  debate like setting "timed_sadistics = true" was/is?
   
  <A 
  href="http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=102334.1">http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=102334.1