| Auto Segment Management [message #61738] |
Sun, 23 May 2004 20:08  |
IA
Messages: 91
Registered: March 2004
|
Member |
|
|
Hi Everyone,
I was told by a friend that using Auto Segment Managment, adds roughly 10% extra space requirement on a typical database.
Is this true? At present, we have a project that is Terabytes in size. A 10% increase is not feasible, because it means we need to allocate another 1 Terabyte of disk.
Greatly appreciate your feedback on this question. Thanks ... IA
|
|
|
|
| Re: Auto Segment Management [message #61749 is a reply to message #61738] |
Mon, 24 May 2004 09:41  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
auto segment mamangemnt is just an algorithm - it doesn't carry an overhead. You can still control pctfree and pctused. pctfree=10 (default) sets aside 10% of usable block space for subsequent updates. If you won't be updating(or rowlength won't increase during updates) then you can reduce that as low as 0.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
