Re: initrans for table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 9 Oct 2002 22:49:58 +0100
Message-ID: <ao28fv$2g$1$8302bc10@news.demon.co.uk>

It would be helpful if you included the relevant section of your dump file to prove your point.

It seems MOST unlikely that you have a port of Oracle with such a dramatically obvious error that no-one has discovered for a couple of years.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Harry Sheng wrote in message ...


>Oracle8i on Solaris8

>

>I create a table with initrans set to 4.

>But if I dump some table blocks and check the ITL entries,

>there is only one entry unless I have active transactions.

>

>I expected 4 ITL entries pre-allocated in each block head.

>

>

>

Received on Wed Oct 09 2002 - 16:49:58 CDT