Home » RDBMS Server » Server Administration » how to avoid and see a fragment database
how to avoid and see a fragment database [message #56457] Tue, 01 April 2003 08:36 Go to next message
Teresa
Messages: 36
Registered: May 2002
Member
Can somone please tell me how can I see if a database is fragmented and how to avoid it ... I believe that to avoid one needs to set up the extents at the tablespace level, which means that if a table has more extents will be better ?

Report message to a moderator

Re: how to avoid and see a fragment database [message #56496 is a reply to message #56457] Thu, 03 April 2003 13:40 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Database is composed of tablespaces and which one of them is hosting tables, indexes and other segments. Which one of those three you are intersted into? Not clear from your post.

Anyway, here are the scripts for monitoring the fragmentation:

Segment fragmentation

Segment fragmentation

> Index fragmentation

Tablespace fragmentation (third query)

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: How to convert ISO-8859-1 charset data to UTF-8 charset data?
Next Topic: Help in server architecture
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:39:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.