-
Temp tablespace and LOGGING/NOLOGGING
Just hear me out with this.
I would imagine that any blocks altered when sorting in the TEMP tabalespace would never be (or don't need to) written as REDO. So why can you create a TEMP TBS with the LOGGING option?
I've got a DB that generates REDO all night when theres little or no DML. It could just be REDO generated by the use of the TEMP TBS as it has the LOGGING option set to LOGGING.
(This is 8.1.5 on Windows NT4)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|