Re: initrans, maxtrans, actual number of transaction entries

You could do a database block dump:

    alter database dump data file NNNN block MMMM;

You will be able to identify the transaction list very easily from the resulting dump which will be in the trace file for the session. Depending on platform each entry takes about 23/24 bytes - the exact value can be found in the v$type_size view.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Frank Hubeny wrote in message <3837778E.F45BDA3B_at_ntsource.com>...
>In the Administrator's Guide 8.1.5 page 12-9, it claims that
>
>"Once the space reserved by INITRANS is depleted, space for additional
>transaction entries is allocated out of the free space in a block, if
>available. Once allocated, this space effectively becomes a permanent
>part of the block header. The MAXTRANS parameter limits the number of
>transaction entries that can concurrently use data in a data block."
>
>Is there a way to determine how much space has been allocated for the
>transaction entries?
>
>Frank Hubeny
>
Received on Sun Nov 21 1999 - 02:58:03 CST