NYOUG 2018 Summer General Meeting: Database Health with Raspberry Pi
Database Health with Raspberry Pi
Learn some of the tips and techniques of successfully managing a database infrastructure in the real world. How is the database performing now? It’s a question you must have been asked more than once and what were their reaction when you rattled off multiple metrics to reflect a comprehensive load profile of the database? Perhaps their eyes glazed over. In this session you will learn how to build a tool based on Oracle internal metrics to present a single number for database performance (called DBIndex), similar to stock market index, to show an objective assessment of the database load at any point in time. Anyone can understand it and make inferences. You will also learn how to display that information visually with a LED on a Raspberry Pi device with a bit of python code, some open source tools and a little elbow grease
to make a useful device that puts to rest the questions like why the database is slow.
Arup Nanda is the VP of Database Services and Chief Data Officer of Priceline, a US$ 100B New York area company providing of travel services with brands such as priceline.com, booking.com, kayak.com, etc. He has been working in the data and analytic space for 23 years, touching all aspects of data management including relational, non-relational, big data, caching technologies and data sciences. He won two prestigious awards from Oracle Corp: DBA of the Year in 2003 and Architect of the Year in 2012. He has written 6 books, about 700 published articles, 500 presentations around the world and blogs at arup.blogspot.com.