Home » RDBMS Server » Server Administration » Impact on file system
Impact on file system [message #210398] Wed, 20 December 2006 10:46 Go to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

I have seven files systems on unix server used for storing data files of our three databases and other purpose. One of the file system /u02 occupy 100% with data and /u03 occupy 94% data on the /u03 file system. We have added one more disk to grow the database files.

But, there are so many existing old data files resided at mentioned file systems /u02 and /u03.

Does it require to make room in the mentioned file system? i.e /u02 and /u03

If not, what would be the impact in terms of storage, performance etc.

Your suggestion would be appreciated.
Re: Impact on file system [message #210408 is a reply to message #210398] Wed, 20 December 2006 12:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This is nothing to do with performance.
I would not be comfortable to have 100% utilized disk (and have to reset all the monitoring scripts/pagers).
If you are sure that the said datafiles will never grow, you can leave it as is.
Re: Impact on file system [message #210549 is a reply to message #210398] Thu, 21 December 2006 05:09 Go to previous messageGo to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

But, If it requires to grow the datafile in the concern tablespace and file system then performance would be the issue.

Can you please make your comment in trems of performance and occupied 100% space?
Re: Impact on file system [message #210552 is a reply to message #210549] Thu, 21 December 2006 05:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> If it requires to grow the datafile in the concern tablespace and file system then performance would be the issue
If grows and reaches 100% (and cannot expand) the concerned datafile cannot take any more data. Your insert/update operations MAY fail.
Other than that it has no effect on performance (whehter the filesystem/datafiles in 10% full or 99% full).
Your RAID system/queries/available data,distribution of data and statistics on data is what matters for performance.
If you are still concerned just move the said datafiles to other other disk. Spreading out the I/O to different physical disk may help. But still, datafile utilization has nothing to do with it.
Re: Impact on file system [message #210584 is a reply to message #210549] Thu, 21 December 2006 07:23 Go to previous message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

Thanks a lot for your comment.
Previous Topic: OPTIMAL_LOGFILE_SIZE
Next Topic: ORA-14520 Tablespace ### block size [8192] does not match existing object block size [16384]
Goto Forum:
  


Current Time: Sun Dec 04 00:38:54 CST 2016

Total time taken to generate the page: 0.11215 seconds