Unanswered: Is there a performance impact when the data file is used about 80 percent
Having some serious performance problems while doing DML operations on our database which was working fine earlier ( when we had less data) . If we look at the data file, it is almost used by 80 percent. would like to know whether this has an impact on database performance?
Originally posted by Rushi
If the datafile is 80% full, you MUST add another data file to this tablespace.
Add a data file and then check the performance.
yes adding a datafile may not necesserily solve your performance problems, If your adding datafiles that obviously means your table/s are becoming bigger....therefore you may need to analyze your tables and or rebuild your indexes.