Re: table size in bytes

Jonathan Lewis (Jonathan_at_jlcomp.demon.co.uk) wrote:
: In article <3l6svq$66d_at_homer.alpha.net> sahmad_at_mfa.com "Saad Ahmad" writes:
 

: : How can I obtain the table size in bytes. I don't want
: : to use count(*) * bytes-per-rec * overhead because count(*)
: : would take a long time. If I can get count(*) with some
: : other method, it could be ok.
: :
: : I want to make an estimate as to when the table would want
: : another extent ...
: :
 

: Your best bet is to forget about bytes:
: try from SQL*Plus
 

: alter session set events 'immediate trace name blockdump level NNN';
 

: where NNN is the absolute block address of the header block of the
: table you are interested in. This generates a symbolic block dump
: of the table header. With a little guess work you can figure out
: what it all means.

How do you get the block address of the header block of the table I am interested in??

--
Murray Kaiser                  | Usual gutless disclaimer..
Nova Scotia Power              | Opinions are mine and not necessarily
(Murray.Kaiser_at_NSPower.NS.CA)  | shared by my employer