The sde space has 400 MB allocated to it and is currently indicating that 99.4 percent of the storage capacity is used. The dbtune file has been setup so that no spatial data can be stored in the sde tablespace; the sde table space only contains the ArcSDE system tables that make sde run. The sde user schema contains the following system privileges:
The oracle database version is 12.1.2.0 and the ArcSDE version is 10.5.1
Solved! Go to Solution.
Responses to your questions:
1. Yes, that is just a starting point
2. Yes, you can increase the SDE tablespace as needed. I would recommend auto growth with an unlimited size. Something like this:
ALTER DATABASE DATAFILE 'DATAFILE_LOCATION\SDE' AUTOEXTEND ON MAXSIZE UNLIMITED
There should be no impact to the function of the GDB based on the size of the SDE tablespace. I would think that you would have more issues if you ran out of tablespace room than have too much.
There are a lot of items in the SDE schema (stored procedures, views, etc.) that also get created. I can see that table space getting larger if you have a versioned environment or lots of tables in the geodatabase.
The default size if 400MB when creating the Oracle Enterprise Geodatabase; Create a geodatabase in Oracle—Geodatabases in Oracle | ArcGIS Desktop
What is the main worry with it filling up the 400MB, no more space available on the Oracle machine or that it is using 400MB of space?
Thanks for the reply George.
There is no issue with the Oracle machine; It's using 400MB space. The database does have a versioning environment and there are lots of tables in the database.
Questions:
Responses to your questions:
1. Yes, that is just a starting point
2. Yes, you can increase the SDE tablespace as needed. I would recommend auto growth with an unlimited size. Something like this:
ALTER DATABASE DATAFILE 'DATAFILE_LOCATION\SDE' AUTOEXTEND ON MAXSIZE UNLIMITED
There should be no impact to the function of the GDB based on the size of the SDE tablespace. I would think that you would have more issues if you ran out of tablespace room than have too much.
Thanks for the info George. You confirmed what I was thinking.