Re: unexpected heavy buffered IO during partition bitmap index rebuild

Here's a link to a script that I published in Nov 2000 demonstrating the principle:

http://www.jlcomp.demon.co.uk/faq/rowsize.html

I have a modern variant which still has the limitation that it can only handle simple data types (no LOBs etc.), and uses sys_op_opnsize() rather than vsize(). The biggest benefit, though, is that it generates the SQL from a supplied tablename.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com/all_postings

Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543

--
http://www.freelists.org/webpage/oracle-l