|UKOUG Database Stats. Doing it Right, the Easy Way Webinar|
Database Stats. Doing it Right, the Easy Way - Webinar
25 April 2019, 12:00 - 13:00
Oracle Statistics are critical to the optimizer and your system performance, whether on-premises, in the Cloud or Autonomous. If your statistics do not reflect your data, the optimizer will be working with incorrect assumptions and you may get poor execution plans. Your stats are always wrong. They contain estimates, guesses, assumptions and analysis of partial data samples. This talk will show my preferred approach to gathering database stats, ensuring you have the best stats that you reasonably can for your data and keeping your execution plans stable and accurate.
Database Guy. Knows things. Neil has been working in IT since 1988 initially as an Assembler Programmer on IBM Mainframes. He started working with Oracle v6 sometime around 1991.He has managed global DBA and Development teams and is currently an independent Database Architect, specialising in Performance, RAC, Goldengate and DataGuard. As well as Oracle, he has extensive experience using other relational and NoSQL database technologies and has administered most flavours of Unix. Neil is an Oracle ACE Director and a board member of the UK Oracle User Group.