Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Determine number of dirty blocks...
There is some ambiguity in your question.
When I make a change to a block, it is a "dirty block" in that the image in memory does not match the image on disc.
If the block is written from the buffer to disc before I commit the change, then the block is a "dirty block" that will be subject to future 'delayed block cleanout' and does not immediately reflect the true state of the date.
If the block is in memory when I commit, the block may be partly modified to reflect the commit, but will still be a "dirty block" in that the lock bytes will still be marking the rows I have changed as locked, and a subsequent modification of the block will do a 'delayed logging' clean out.
Of the three variations, the second is perhaps the only one that might be significant, as any attempt to read the block will result in it being modified in memory (and therefore becoming "dirty" in the first sense) resulting in the generation of redo log and a future write.
Any attempt to count such blocks will only clean them.
-- Jonathan Lewis http://www.jlcomp.demon.co.uk Now running 3-day intensive seminars http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Clayton Hinkle wrote in message ...Received on Sat Jan 26 2002 - 11:49:27 CST
>Anyone know of a way to determine how many dirty blocks you have in
>the database at any given time?
>
>Thanks!
>
>--Clayton
========= WAS CANCELLED BY =======: From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> Control: cancel <1012067860.23600.0.nnrp-12.9e984b29_at_news.demon.co.uk> Subject: cmsg cancel <1012067860.23600.0.nnrp-12.9e984b29_at_news.demon.co.uk> Date: Mon, 28 Jan 2002 02:33:26 GMT X-NNTP-Posting-Host: vimiesoa.demon.co.uk:149.162.224.101 X-Trace: news.demon.co.uk 155572217nnrp-13:4705 NO-IDENT vimiesoa.demon.co.uk:149.162.224.101 X-Complaints-To: abuse_at_demon.net Message-ID: <cancel.1012067860.23600.0.nnrp-12.9e984b29_at_news.demon.co.uk> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!news.csl-gmbh.net!newsfeed.r-kom.de!newsfeed.stueberl.de!newsfeed.online.be!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!elk.ncren.net!logbridge.uoregon.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40720824 This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.