|
-
FREELISTS 97....You must be kidding.
No, it is!! Is it good or has negative impact? If negative why?
It is hard to determine the SIZE value in the cluster unless you know the total number of rows.
Approx 2900 Million records - which is allmost 560GB actual segment size.
If you want still to use cluster, then create a temp table in a sorted order of the cluster key, then re-insert them into cluster agian with suitable SIZE vlaue.
presently, there is a back log of old data. First I would like to purge those. The issue is
1. Export is hanging!! (Any solution)
2. Trunacte is taking unreasonably long time. (Any suggestion to make it fast)
3. Doubt of fragmentation too.
I will post you the cluster definition soon.
Regards
sumit
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
|