Effects of framentation

From: Murat Balkas <murat.balkas_at_o2.com.tr>
Date: 28 Jan 2004 07:04:00 -0800
Message-ID: <b1148377.0401280704.16ecd1fe@posting.google.com>

Hi,

my platform is : RedHat, Oracle 8.1.7

We're hosting an application server and the database of our customer. We're not responsible of the database users's objects. Nowadays the site is terribly slow. I've noticed that all the tables and indexes of the user are put in one tablespace and almost all objects ( including tables,indexes,... ) in this tablesapce are fragmented over %60.

I thnik the problem is about these fragmented objects and some of their queries.

I need to prove that the cause of the slowness is the fragmented objects and will advise rebuilding them. They'll do that work.

How can I do that? How can I prove that queries answer too slow because of the fragmentation.

Any help would be greatly appreciated,

Murat Received on Wed Jan 28 2004 - 09:04:00 CST