Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> re: dbms_stats messing up sys schema

re: dbms_stats messing up sys schema

From: cosmin ioan <cosmini_at_yahoo.com>
Date: Sun, 5 Nov 2006 21:25:53 -0800 (PST)
Message-ID: <20061106052553.92406.qmail@web60414.mail.yahoo.com>


hi all,
  I'm doing a bunch of serial jobs of the form:    

  exec dbms_stats.gather_table_stats( ownname=> 'xxx', tabname=>'xxxx',estimate_percent=> 30,method_opt=>'FOR ALL COLUMNS SIZE 1 FOR ALL INDEXED COLUMNS', cascade=> true);    

  for many tables in a schema.    

  I have noticed that, for some tables only, even small ones, Oracle decides it's easier to create a global temporary table in the SYS.ora_temp_xyz rather than simply doing the "select..."    

  this to me, is messing up too much the SYS data dictionary-- creating tons of objects of this nature...    

  Why does this happen and how can I prevent it?   thx,
  Cosmin        

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Nov 05 2006 - 23:25:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US