Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to get a good estimate on how much space a feature class will take once loaded into ArcSDE from how big they are in a FGDB? I have some feature classes in a FGDB, where some are a few GB's.

I'm using Oracle/ ArcSDE 9.2

share|improve this question

you can get the same information here - How to get the size of a file geodatabase feature class on disk?

enable the Size column in the Customize menu -> ArcCatalog Options -> Contents tab

i hope it helps you...

share|improve this answer
On disk is fine, as that is what I'm doing at the moment, I want to find out whether from the file sizes in the FGDB I can estimate the size before I load it into ArcSDE. – MapMan Jun 7 '12 at 8:25
Estimate, sure. It will generally be larger on SDE because there are more metadata tables and different storage types may be less efficient space wise. Why not do a test? Put up a small feature class and ask your DBAs to figure out its size (hopefully they will know how, it's not a simple matter). Compare the two and extrapolate from the difference for your real feature classes. – blah238 Jun 9 '12 at 3:10

for ArcSDE run the script below in MSSQL Manager Studio. Then save it as csv, open in excel and sort / sum ...

    t.NAME AS TableName,
    p.rows AS RowCounts,
    SUM(a.total_pages) * 8 AS TotalSpaceKB, 
    SUM(a.used_pages) * 8 AS UsedSpaceKB, 
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
    sys.tables t
    sys.indexes i ON t.OBJECT_ID = i.object_id
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
    sys.allocation_units a ON p.partition_id = a.container_id
    t.NAME NOT LIKE 'dt%' 
    AND t.is_ms_shipped = 0
    AND i.OBJECT_ID > 255 
    t.Name, p.Rows
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.