| URGENCY!!!!!!!!!Defragmentatation of a Oracle Tablespace [message #76196] |
Wed, 03 October 2001 00:34  |
Lena Pilloni
Messages: 5
Registered: October 2001
|
Junior Member |
|
|
Hi,
I'v encountered a problem : I need to defragment a Oracle tablespace, but the usual method to exporting the database and importing it does not have any result.The index of defragmentation is always the same !
I've execute this query to retrive the defragmentation index :
"select tablespace_name,
sqrt(max(blocks)/sum(blocks))*(100/sqrt(sqrt(count(blocks)))) Frammentazione
from dba_free_space
group by tablespace_name
order by 1".
The results has been :
_"TABLESPACE_NAME","FRAMMENTAZIONE"
"BENQUAL_IDX","35.3699869774981"
"BENQUAL_TAB","65.762521320816"
"IEFSENCY_IDX","78.5440222249267"
"IEFSENCY_ROLL","28.5639488447158"
"IEFSENCY_TAB","23.603774521512"
"IEFSENCY_TEMP","59.4603557501361"
"SYSTEM","100" _
I need urgently help .................!!!!!!!!!!!
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
