Santosh's Oracle DBA Blog
For Oracle DBA begineers
Pages
Home
Monday, 4 March 2013
How to check segments approaching max extents
col
segment_name format a40
select
owner
,
segment_type
,
segment_name
,
max_extents - extents as "spare"
,
max_extents
from
dba_segments
where
owner not in ('SYS','SYSTEM')
and
(max_extents - extents) < 10
order by 4
/
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment