Re: OPTIMAL and LMT's

Gail Binkley wrote:
>
> 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/

Optimal doesn't have any great relationship to lmt's versus dictionary managed. There are pretty much two schools of thought on optimal:

1. use it
2. use a manual equivalent (alter rollback ... shrink) at a quiet time.

I prefer the latter

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."