Re: table size in bytes
Date: Tue, 28 Mar 1995 13:43:15 GMT
Message-ID: <D65Ks4.9DL_at_cs.dal.ca>
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 employerReceived on Tue Mar 28 1995 - 15:43:15 CEST