One DELETE – many performance problems.

One DELETE – many performance problems.

In this session I will show you how bad design decisions can affect the system performance for years. In this example, one simple DELETE managed to destroy Buffer Cache and Shared Pool at the same time! Millions of consistent gets and hundreds of thousands child cursors caused massive production problems that couldn’t be solved with a simple parameter change.

In this session, we will analyze the AWR/Statspack reports and I will jump into Buffer Cache and Library Cache internals – but just a bit.

About Kamil

Owner of the ORA-600 [Database Whisperers sp. z o. o. sp. k.] company and blogger.
Founder of Pint with Oracle User Group.

Personally a big fan of Terry Pratchett: “Wisdom comes from experience. Experience is often a result of lack of wisdom.”