This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
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.

 





 

Speakers

 

 

Neil Chandler

@ChandlerDBA

neil@chandler.uk.com

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.