10 times better performance with BINARY data-types!

  • Posted on: 11 April 2013
  • By: milina.ristic
Publish Date: 
1 Apr 2013
All PL/SQL developers will be conversant with the NUMBER datatype. However in recent database versions, Oracle have made available the native CPU arithmetic - hardware arithmetic. Hardware arithmetic is utilised through the BINARY_FLOAT, BINARY_DOUBLE, and BINARY_INTEGER datatypes. This presentation will outline how to achieve performance gains ranging from 50%, double, 5 times, and even 10 times - WITHOUT TUNING!!! When was the last time you achieved a 10 times performance increase without new hardware, and without doing any tuning?
Paul Guerin
Presenter Biography: 
Over 20+ years in information technology, with >15 as an Oracle Database Administrator, and now working for the Enterprise Services division of Hewlett-Packard Australia, after careers with Origin Energy, Bluescope Steel, and BHP Billiton. Hewlett-Packard is one of the largest IT companies in the world and employs 6000 in Australia alone. Currently administering complex energy trading, modeling, settlements, and reporting systems that operate 24*7, with some that are over 1TB. With a special interest in performance tuning, scalability, and capacity right-sizing. His latest research has examined index inefficiency, and holistic approaches to capacity planning. As an advocate for database administration that achieves significant business outcomes, a number of high value projects were initiated: - performance tuning that reduced CPU utilisation by 50% - capacity right sizing that saved $250K over 2 years More recently he has presented at the leading Oracle events in the Asia-Pacific region - InSync11 (Sydney, 2011), and 2020 Foresight (Perth, 2012). Other presentations have been delivered to the Sydney Oracle Meetup user group (http://www.sydneyoracle.com.au/) regarding performance tuning and capacity planning. Also holds a Bachelor of Engineering (Computer) and an Oracle Certified Professional DBA, with a background in automation engineering. Based in Sydney. In 2003 summitted the highest mountain in the Southern hemisphere (Aconcagua - 6962m), and attempted the world's highest volcano (Ojos Del Salado - 6891m) in 2008. Completed the 100km Sydney Oxfam Trailwalker within 48 hours in 2010.