Detecting objects that needs defragmentation due MAXEXTENT

Last update on July 3, 2009 09:54 AM by jak58
Published by jak58

Detecting objects that needs defragmentation due MAXEXTENT







To detect objects requiring defragmentation because of an overflow due to predefined MAXEXTENT, simply run the following command: 
SELECT SUBSTR(owner||'.'||segment_name,1,50) OBJECT,  EXTENTS, MAX_EXTENTS
FROM DBA_SEGMENTS
WHERE MAX_EXTENTS - EXTENTS < accepted_range
ORDER BY EXTENTS;


Note that the variable accepted_range represents the overflow we wish to detect (it may take a value of 4, 5 for example)
Best answers for « Detecting objects that needs defragmentation due MAXEXTENT » in :
Pls help me... i nid DETECTIVE DRIVERS KEY Show
Intrusion detection systems (IDS) Show Introduction to intrusion detection systems An IDS (Intrusion Detection System) is the term for a mechanism which quietly listens to network traffic in order to detect abnormal or suspicious activity, thereby reducing the risk of intrusion. There...
Object class and instance Show The concept of classes A class is the structure of an object, meaning the definition of all items that an object is made up of. An object is therefore the "result" of a class. In reality, an object is an instance of a class, which is why can use...
Command to detect your IP address! ShowCommand to detect your IP address! Command for Windows 2000 / XP / Vista Command for Windows 95/98 Command for Linux IP address (Internet Protocol) is a numerical identification to detect your computer on a network. It is used to...
Why Windows is not detecting the 4 GB of RAM installed? ShowWhy Windows is not detecting the 4 GB of RAM installed? What can be done? Conclusion Windows XP or Vista 32-bit edition can not use 4 GB, there is nothing to do, it is a mathematical limit. 32-bit system can address: 2 to the...
SanDisk Sansa Clip 2GB not detected ShowSanDisk Sansa Clip 2GB not detected Issue Solution Notes Issue My Sansa clip Mp3 is not recognized by y PC, I've tried all the USB ports on my PC, the results are still the same ... it does not appear on my desktop or in Windows USB...
Download Driver Detective ShowDescription Driver Detectiveis an application designed by Drivers Headquarters, Inc. This application will allow you between others to prove every time if you have last updates for the drivers of your equipments. Advantage The application...
Download Rpt Inspector Enterprise Suite for Business Objects XI r2 / Crystal Reports XI r2) Show
Download Object Fix Zip Show
The concept of objects ShowThe concept of objects Object-oriented programming consists of arranging data in modular sets of elements of real world information (called a domain. These data elements are called objects. This data is grouped according to the main real world...
Attack detection ShowAnalysing logs One of the best ways to detect intrusions is to monitor event logs (sometimes called logs for short). In general, servers store logs of their activity, and in particular any errors encountered, in files. Therefore, after a computer...
OOP - Data encapsulation ShowThe concept of encapsulation Encapsulation is a way of organising data and methods into a structure by concealing the the way the object is implemented, i.e. preventing access to data by any means other than those specified. Encapsulation...
They need your help