We have an Oracle SDE at my workplace. I would like to see the size of the datasets and feature classes. I have enable the size in the catalog options. But catalog reports nothing back?? I am using 10.1 sp 1. How do I get the size of the data on the disk?
Thanks Forest
Solved! Go to Solution.
This works for data in a File gdb and not for data in an sde geodatabase (in that case you could use some DBMS-specific queries to determine it though).
This works for data in a File gdb and not for data in an sde geodatabase (in that case you could use some DBMS-specific queries to determine it though).
There are a number of issues that play into determining storage requirements for tables in Oracle, including block size, extent allocation policies, high water mark allocation, and more. While it may be possible to determine the space allocated to business and geometry tables and indexes, the exact storage requirements could be much larger than the storage allocated to the tables.
- V
Ok sounds like this is kinda a big topic. I am new in my job, never worked with an SDE before, can you tell? lol
I think I will talk to my supervises before I do anything else. Thanks for the feed back.