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

Thread: Next Extent Fail

  1. #1
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    I have the following script to identify the segments having trouble in throwing next extent.

    SELECT
    seg.owner,
    seg.segment_name,
    seg.segment_type,
    seg.tablespace_name,
    seg.next_extent/1024 next_extent
    FROM dba_segments seg
    WHERE seg.next_extent IS NOT NULL
    AND NOT EXISTS
    (select tablespace_name
    from dba_free_space free
    where free.tablespace_name = seg.tablespace_name
    and bytes >= seg.next_extent)

    I am not sure if there is any fault with this script. I configured this script to run every 12hrs on one of my databases and email me with the results. Last friday one of the object failed in allocating the next extent and this script never warned me.

    I would really appreciate your help.

    Thanks in Advance.

  2. #2
    Join Date
    May 2002
    Location
    England
    Posts
    78
    I have just tried your script here and it runs fine, I know I have some extents in my database which is fail and it selects them fine.

    what are you using to run the script every 12 hours? and on what platform?


  3. #3
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    I configured this through OEM to run for every 12 hours. The OMS (2.2.0.0.0) is on a Linux Box and the Target DB is on a Sun Box.

    Thanks

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