|
-
Because with pctincrease > 0 you start get all funny extent sizes and not multiple of sort_area_size
I dont see why you need to coalesce if you set your initial = next? Also what's the bad experience? We have been using locally managed temporary tablespace in production for over 2 years with no problems....
Also check your queries, you might have some queries using sort merge join or carteasian product
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
|