Re: Changing initrans

> Also, inserting any rows into the table after the change shows all of
> the Itl slots even without a commit - interesting...

Simply means that DBW is healthy and writing dirty buffers quickly.. Dumping redo log file should show a Block written redo record for that block immediately after block change.

Cheers
Riyaj

richa03_at_gmail.com wrote:
> [Should have replied all...]
>
> The checkpoint produces the correct result.
> Also, inserting any rows into the table after the change shows all of
> the Itl slots even without a commit - interesting...
>
>

--
http://www.freelists.org/webpage/oracle-l