Advice Needed -Free space in tablespace for performance
Could anybody provide some thoughts about the free space inside an Oracle database. Does the
amount of free space inside the tablespace containing all the tables inside an OLTP Production
database affect its performance.
Should there be a threshold for free space on the disk where the datafiles are located. As the SYSTEM
and UNDO tablespaces are on AUTOEXTEND mode, is it possible to find how much space they would swell
on at the worst peak.
And lastly, is it better to increase the datafile size or add another datafile to increase tablespace size.
The database in question is an OLTP Production database on Oracle 9205 & Solaris 5.8
Please do let me know if there is any other info that I missed to provide here.
Thanks in advance...