Re: OPTIMAL and LMT's

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 14 Nov 2001 05:57:26 +1100
Message-ID: <3bf16d2d$0$5065$afc38c87@news.optusnet.com.au>

OPTIMAL is never a good idea, whatever sort of tablespace you've got, if you value performance.

However, it can still be set in LMT, and if you really want to automatically have your rollback segments shrinking in the middle of transactions, it will still do its stuff. And the shrink when it happens will hurt transactions rather less than it would do in dictionary managed tablespace, because extent allocations and de-alocations is what LMT is particularly good at.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Gail Binkley" <gail_at_alberich.Stanford.EDU> wrote in message
news:9srl8a$nl6$1_at_usenet.Stanford.EDU...


> I have read that using locally managed tablespaces for rollback

> segment tablespaces is a good idea.  I was wondering if setting

> OPTIMAL is still relevant and/or recommended in LMT rollback segments.

> I haven't been able to find any reference to this combination in the

> literature.

>

> Thanks for your help,

>

> Gail Binkley

> gail_at_genome.stanford.edu

> --

> Department of Genetics        Phone: (650) 498-7145

> School of Medicine              Fax: (650) 723-7016

> Stanford University           Email: gail_at_genome.stanford.edu

> Stanford, CA 94305-5120         URL: http://genome-www.stanford.edu/

Received on Tue Nov 13 2001 - 12:57:26 CST