Home » RDBMS Server » Server Administration » Tablespace Fragmentation
Tablespace Fragmentation [message #49822] Tue, 12 February 2002 05:23 Go to next message
Marks
Messages: 11
Registered: February 2002
Junior Member
What views can I use to identify which segments
are causing fragmentation in a tablespace.
I guess I'll need to select file#,block_no,segment_name
and order by file#,block_no

But where from ?

I am using Oracle 7.3.4. and 8.1.7.
Re: Tablespace Fragmentation [message #49825 is a reply to message #49822] Tue, 12 February 2002 06:30 Go to previous messageGo to next message
Craig
Messages: 28
Registered: October 2001
Junior Member
v$filestat v$dbfile

HTH
Re: Tablespace Fragmentation [message #51086 is a reply to message #49822] Wed, 24 April 2002 05:47 Go to previous message
Seddaoui Karim
Messages: 1
Registered: April 2002
Junior Member
I would like to write scripts which permit to detect which objects may be reorganised.
Could you please send me percentage concerning threshold or tell me how to detect that a tablespace is fragmented ?
Could you please give me threshold concerning objects(tables , indexes ...) which would show that this objects may be reorganised.

Appreciate your help.

mail to seddaouikarim@hotmail.com
Previous Topic: Query to Retrieve top 3 salaries persons.
Next Topic: Re: Encryption:dbms_obfuscation_toolkit
Goto Forum:
  


Current Time: Wed Dec 25 09:08:45 CST 2024