Home » RDBMS Server » Server Administration » block cleanout
block cleanout [message #416362] Sat, 01 August 2009 02:14 Go to next message
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?





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: 64139
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.

Regards
Michel
Re: block cleanout [message #419414 is a reply to message #416362] Fri, 21 August 2009 23:33 Go to previous message
purple73
Messages: 7
Registered: August 2009
Junior Member
http://hemantoracledba.blogspot.com/2008/10/delayed-block-cleanout-through-db.html
Previous Topic: ORA-15180 (merged)
Next Topic: DBMS_STATS.GATHER_STATS fails
Goto Forum:
  


Current Time: Thu Dec 08 08:42:41 CST 2016

Total time taken to generate the page: 0.13591 seconds