Re: What is fragmentation in databases ?

On Thu, 1 May 1997 09:17:05 GMT, smp <> wrote:

Could you give us the contact directions (web address, e-mail, phone or snail-mail address) of this company? I want to take a look at this product.

Thanks.

>
>
>>==========Atif Ahmad Khan, 26/04/97==========
>>
>>
>>I was flipping through the pages of the latest Oracle magazine
>>and saw an ad that offered a product to address the fragmentation
>>problem in database servers by ARIS (DFRAG 5.0- Page 37). I am
>>not sure what fragmentation in databases is and what this product
>>does. Does anybody know ? Just curious.
>>
>>Atif Khan
>>aak2_at_ra.msstate.edu
>>
>Hi,
> We use ARIS DFRAG for our Oracle Financials database. It is a tool
>which can be used to report on fragmentation, numbers of extents, chaining of
>indexes etc.
>It can be run GUI, from forms 3 or in character mode on the server.
>It will give a graphical report of exactly where in datafiles the table
>segments are.
>It can be used to coalesce free space (we run oracle 7.1.3), to rebuild tables
>(and
>associated indexes) online (ie while the users are logged in) or offline, it
>can be
>running while you aren't there - (no more weekends at work)and, best of all
>from
>my point of view, it will rebuild complete tablespaces, without the pain of
>export
>and import. It tells you what is happening as it does it and it is pretty
>robust. I've
>had dealings with the company directly as to use the product we had to get
>them
>to port it to our flavour of Unix and they were very helpful. They are based
>in Seattle
> and we are in Scotland but the time difference didn't make any difference to
>them.
> The product isn't too expensive either.
> (no I don't work for them I'm just happy to have a tool that works!)
>
>Sally Pearce
>Financials DBA(for my sins)

• Dalton M. de Andrade - Montreal, Canada *
• d_andrade_at_vir.com dandrade_at_icao.org *

  ---