Many professional have questions about Oracle data file and tablespace management, and Ive tried to start this FAQ with common Oracle data file questions. >> Does the amount of free space inside the tablespace containing all the tables inside an OLTP Production database affect its performance?
Not if your SQL uses indexes. However, if have free space within a table’s or indexes extents and you see your SQL doing full-scans, then yes, it might affect performance. I wrote “Oracle Tuning: The Definitive Reference” with details on all of this and scripts that you can run to see if you have a space-related performance problem.
Related Questions
- Many professional have questions about Oracle data file and tablespace management, and Ive tried to start this FAQ with common Oracle data file questions. >> Does the amount of free space inside the tablespace containing all the tables inside an OLTP Production database affect its performance?
- Can I use Visual Importer ETL Professional to transfer data from one Oracle Ver. to Another Oracle Version?
- Do you have a file that will transfer the Yellis data into my school management information system?