DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: objects reaching max extents SQL QUERY

Hybrid View

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    objects reaching max extents SQL QUERY

    hi

    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';

    EXTENTS MAX_EXTENTS
    ---------- -----------
    88 2147483645

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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 02:50 AM.
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    john

    Thanks a lot for the reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width