nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What would cause the oracle sde table space used size to reach 99%

CJ_Broome

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:

CREATE PROCEDURE
CREATE SEQUENCE
CREATE SESSION
CREATE TABLE
CREATE TRIGGER
ALTER ANY INDEX
ALTER SYSTEM
ANALYZE
SELECT ANY DICTIONARY
UNLIMITED TABLESPACE

The oracle database version is 12.1.2.0 and the ArcSDE version is 10.5.1

Vind meer berichten getagd met

Accepted answers

George_Thompson

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.

All comments

George_Thompson

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?

CJ_Broome

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:

Is the default sde tablespace size of 400MB just a starting point?
Can you increase the sde tablespace size from the default 400MB to something larger? Will increasing the tablespace size cause any unseen issues to the function of the gdb

George_Thompson

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.

CJ_Broome

Thanks for the info George. You confirmed what I was thinking.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Alle Gemeenschappen
Recente Berichten
Gevolgde Inhoud
Community Hulp

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.