| block cleanout [message #416362] |
Sat, 01 August 2009 02:14  |
tjay
Messages: 37
Registered: September 2008
|
Member |
|
|
1-)Suppose, we modify blocks which exceeds 10 percent of the buffer cache and we never select
that table or gather statistics.
Does these blocks get cleaned automatically after these dirty blocks flushed to disk?
(In this case, our next query will not suffer from delayed block clean out)
2-)If we modify blocks which exceeds 10 percent of the buffer cache,
and rather than full scan,if we query "select * from t where ..."
Only the selected blocks will become cleaned right?
3-) After database reboot all of the sga components have to be cleared,
I notice that, next transaction still suffer from delayed block cleanout, how come this happen?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
