Re: DBWR Performance.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 25 Jan 2000 21:34:20 -0000
Message-ID: <948836381.28385.1.nnrp-12.9e984b29@news.demon.co.uk>

Fragments correspond to extents, not segments. When the single instance segment is created it is only released when the instance is shut down. The segment is allowed an unlimited number of extents, which will all be the same size (and I think the default value of NEXT_EXTENT for the tablespace). The existence of a number of fragments doesn't really matter - although you want to avoid having more than a few hundred, as SMON does try to coalesce them at start up and can waste a lot of time. (There is an article about smon on my web-site which covers this point).

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

Bold wrote in message <388E0F20.A4F72072_at_yahoo.com>...
>One other additional thing which leads me to believe that segment requests
are
>being asked of and dropped within the temporary tablespace -- the
"Temporary"
>Tablespace is fragmented -- over 100 Tablespace Fragments.
>Back to work :-)
Received on Tue Jan 25 2000 - 15:34:20 CST