|
-
Originally posted by pando
select * from dba_segments where next_extent > 38400 * db_block_size
and see what's the segment causing the problem
Thanks pando.
select segment_name,segment_type from dba_segments where next_extent >= (38400 * 8192)
SEGMENT_NAME SEGMENT_TYPE
-------------------------------------------
SYS_IL0000011225C00004$$ LOBINDEX
SYS_IL0000010344C00005$$ LOBINDEX
SYS_LOB0000011225C00004$$ LOBSEGMENT
SYS_LOB0000010344C00005$$ LOBSEGMENT
Thanks In Advance.
Nagesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|