Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

Thanks

share|improve this question
add comment

2 Answers

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. –  Halil Siddique Jun 7 '12 at 8:25
2  
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
add comment

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

SELECT 
    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
FROM 
    sys.tables t
INNER JOIN      
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
    sys.allocation_units a ON p.partition_id = a.container_id
WHERE 
    t.NAME NOT LIKE 'dt%' 
    AND t.is_ms_shipped = 0
    AND i.OBJECT_ID > 255 
GROUP BY 
    t.Name, p.Rows
ORDER BY 
    t.Name
share|improve this answer
add comment

Your Answer

 
discard

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.