Printable View
dear all:
solaris and oracle version 8.1.6.3
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!
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.
Do you have any other objects in that tablespace? Instead of delete you can truncate the table and coalesce tablespace.Quote:
Originally posted by joyloce
dear all:
solaris and oracle version 8.1.6.3
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!
Sanjay
Truncate table with keeping storage, then the tablespace will not get fragmental if there are same amount of data that will be loaded everytime.
Quote:
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.
thank u ...