?xml version="1.0" encoding="UTF-8"?> Hotsos Symposium Speakers and Abstracts

Hotsos Symposium Speaker – Shan Nawaz

Shan Nawaz is a new Hotsos Symposium presenter.

Biography

Shan NawazShan Nawaz is Senior Performance Engineer with more than fourteen years of experience managing various OLTP and data warehouse databases, including Oracle, DB2 and SQL Server, with various companies like VeriSign, Bank One, JP Morgan Chase, Fanniemae, and Crompton Corp/Uniroyal Tires.

For the last five years, Shan works as a Performance and Scalability Engineer with VeriSign. He has vast experience in tuning mission critical applications with millisecond SLA's. The audience will gain a lot from his experience in different database technologies supported by industry certifications in various database platforms and storage platforms (Oracle Certified Professional in 7.3/8/9i/10g/11g, an IBM Certified User specialist in DB2, MCP in SQL Server 2000 and EMC proven professional).

Shan is also a part-time instructor at George Mason University and a frequent speaker at various Oracle conferences. Some of his recent/future sessions are: Sangam 12 (India), Insync 2012 (Melbourne), IOUG 2012 (3 sessions), Oracle OpenWorld 2012, InSync 2011 (Sydney), Hotsos Symposium 2011, IOUG 2011, Oracle OpenWorld 2010, and VTS 2009.

Presentation Title

Can Old Roads Lead to a New Destination?

Abstract

With nearly every aspect of technology changing rapidly, it is perhaps odd that we have been slow to follow suit with best practices. There is no shortage of Oracle best practices, but the big question is: "Are some of them still relevant?" This presentation will go over some of the best Oracle performance tuning practices and explain why some of them are relevant or irrelevant today. At Verisign, we have millisecond SLA's and most of the findings are implemented without impacting our response times. Some of the lessons you will learn from this session are highly radical like:

  • Using RAID-6 or RAID-5 for redo logs instead of RAID-1.
  • Cut down on your bind variables to improve performance.
  • Rebuild your indexes to improve performance.
  • Do you really need to gather data statistics? If so, how often?
  • Multiplexing control file and redo log members; how much is too much?

In short, the argument is that best practices help, but it is always good to question a "best practice". Best practices were never meant to be "one size fits all".

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: