Re: Locally Managed Tablespaces - any cons???

"Robert Fazio" <rfazio_at_home.com.nospam> wrote in message news:8jXd7.100150$EP6.25414057_at_news1.rdc2.pa.home.com...
> > > > I disagree, I'm afraid. Locally managed temp tablespaces are
 strongly
> > > > supported and encouraged (indeed, in the 8i DBA course, the syntax
 example
> > > > for creating a TEMP tablespace is pure LMT... they don't even
 mention
 the
> > > > old, DMT, way of doing it.
> Ok, I have done some research on the subject. I spoke with one of my
 DBA's
> who recently went to the tuning class. They are teaching to use LMT's for
> the temp segments. The one issue that I couldn't clarify was are they
> suggesting that you use a regular or temporary tablespace that is locally
> managed? My guess is temporary, but she couldn't answer that question.
>

Locally managed temporary tablespace, created with tempfiles:

'create temporary tablespace TEMP tempfile '/bing/bong/blah/temp01.dbf' size 100m extent management local unform size Xm'.

> Using LMT makes sense, but I still have the concern, being bit by Oracle
> Bugs before, using it in my 24x7 databases.
>

I'm with you 100% there... though I think the things have settled down now in 8.1.7

[snip]

> This thread has been fun, and I will say your ideas have intriged me.
>
>

Ditto regards the thread. Cheers, Robert.

Regards
HJR Received on Tue Aug 14 2001 - 04:55:02 CDT