Contention=db buffer cache
Hi, 9th May 2001 21:10 hrs chennai
sonali Data,Index,Rollback are all part of db buffer cache.
They are not part of shared pool.In the sared pool library cache hold the parsed SQL/PLSQL information.
shared pool Data Dictionary hold objects prvs information etc.
Imagine if you fetch a table data to db buffer cache it will also load its corresponding Index blocks also to memory.
So reading them from different disk or TS will greatly help read write operation easier.
Cheers
padmam