| Oracle On Linux [message #192114] |
Mon, 11 September 2006 00:41  |
sarfraz_attari
Messages: 123
Registered: July 2005
|
Senior Member |
|
|
We are using Oracle 10g on Linux Enterprise Edition
We are using seperate partitions for different different datafiles , is it correct
for ex we have there data files part1.dbf in \disk10 ,service1.dbf in \disk11 and sales1.dbf in \disk12 partition.
what if we keep these datafile in single partition ,is it affect the performance of our applications
thanks
sarfraz
|
|
|
|
| Re: Oracle On Linux [message #192218 is a reply to message #192114] |
Mon, 11 September 2006 07:56  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> We are using seperate partitions for different different datafiles , is it correct
Question is, are they seperate disks?
In real 'server' anyhow everything is raided/mirrored.
>>what if we keep these datafile in single partition ,is it affect the performance of our applications
depends.
It is generally a good practise to distribute the i/o.
Use LMT with right uniform extent size.
distribute those datafiles across available disk.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
