Hi
I have problem with Oracle 18 XE (non-container database) with autoextending a tablespace. Yesterday at night it widened 7 time from 6.5GB to 7,2GB, but after expansion tablespace has a 1GB free space but i dont need 1 GB free space because it makes me out of memory (12GB). I did resize but after 4-5 days i had the same situation.
Autoextend parameter is set to 50M
<code>Thread 1 advanced to log sequence 18 (LGWR switch)
Current log# 3 seq# 18 mem# 0: C:\APP\ADMINISTRATOR\PRODUCT\18.0.0\ORADATA\XE\REDO03.LOG
2021-03-19T01:34:00.206572+01:00
2021-03-19T01:34:05.099119+01:00
Resize operation completed for file# 5, old size 6553600K, new size 6604800K
2021-03-19T01:34:05.224089+01:00
Resize operation completed for file# 5, old size 6604800K, new size 6707200K
Resize operation completed for file# 5, old size 6707200K, new size 6809600K
Resize operation completed for file# 5, old size 6809600K, new size 6912000K
2021-03-19T01:34:11.425789+01:00
Resize operation completed for file# 5, old size 6912000K, new size 6963200K
2021-03-19T01:34:11.550736+01:00
Resize operation completed for file# 5, old size 6963200K, new size 7065600K
Resize operation completed for file# 5, old size 7065600K, new size 7168000K
Resize operation completed for file# 5, old size 7168000K, new size 7270400K</code>
Do you know reason of it?