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

Home -> Community -> Usenet -> c.d.o.server -> Re: doubt on table scan

Re: doubt on table scan

From: <yong321_at_yahoo.com>
Date: 19 Oct 2005 08:33:46 -0700
Message-ID: <1129736026.617967.93940@o13g2000cwo.googlegroups.com> 





Hi, Michel,



The query result looks like coming from a parallel query coordinator.
Was the table altered parallel <a number probably larger than 5> by any
chance? Can you provide the full SQLs including the SQL that creates
the tablespace? But I think the most important is how the table is
created (or altered). What's the block size of the database or
tablespace, and database version? Thanks.



Yong Huang
Received on Wed Oct 19 2005 - 10:33:46 CDT












Original text of this message













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