-
Data Archiving & Deletion
Hello,
In our database, we have archived and archived and delete a huge amount of data from several large tables.
Somehow, this deletion did not generate enough freespace. Based on our calculation this deletion process should generated alteast 10GB of freespace.
Scale: Day Database
Date Values Size/kb Free/kb
------------------------------------------------------
09/29/2004 Total 293621,400 74,342,880
09/28/2004 Total 293621,400 73,377,248
Is there any better way of finding the exact freespace in the database?
Thanks,
Nikee
-
Did you "ALTER TABLE MOVE" your tables?
Jeff Hunter
-
Hello Jeff,
We have our own front end application.
While archiving the data, we have dumped the data in a proper order from the database.
After successful completion of this archiving process, we have deleted the data from the application using the DELETE command.
Thanks,
Nikee
-Nikee
-
Just because you have deleted records from your tables does not mean they will shrink. http://download-west.oracle.com/docs...k.htm#CNCPT301
Jeff Hunter
-
Use this query:
PHP Code:
select
( select blocks from user_segments
where segment_name = 'T2') ALLOCATED_BLOCKS,
( select count(distinct(dbms_rowid.rowid_block_number(rowid)))
from T2) USED_BLOCKS
FROM DUAL;
ALLOCATED_BLOCKS USED_BLOCKS
---------------- -----------
384 139
OR You can use DBMS_SPACE PKG.
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|