Sample Header Ad - 728x90

Oracle 10g Database - SYSTEM tablespace space

0 votes
1 answer
277 views
I am concerned about the SYSTEM tablespace. It's space is 99% full. The whole tablespace has 1510 MB and there is 1507 MB already used. Max size of datafile is 32 GB and the autoincrement is on with increment 10 MB. However, I had outside company's audit and they pointed us it is unacceptable to keep so less free space in the system tablespace (3MB). As far as I see it is autoextensible, I am not sure if I should take any actions to resize the datafile (for example to 2 GB). I am not sure what kind of extents (DBA_EXTENTS) shall be storaged in this space, so at this moment I am not able to check if anything shall be moved from this space to SYSAUX or others. My question is, if it is really required to resize the system tablespace to avoid some problems with database due to its fullness? What would you do with this case? Maybe it would be enough to change incrementation size from 10 MB to more?
Asked by Julia Kwasniuk (1 rep)
Mar 17, 2022, 02:07 PM
Last activity: May 25, 2025, 01:03 AM