Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hisk Disk I/0 on Big table!!

430126Jun 12 2006 — edited Jun 15 2006

Hi,

We have one big table in our production database 1 GB+ and most of online search done through application & reports use this table. Hence, large amount of I/O occurs & and response time is slow.

To reduce the amount of disk reads i've moved the table into a different tablespace of 16k block size, earlier it was on 8 kb block size. I've defined a custom cache size of 150m to inorder to define the tablespace of custom block size(16k).

Now, even after moving the table into new tablespace I don't see any difference in the reponse time or I/O?? It is same as before.

We are working on oracle 9.2.0.7 & Linux As 4 on 32 bit . I'm not sure how to figure out whether the above scenario would work or not??

Kindly, provide some light on it.

Thanks

Ratheesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2006

Added on Jun 12 2006

#general-database-discussions

11 comments

401 views