Re: initrans, maxtrans, actual number of transaction entries

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: Tue, 23 Nov 1999 11:22:25 -0600
Message-ID: <383ACD51.615D569E@ntsource.com>

The alter database dump command sounds interesting but I have not been able to get it to work.

I have also searched the SQL Reference 8.1.5 without finding anything relevant that has the word "dump" in it.

I get the following errors in trying to use the command:

SQL> alter database dump datafile 'c:\oracle\oradata\mydb\users01.dbf' block 100;
alter database dump datafile 'c:\oracle\oradata\mydb\users01.dbf' block 100

                                                                  *

ERROR at line 1:
ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

Now trying it with "data file":

SQL> alter database dump data file 'c:\oracle\oradata\mydb\users01.dbf' block 100;
alter database dump data file 'c:\oracle\oradata\mydb\users01.dbf' block 100

                    *

ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE

Now trying it with the file_id:

SQL> alter database dump datafile 3 block 100; alter database dump datafile 3 block 100

                               *

ERROR at line 1:
ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

Frank Hubeny

Jonathan Lewis wrote:

> 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 Tue Nov 23 1999 - 11:22:25 CST