Re: Detect Fragmentation of a tablespace

On Thu, 23 Jul 1998 18:31:56 GMT, poohland_at_hotmail.com <poohland_at_hotmail.com> wrote:
>Hi!
>
>Is there any script that can help me to detect the fragmentation of a
>tablespace in order to decide whether I should rebuild it or not?
>
>Thank you very much in advance

There's one at http://support.oracle.com/MetaLink/libraries/est/oracle7/productReference/bulletins.html#SPACE and it may be on a SupportNotes CD too. Also, see some of the links on my page http://ourworld.compuserve.com/homepages/joel_garry/oracleln.htm

>
>Winnie Liu
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Jul 23 1998 - 18:01:39 CDT