Table storage

[gxangel]

Hi,

Currently, i have 3 tables - A, B, C under a single tablespace. These 3 tables are most heavily accessed by the users.

Will having a separate tablespace for each of the tables help to improve IO access?

Thanks!

[davey23uk]

no, spreading all your IO across devices out will

[gxangel]

Thanks!

In this case, the new tablespaces created need to stripped on different disks to improve IO access. Is this correct?

Are there other ways to improve the situation? Will appreciate if you van provide me with a link or two. Thanks!

[malay_biswal]

Yes, you can place these tables in different tablespaces and these tablespaces should have separate mount points.
You may consider the partitioning option.
You need to gather stats at regular interval.

You can pull out top queries from statspack/AWR report and try to analyze how you can tune.

[malay_biswal]

to move tables seperate tablespace using
alter table tablename move tablespace newtablespacename

First understand the question.
Then try to answer.

[sinu009]

to move tables seperate tablespace using
alter table tablename move tablespace newtablespacename

First understand the question.
Then try to answer.

thank u

[PAVB]

In this case, the new tablespaces created need to stripped on different disks to improve IO access. Is this correct?

Are there other ways to improve the situation? Will appreciate if you van provide me with a link or two. Thanks!

You don't even have to create new tablespaces.
Read again what Dave said.
All you have to do is have your datafiles sitting on different devices; a tablespace is an abstraction, not a real object.

[gxangel]

I got what you mean. Thanks for all the help!