OraFAQ Forum: Server Administration » objects cannot extend

Home » RDBMS Server » Server Administration » objects cannot extend

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

objects cannot extend [message #197173]

Tue, 10 October 2006 06:07

oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka

Senior Member

hi

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

thanxs

Report message to a moderator

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
/

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	SHARED SERVER TO DEDICATED CONNECTIONS
Next Topic:	ORA-01157 on database startup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 14:05:53 CST 2025