Any Relational Database Management System, temp database (in MS SQL) or tablespace (in Oracle) extensively used during data sorting, index creation, join operation on multiple tables. These activities heavily engaged writing operations on disk storage.
So, the files belong to temporary database/tablespace where it placed in the disk is really cautious decision making at the time of database implementation.
Better place in disk storage for temp files is RAID-1, because of high load of writing data in disk. Try to avoid place in RAID-5, which could cause I/O congestion, eventually cause performance issue in database server.
0 comments:
Post a Comment