-
"segments are approaching maximum extents allowed in"
Hi All,
I got an error
"segments are approaching maximum extents allowed in"
so i used the script below to check it up but it returned no rows
any other way to check it up?????
select a.owner||'.'||a.segment_name "Sname",
a.segment_type "Stype",
a.bytes/1024/1024 "Size",
a.next_extent/1024/1024 "Next",
a.tablespace_name "TName"
from sys.dba_segments a
where a.tablespace_name not like 'T%MP%' -- Exclude TEMP tablespaces
and next_extent * 1 >= ( -- Cannot extend 1x, can change to 2x...
select max(b.bytes)
from dba_free_space b
where a.tablespace_name = b.tablespace_name)
order by 3 desc
-
Hi
where did u get this error
segments are approaching maximum extents allowed in
regards
Hrishy
-
Is there no corresponding ORA-error number?
--curious-- haven't encountered/heared such kind.
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
|