| Max_extents [message #51074] |
Tue, 23 April 2002 08:50  |
Nita
Messages: 34
Registered: March 2002
|
Member |
|
|
|
When a table is set for 200 max_extents, How do I find out what extent it is on now? Are we at the 1 extent, the 25, 100 etc.
|
|
|
|
| Re: Max_extents [message #51076 is a reply to message #51074] |
Tue, 23 April 2002 09:03  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
set linesize 132
set pagesize 100
column segment_name format a30
column segment_type format a30
column owner format a16
select
owner,segment_name,segment_type,extents
from
dba_segments
where
owner not in ('SYS','SYSTEM')
and
extents > 5
order by
owner,segment_type
/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
