on 01-06-2011 4:12 AM
Hi,
We have archiving for some of the tables.I want to know whether is there any report which if we run then we can find out how much space we can reclaim.Thanks.
Please check the following SAP notes, it will provide you most of the information you need.
Note 541538 - FAQ: Reorganization
Note 821687 - FAQ: Space utilization and fragmentation in Oracle
Especially point 5 in note 821687: 5. How can I determine the scope of the different fragmentation types and the unused space?
Kind regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If it is very less count of tables then you can easily comare and get the exact difference that made.
Just check the size of particular table before archiving and post-archiving........The difference can give you exact figure of space.
Regards,
Nick Loy
Edited by: Nick Loy on Jan 7, 2011 7:46 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Purely depends on your archiving strategy and the tables where you are doing archiving.
Detailed query can help you and us better.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well if you delete half of a table's rows, then the table will be roughly be half the size after a reorg. Also the indexes will be much smaller. There is no report to exactly forecast your space spavings.
You could of course work with a few SQL statements to find possible candidates for a reorg. You can have a look at for an example.
Good luck, Michael
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.