You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTM - Storage Limit Documentation + Performance/Potential Risks

edited Jan 7, 2025 2:34PM in Transportation Management 5 comments

Summary:

When uploading documents to OTM:

1 - Where are they stored?

2 - What is the memory limit that can be reached?

3 - Is there an automatic purge every X amount of time? If not, could it be scheduled in some way?

4 - Regarding the upload of documents, is there any type of risk to the system's performance?


Content (please ensure you mask any confidential information):

We implemented uploading documentation in our production environment more than 1 year ago, but we are unaware of some questions.

We know the existence of documents and their size through the following query:

select document_content_gid, DBMS_LOB.GetLength(blob_content)/1024 AS Filesize_KB from document_content

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!