Hello All,
We have noticed that our Oracle 19c Database is having LOBSEGMENTS & Its consuming 80% of complete Table Space Allocated.
Tables starts from SYS & not SPT.
We wanted to know, if the Sailpoint IIQ is using these tables to index or to store data.
Current DB Tables space is 4.5 TB. Our Agenda to bring down the Tablespace.
Disclaimer: I am not an Oracle DBA.
IdentityIQ stores some data in CLOBs which I believe Oracle will index in the LOBSEGMENTS. SailPoint do not use the LOBSEGMENTS directly, but care should be taken to reclaim space and I would recommend you work with your DBA in freeing this up.
Hello Christian,
Thanks for your response.
However, Our DBA Team, is unaware of Freeing up the LobSegments, without impacting the sailpoint Process. Hence can you point us at any Blog / Technical Paper / SOP to Free Up Space on out DataBase.
Thanks in Advance.