yong321_at_yahoo.com wrote:
> 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
What do you think "nologging" means? I recommend learning more at
asktom.oracle.com.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Mar 12 2007 - 10:34:47 CDT
