Oracle Database Discussions

Dear All,

I have 2 schemas with sizes 1.5GB and 5GB Respectively. They both are used together in an application. The System is very slow and we had done most of the performance tuning related activities like query tuning and creating necessary indexes. Now we are thinking to segregate tablespaces based on User, Table and Index.

Details:
OS: Unix
Version: Oracle 10g R2
SGA: 2.5 GB

Is there any guideline to be followed to segregate tablespace into separate disks? We are planning to introduce 4-5 separate disks and place each datafile separate disk. Will it improve performance; I had read that now a days we do not have to create separate tablespaces as it makes no difference.

If it does makes a difference, then are there any guidelines which we should follow to segregate them?

For example based on:
- Users
- Table Size
- Type of data eg. CLOB
- Index
- Frequently Used table


Regards.