|
-
Whether it is parallel DML or parallel DDL, Oracle does release unused space only in the last extents of each parallel slaves, if DMT is used. If N is the number of extents for each slave, then Oracle does not release unused space in the (N-1) extents.
To aviod this, use minimum extent clause in the tablespace.
Set initial = next = min_extlen.
If the tablespace is already created, you can change by this command.
alter tablespace users minimum extent 5m;
Tamil
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
|
Reply With Quote