Re: What space of a Oracle block is being used?

From: srivenu <srivenu_at_hotmail.com>
Date: 12 Aug 2002 22:19:02 -0700
Message-ID: <1a68177.0208122119.1a48c5c8@posting.google.com>

If you want exact figures and are interested in one particular block , You can get it by dumping the block contents. This is also great for educational purposes.

Use this for dumping an Oracle7 block:
alter session set events 'immediate trace name blockdump level 000100000130';
You can get the block number (WHich is the number that you see after level) by
using make_data_block_address(file number, block number) return number;

Use this for dumping an Oracle 8:
alter system dump datafile 1 block 17020; or:
alter system dump datafile '/u01/oracle/oradata/system01.dbf' block 17020; Received on Tue Aug 13 2002 - 00:19:02 CDT