Re: re-indexing per statement or per row?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 8 Apr 2002 12:25:53 +0100
Message-ID: <1018265083.3365.0.nnrp-12.9e984b29@news.demon.co.uk>

Hint for anyone who's following this.

Take a look at v$transaction.used_urec.

Some of the numbers that appear in specific cases are very interesting.

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

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

Author of:
Practical Oracle 8i: Building Efficient Databases


Jim Kennedy wrote in message ...


>Good thought for the day.

>Hmmm...

>On the direct path loads part I was going from memory on the documentation,

>but that aint't proof.

>

Received on Mon Apr 08 2002 - 06:25:53 CDT