Hi guys, I am concerned about my full system tablespace. Can you advice me which solution would be better one?
I will start from some information:
System tablespace contains only the required system objects. There is no other user's objects than OUTLN or DR. It has 1,6 GB total space and only 3 MB free. Autoextend is on with next 10M setting. But still I think it is reasonable to avoid keeping such a full system tablespace.
I wonder if it is better to just resize it's datafile (for example to 2 GB) with ALTER tablespace datafile ... RESIZE 2G option, or maybe if it is autoextended than changing 'NEXT' value from 10M (let's say to 300M) would be better?
Also, could you confirm if altering anything on tablespace system will not affect working of database? Is it possible to have some breaks on connecting while resizing it?
I would really appreciate some helpful advices, thanks a lot!