OTM - Storage Limit Documentation + Performance/Potential Risks
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
0