Hellod fellows DBA's
I need to add another datafile to one of my index tablespaces.
Please let me know if I'll be better off adding it to the same OS disk or putting it on another disk.
I am concern about performance problems.
Thank you.
Printable View
Hellod fellows DBA's
I need to add another datafile to one of my index tablespaces.
Please let me know if I'll be better off adding it to the same OS disk or putting it on another disk.
I am concern about performance problems.
Thank you.
as long as the current Index datafile is on a different disk, you should be okay to put another datafile on thgat disk.
- Magnus
As magnus suggested, you would be better off by putting the datafile for the index tablespace, in a different place from that of the archive log/ data (i.e table data) tablespace/logfile table space.
Hope this would help you.
Sam