Re: temp tablespace

Thanks for the reply.
Someone asked me if they could turn off logging for their temporary tablespace and I could not answer the question.

It had never occurred to me before that the temporary tablespace was written to redo but I could not say for sure. If it was, then I couldnt see for what purpose but once again I did not know for sure. A good bit of temporary table info is written to redo but that is a little different. Even so, if temporary information from a table is written it seems possible that info from the tablespace could be. Both are temporary.

I am going to follow up on this and if I find out a definite answer I will let you know.

thanks,

clay

"No-spam poster" <cpclt_at_yahoo.com> wrote in message news:vsgi7.175473$TM5.32505859_at_typhoon.southeast.rr.com...
> Dan
>
> I don't know who you are, but you certainly don't know how to read and
> respond to news group posts. Instead of answering his question you decided
> to flame...in poor style no less.
>
> Clay, to answer your question. I am fairly certain that Oracle does not
> "log" the creation of temporary segments. Logically there is no reason to
do
> so because temp segments are not needed or used for recovery which is the
> primary purpose behind redo logs. Bottom line: I don't think it matters
> whether the temp tablespace is set to LOGGING or NO LOGGING creation of
temp
> segments is not logged.
>
> One unusual thing about temp segments is that once they are allocated in a
> running instance they are not deallocated until the database is recycled.
> They are shared and re-written among many transactions.
>
>
> "Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message
> news:3B898AC3.DA1E494C_at_attws.com...
> > Clay wrote:
> >
> > > Does a temporary tablespace need to be setup to allow logging?
> > > I know that redo information will be lost and it will be unrecoverable
> in
> > > case of failure, but why would you care with temp area???
> > > Why would you want to log the temp tablespace?
> > >
> > > clay
> >
> > A temporary tablespace needs to be set up to have an Oracle instance.
> >
> > If you don't know why you need a temp tablespace you know far too little
> to
> > even consider the kinds of questions you have floating in your mind.
> >
> > Get a good book on Oracle Architecture or a decent DBA book and start
> reading
> > it.
> >
> > To explain to you how far out in space you are would take a lot of time.
> >
> > Daniel A. Morgan
> >
>
>
>
Received on Sun Aug 26 2001 - 22:32:27 CDT