How to Monitor fragmentation

From: oradba guess <oradba_guess_at_hotmail.com>
Date: Wed, 01 Nov 2000 14:25:43 PST
Message-Id: <10667.120879@fatcity.com>

Hi,

        In our datawarehouse application, there are certain tables where we do large deletes and inserts everyday. Frequently we see lot of performance problems with those tables. A query which was running fine yesterday doesn't run atall today. When we drop and recreate the table, the queries run fine.

It's probably because of the fragmentation. Any help on resolving this problems will be gratly appreciated.

thanks,

ora

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at http://profiles.msn.com. Received on Wed Nov 01 2000 - 16:25:43 CST