This content has been marked as final. Show 7 replies
909855 wrote:The answer would be "it depends" . If that "other data" is just going to sit on the storage along with more active files like control files and redo logs, it probably won't do anything else except to grab the space but if it's going to get updated as well very quickly, it may impact the performance as it's going to make the disk even busier.
my question is not about storage of oracle data file, archive logs etc.
actually i asking about other data (which i will transfer from other server to this server for backup purpose).
if i will place this data on disk where oracle installed, Does it has any effect on oracle performance.
909855 wrote:From a performance standpoint, creating separate partitions on the same spindles won't make a difference. I suggest you rethink your storage layout if this is a production Oracle database server, and if you're planning on using just one disk. Running everything from a single disk is bad not only for performance, but also for recovery. The following gives you an outline of the planning process for an Oracle Database:
May be some one other had already asked this question but i didn't find it.
We have window server2k8 with 1.5TB hard, we have three partition , two primary & one is logical.
Oracle data size is 10 GB size, In production our system is transactional.
Is it better to make two partition of hard disk primary & logical partitions. Then Use primary partition for oracle installation and logical partition for data(any) storage.
Does it has any effect on oracle performance.
Edited by: 909855 on Mar 31, 2013 11:13 PM
Regarding I/O configuration and performance, the following will be helpful.