objects reaching max extents SQL QUERY
8.1.7 - linux
OBJECTIVE - to find out the whether the table has reached max extents or not.
is this correct SQL query which will show me current extent & max extent of a table.
select EXTENTS,MAX_EXTENTS from dba_segments where tablespace_name='PRONTOMSP' and segment_name='PRONTO_GATEWAY_SESSION';
Yes, what you've done is correct.
Your segment's Max Extents are set to unlimited in your case i.e. 2147483645.
You might want to add the OWNER = to be more specific should you have multiple schemas which the same objects. (Although, obviously not in this case)
Last edited by grjohnson; 02-16-2005 at 01:50 AM.
OCP 8i, 9i DBA
Thanks a lot for the reply
Click Here to Expand Forum to Full Width