imran_fast
asked on
Tablespace
Is there any way to check the fragmentation of a tablespace or a table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try this..
SELECT tablespace_name,COUNT(*) AS fragments,
SUM(bytes) AS total,
MAX(bytes) AS largest
FROM dba_free_space
GROUP BY tablespace_name;
SELECT tablespace_name,COUNT(*) AS fragments,
SUM(bytes) AS total,
MAX(bytes) AS largest
FROM dba_free_space
GROUP BY tablespace_name;
ASKER
thanks for the input put actually this is what i was looking for any how thanks again.
http://asktom.oracle.com/pls/ask/f?p=4950:8:5421856784324441110::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1295801859138