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: Tablespace best practices

Re: Tablespace best practices

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 27 Dec 2004 05:36:25 -0500
Message-ID: <pan.2004.12.27.10.36.25.34610@sbcglobal.net> 





On Mon, 27 Dec 2004 17:26:07 +1100, Howard J. Rogers wrote:



> However, it has potentially ENORMOUS costs: full tablescans potentially 

> about 15% longer to complete. Buffer cache, potentially up to 30% full 

> of Oracle administrative overhead.




Howard, can you explain this in little more detail?


-- 
Artificial Intelligence is no match for natural stupidity.


Received on Mon Dec 27 2004 - 04:36:25 CST












Original text of this message













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