Re: Locally managed tablespaces and migrated rows

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Mon, 07 May 2001 12:45:56 GMT
Message-ID: <3af696f3.11576289@news-server>

On Mon, 7 May 2001 13:20:24 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>The act of migrating a row is (pretty much) like
>inserting a row - Oracle tries to insert the row
>into the first block on the free list. There is no
>need for Oracle to know anything about the
>'type' of extent that the block comes from.

Whew! Thanks a lot. For a moment there I thought I had a potential problem in my hands... :-)

>
>Reading dba_free_space for LMT's is not much
>more expensive (usually) than the same task
>for dictionary managed tablespaces. Reading
>dba_extents usually is.
>

Hu-huh. Vewy interesting! Definitely agrees with what I'm seeing in NT 8.1.6. All is explained now.

Thanx muchly.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Mon May 07 2001 - 07:45:56 CDT