Re: Max Extents Scripts

From: Henryk Galuhn <galuhn_at_comarch.pl>
Date: Wed, 26 Jan 2000 16:02:04 GMT
Message-ID: <388F18D1.33B6FDDB@comarch.pl>

Lee Broders wrote:
>
> Does anyone have a script that will check if any of the table extents are
> nearing max_extent
> Please

Something like this?

select *
  from dba_segments
where owner = 'OWNER'

    and segment_name = 'TABLE_NAME'
    and (extents*1.22)>max_extents --percent     --and (extents+2)>=max_extents --count

--

     _  _  
    | || |___ _ _  _ _ _  _        _
    | __ / -_) ' \| '_| || |     _|_|_
    |_||_\___|_||_|_|  \_, |     (. .)

tel. +48 601 67-63-82 |__/ -ooO--(_)--Ooo- Received on Wed Jan 26 2000 - 10:02:04 CST