|
|
| Re: objects cannot extend [message #197205 is a reply to message #197173] |
Tue, 10 October 2006 08:35   |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
Here's one:
select a.segment_name,a.segment_type,a.bytes,a.next_extent,
a.tablespacE_name,c.max_bytes,a.extents
from dba_segments a,(select b.tablespace_name,max(bytes) max_bytes
from dba_free_space b
group by b.tablespace_name) c
where a.tablespace_name=c.tablespace_name
and a.next_extent>c.max_bytes
/
|
|
|
|
| Re: objects cannot extend [message #197209 is a reply to message #197173] |
Tue, 10 October 2006 08:41 |
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
|
Senior Member |
|
|
|
It might not be quite as simple as that because the tablespace may be set to auto-extend when it runs out of space. Also, the object won't be able to extend if there is not enough contiguous free space i.e. there could be lots of little blocks of free space all over the place which collectively add up to enough space for a next extent but, because they're not next to each other, Oracle wouldn't be able to use them.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
