Home » RDBMS Server » Server Administration » objects cannot extend
objects cannot extend [message #197173] Tue, 10 October 2006 06:07 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi

how can i Check for objects(tables) which cannot extend

thanxs



Re: objects cannot extend [message #197205 is a reply to message #197173] Tue, 10 October 2006 08:35 Go to previous messageGo to next message
joy_division
Messages: 4640
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 Go to previous message
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.
Previous Topic: SHARED SERVER TO DEDICATED CONNECTIONS
Next Topic: ORA-01157 on database startup
Goto Forum:
  


Current Time: Sat Dec 03 22:21:52 CST 2016

Total time taken to generate the page: 0.14636 seconds