Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: About TEMPFILE creation

Re: About TEMPFILE creation

From: <yong321_at_yahoo.com>
Date: 12 Mar 2007 07:35:00 -0700
Message-ID: <1173710100.434522.144110@c51g2000cwc.googlegroups.com> 





On Mar 10, 1:32 am, "Mark D Powell" <Mark.Pow..._at_eds.com> wrote:


> Tempfile usage also reduces the amount of redo generated

> and 'ST' lock activity.

>

> HTH -- Mark D Powell --




I'm curious about this detail. Although DMT temporary tablespace is
logging as reported by dba_tablespaces while LMT temp TS is nologging,
all temporary segments are nologging. Why is there less redo in the
latter case?



Yong Huang
Received on Mon Mar 12 2007 - 09:35:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US