Home » RDBMS Server » Server Administration » fragmentation status of a tablespace
fragmentation status of a tablespace [message #56302] Tue, 18 March 2003 04:12 Go to next message
Walter
Messages: 15
Registered: September 1999
Junior Member
I need a script to can calculate the status of a tablespace. And more deeply the fragmentation.
Anyone can help me ? I work with Oracle 8.1.7.4.
thanks in advance
Walter

Report message to a moderator

Re: fragmentation status of a tablespace [message #56306 is a reply to message #56302] Tue, 18 March 2003 05:59 Go to previous messageGo to next message
Remi
Messages: 28
Registered: December 2002
Junior Member
Hi

You can look in DBA_FREE_SPACE, that contains a entry for every single free chunk in tablespace.

http://askremi.ora-0000.com

(are you a fan of AS ROMA !?, looking forward to wednesday AS ROMA-AJAX!?)

Remi

Report message to a moderator

Re: fragmentation status of a tablespace [message #56321 is a reply to message #56302] Wed, 19 March 2003 06:49 Go to previous message
Michel Bartov
Messages: 35
Registered: February 2003
Member
I Just posted an integrated set of GUI tools to manage, monitor and tune the Oracle database. One of the many functions is to display and maintain the database tablespaces.
You can select a tablespace and view all its attributes, including free space and number of fragments. You may then alter the tablespace, selecting ‘COALESCE’ option to fix the tablespace fragmentation. The link is http://www.barsoft.net/
You may need help to get started – please fill free to contact me at michelbartov@go.com.

Report message to a moderator

Previous Topic: select * from a cluster table in parallel mode
Next Topic: Transaction specific RollBack Segment
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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