Re: 8.1, 8.0 and prior and snapshot too old

I hadn't noticed it - however I believe a recent change in Oracle has allowed rollback blocks to be packed more efficiently.

Once upon a time after a transaction had used a block and committed, that block could not be used by any other transaction. In Oracle 8.1 (at least) the next active transaction can re-acquire the block to make use of any space that has been left.

I don't know when the change happened, but perhaps it would be sufficient in an OLTP system with a large block size to result in a visible reduction in 1555 errors.

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

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Nuno Souto wrote in message <3ae035da.18069535_at_news-server>...


>Has anyone else found out a reduction in 1555 errors when moving to

>8.1.6?

>

>If so, any ideas why?

>

>TIA

>

>Cheers

>Nuno Souto

>nsouto_at_bigpond.net.au.nospam

>http://www.users.bigpond.net.au/the_Den/index.html