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 -> Formula to calculate size of temp segment when analyzing tables/schemas

Formula to calculate size of temp segment when analyzing tables/schemas

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sun, 19 Dec 1999 16:58:06 +0100
Message-ID: <945619145.24341.0.pluto.d4ee154e@news.demon.nl> 





Hi,



Is there any formula to calculate how much temp segment you need to analyze
a table / schema? Currently I'm working at a site to get a 'standard' suite
of maintenance tools (No, they don't want to use OEM as they already have
Patrol) and they don't like the idea the size needs to be determined by rule
of thumb and/or trial and error.



Regards,



--


Sybrand Bakker, Oracle DBA


Received on Sun Dec 19 1999 - 09:58:06 CST












Original text of this message













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