Thread: block cleanout issue
08-01-09, 03:15 #1Registered User
- Join Date
- Feb 2008
Unanswered: block cleanout issue
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?
08-01-09, 10:55 #2Registered User
Provided Answers: 1You can lead some folks to knowledge, but you can not make them think.
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.