Re: Temporary tablespaces using tempfile and concurrent insert/update
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- Date: Tue, 28 Feb 2006 01:37:46 GMT
On Mon, 27 Feb 2006 15:54:06 -0800, Noons wrote:
You're confusing extent management (LMT) with segment management.
You need the latter to get rid of freelist management issues.
It's the SEGMENT SPACE MANAGEMENT [AUTO|MANUAL] option
of CREATE TABLESPACE.
One can not create ass managed (thanks, Pete S.!) temporary tablespaces:
1 create temporary tablespace temp1
2 extent management local uniform size 4M
3* segment space management auto
SQL> /
segment space management auto
*
ERROR at line 3:
ORA-30573: AUTO segment space management not valid for this type of tablespace
As you can see, Oracle kicks ass right out of the picture for the
temporary tablespaces. If anyone finds my language objectionable,
I'm not a native English speaker and my English is sometimes ridden
with mistakes.
--
http://www.mgogala.com
.
- References:
- Prev by Date: finding ranges and gaps in the range
- Next by Date: Re: lots of waiting on 'db file parallel write'
- Previous by thread: Re: Temporary tablespaces using tempfile and concurrent insert/update
- Next by thread: Re: Temporary tablespaces using tempfile and concurrent insert/update
- Index(es):
Relevant Pages
|
