|
-
My system is too busy and ASSM doesn't handle it right. I have 45% better performance with manual freelists.
My table/index structure is PCTFREE 60 INITRANS 90 MAXTRANS 255 STORAGE (INITIAL 160M NEXT 160M FREELIST GROUPS 7 FREELISTS 20 )
for 5 heavy inserted tables.
How much more I could bumped it up?
Thanks a lot, mj
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
|