The result of a parse operation is a parent cursor and a child cursor stored in the library cache. Obviously, the aim of storing them in a shared memory area is to allow their reutilization and thereby avoid hard parses. But when can they be reused?
The aim of this presentation is not only to discuss what parent and child cursors are but also, and foremost, to examine in what situations it is possible to reuse them. In doing so, topics such as bind variable peeking, bind variable graduation, adaptive cursor sharing and statistics feedback will be covered as well.
Speaker: Christian Antognini
Title: “Shareable Cursors”
Recorded on: Tuesday, May 5th 2020
Slides: