Hotsos Symposium Speaker – Mark Farnham

Mark Farnham is a new Hotsos Symposium presenter.


Mark FarnhamMark W. Farnham is a native of Dunkirk, NY where he attended public schools and enjoyed the rich musical and farming heritage of Chautauqua County. After graduating with a dual major in physics and biology from Dartmouth College in 1977, Mark became interested in computer science and database technology. Mark began using Oracle at DTSS in the late 1980's and helped Burlington Coat Factory Warehouse move from DTSS to Unix and Oracle from 1989 to 1994.

Mark was one of the founders of the OAUG and participated in Oracle's VLDB group and MOSES. In 1994, Mark co-founded Rightsizing, Inc. with Jerry Ireland where Mark continues as President to this day. Rightsizing helps businesses make smart use of Oracle technology, and Mark often is called upon when high throughput and massive migrations are involved.

Mark is a frequent contributor to oracle-l and is proud to be a member of the OakTable Network ( and co-founder of the APPSPERF consortium ( Mark continues his service to the OAUG as a board member of the OAUG DBSIG and was awarded the OAUG Lifetime Service Award in 2010.

Mark's handle on twitter and youtube is pudge1954, and he is pudge on OTN. His written papers on performance began in 1981 when he developed a pruning algorithm to solve best fits of piecewise linear regressions by excluding large ranges of the potential solution space early. (Respiration Physiology Volume 47 Issue 1, January 1982, pp 97-106). His public speaking on Oracle performance began at the 1990 IOUW in Anaheim, CA, speaking on managing many databases on many disk drives. Most recently, he presented at MOTS and OOW.

Mark is an Oracle Ace.

Presentation Title

Physical Ordering of Data: Is it ever Useful?


Certain operations, some small like lookup lists, and some large like batch jobs and reports, can perform better if the physical order of the data matches the predominant order of use. When is it worthwhile to attempt this ordering? How does ASSM affect the ability to physically order data? An expensive mission to periodically physically order all the data you have in the best possible order for the queries you expect to run on the data is silly. But if you verify that a one time complete or periodic partial physical ordering of some of your data will have a reasonable cost that is nearly certain to be exceeded many times over by the reduction in cost of future projected queries against a constrained resource, then it is not silly.

Presentation Materials

Presentation materials are available online to attendees only.


The speaker schedule is as follows: