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

From: Alberto Garzas <NOSPAMalberto.garzas_at_wanadoo.es>
Date: Wed, 14 Aug 2002 01:54:01 +0200
Message-ID: <ajc6dp$pcr$1@news.wanadoo.es>

I think that it is a "impossible mission" understand the dump file.

Do you know a URL where dump file is explained?

Why do you say "This is also great for
educational purposes" ?
I have to make a tool ! I am absolutelly lost! What tool would you make for a educational project?

Thank you !

"srivenu" <srivenu_at_hotmail.com> escribió en el mensaje news:1a68177.0208122119.1a48c5c8_at_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 - 18:54:01 CDT