a table as a temporary table, when I load the data into the table, after other operation,I will delete all records. thus can fragement, how can I find the fragement level of the user schemas and how to eliminate the fragements!
After you delete all records, the index will be fragmental but table. You can rebuild index, but I think it is not a good idea to create index in a temp table which will be reloaded frequently.
To find the fragment level of an index, monitoring an index's efficiency of space usage using INDEX_STATS at regular intervals by first analyzing the index's structure.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
a table as a temporary table, when I load the data into the table, after other operation,I will delete all records. thus can fragement, how can I find the fragement level of the user schemas and how to eliminate the fragements!
please help me!
Do you have any other objects in that tablespace? Instead of delete you can truncate the table and coalesce tablespace.
Truncate table with keeping storage, then the tablespace will not get fragmental if there are same amount of data that will be loaded everytime.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
Originally posted by Calvin_Qiu Truncate table with keeping storage, then the tablespace will not get fragmental if there are same amount of data that will be loaded everytime.
Reply With Quote
Bookmarks