On the sybase-l mailing list,
Sybase
Jeff Tallman replied to a question on how to avoid unnecessary reorgs. He graciously agreed to let me post his response here 
You can avoid most (if not all) of the reorgs by doing:
- setting the exp_row_size to something that covers about 90% of the space each row takes up
- changing enable housekeeper GC to a 4 or 5
Both of these are a *MUST* do for DOL (datapages or datarows). See manuals on ‘enable housekeeper GC’ for correct setting of 4 or 5 (refers to whether deletes are batch or OLTP).
You can also watch for housekeeper overflows in monEngine/monOpenObjectActivity……and if you see any HKGC pending – wait a few before shutting down.
Jeff wrote up an excellent article, Locking Redux – APL vs. DOL and Tuning, that goes into detail why this is the case.
« How to change the default NLS_DATE_FORMAT (Date format) in Oracle 10g/11g Howto: Unable to start Catalyst web applications using the built in development server? We have the answer »
Hi Jason,
This is slightly off the topic of your post, but would you happen to know where I can find the Techwave presentations for 2006, 2007, 2008, and 2009? The official link to http://www.sybase.com/techwave/conference_content only contains presentations through 2005. No help from the forums at all.
Thanks!
2008 – http://www.sybase.com/detail?id=1069518&siteId=1
For 2009 & 2007, you need to get it from ISUG (http://my.isug.com).
Hi Jason,
How are you and very long time, hope you remember me , am your ex mate in UBS
hope your doing good and i would like to access the below docs. please help me to get this, due have tried to click on the above link but i can’t get it
Ref :
Jeff wrote up an excellent article, Locking Redux – APL vs. DOL and Tuning, that goes into detail why this is the case.
cheers,
Gopal
Locking Redux – APL vs. DOL and Tuning