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!

Pinning Tables or Indexes within memory

user8375298Mar 6 2013 — edited Mar 7 2013

Hello,

I am wondering if it's possible to pin a specific table and/or indexes in memory (10g) to make sure that the I/O will be less to access data within this object.

Anyone who can explain if this is possible and how this works?

Thanks in advance,
Regards,
René

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2013

Added on Mar 6 2013

#general-database-discussions, #performance, #tuning

15 comments

4,099 views