Re:RE: DBA_TAB_MODIFICATIONS - Performance impact?

From: <dgoulet_at_vicr.com>
Date: Fri, 28 Dec 2001 13:55:08 -0800
Message-ID: <F001.003E3F28.20011228131519@fatcity.com>

Of course Ross. How else do we know how long sadists like you are at work?? :-)

Dick Goulet

____________________Reply Separator____________________
Author: "Mohan; Ross" <MohanR_at_STARS-SMI.com>
Date:       12/28/2001 12:55 PM

LoL timed sadistics????

-----Original Message-----
Sent: Friday, December 28, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L

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?

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT
<http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_data
base_id=NOT&p_id=102334.1> &p_id=102334.1

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>DDL alter in execute immediate pl/sql procedure - dynamic sql</TITLE>

<META content="MSHTML 5.50.4616.200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=229555420-28122001><FONT face=Arial color=#0000ff
size=2>LoL  timed sadistics????</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Brian MacLean [mailto:bmaclean_at_vcommerce.com]<BR><B>Sent:</B> Friday, December 28, 2001 3:36

PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> DBA_TAB_MODIFICATIONS - Performance impact?<BR><BR></FONT></DIV> <DIV><SPAN class=050582420-28122001><FONT face="Courier New" size=2>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?</FONT></SPAN></DIV> <DIV><FONT face=Tahoma size=2></FONT> </DIV> <DIV><FONT face=Tahoma size=2><A
href="http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_d atabase_id=NOT&p_id=102334.1">http://metalink.oracle.com/metalink/plsql/ml2_

documents.showDocument?p_database_id=NOT&amp;p_id=102334.1</A></FONT></DIV>
  <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Tahoma size=2></FONT>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Dec 28 2001 - 15:55:08 CST