| max_extents almost reached [message #53775] |
Thu, 10 October 2002 08:58  |
JOHN
Messages: 182
Registered: April 1998
|
Senior Member |
|
|
Hi, I hope someone can help me here. It's probably a simple issue, but I am not sure how to handle it.
One of my largest tables in 8 (8.0.6.1.0 EE) is now at 970 extents. The max_extents is 1024.
Can I just alter the storage clause of this table with a new maxextents or are there some pittfalls in doiing that?
Thanks in advance !
|
|
|
|
| Re: max_extents almost reached [message #53779 is a reply to message #53775] |
Thu, 10 October 2002 14:12  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
You can change the max extents to unlimited if you want - there is no problem at all. 970 extents is getting kind of high, but there is no need to panic. You should consider setting next_extent to a larger value to prevent having too many small extents. There is overhead in allocating extents(and releasing extents when you drop or truncate).
alter table A storage(next 1M maxextents null);
select table_name, next_extent, max_extents
from user_tables where table_name = 'A';
A 1048576 2147483645
|
|
|
|
|
|
| Re: max_extents almost reached [message #53817 is a reply to message #53775] |
Sun, 13 October 2002 12:11 |
JOHN
Messages: 182
Registered: April 1998
|
Senior Member |
|
|
Thank you both a lot for your comments !
I can sleep well now for this matter!
I just did what you both suggested, and oracle took it like a glass of beer. Thanks!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
