Home » RDBMS Server » Server Administration » block cleanout
block cleanout [message #416362] Sat, 01 August 2009 02:14 Go to next message
Messages: 37
Registered: September 2008

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?

Re: block cleanout [message #416369 is a reply to message #416362] Sat, 01 August 2009 03:31 Go to previous messageGo to next message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) No.
2) Yes.
3) Clear SGA does not mean clean blocks, only a real access to the block clean it.

Re: block cleanout [message #419414 is a reply to message #416362] Fri, 21 August 2009 23:33 Go to previous message
Messages: 7
Registered: August 2009
Junior Member
Previous Topic: Tablespace usages
Next Topic: Miscellaneous Part in Shared Pool
Goto Forum:

Current Time: Sat Aug 19 10:09:59 CDT 2017

Total time taken to generate the page: 0.04669 seconds