> Presentations >

  Cursors, Child Cursors, and More (GLOC 2013 Presentation)


Product Code: 2013_GLOC_CURSORS

To download click here.

This presentation was given by Craig Shallahamer on 14-May-2013 at the GLOC conference. You may notice this presentation posted for a number of difference conferences. Usually you want to download the recent version.

Presentation Title:Cursors, child cursors, and more child cursors

Abstract: Learn about Oracle library cache internals focusing on cursors and child cursors. Multiple child cursors is essential for many applications but when hundreds or thousands are created massive performance problems can occur. We'll cover how multiple child cursors occurs, how to detect if it's a problem, and what to do about it.

The topics include:
- What is a cursor?
- Parsing... How bad is bad?
- Hashing and hash structures
- Parent and child relationships
- Find a suitable child cursor
- Creating a parent cursor
- Creating a child cursor
- Problems with too many child cursors
- Detailing and creating a bind mismatch situation
- How to limit child cursors, including patch #10187168 in
- Serialization control via mutexes (e.g., cursor: pin s)
- Wait time and the OS administrator
- Determining the average and typical wait time numerically and visually

Some of the views we look at is v$sql, v$sql_shared_cursor, v$system_event.

Share your knowledge of this product with other customers... Be the first to write a review

Browse for more products in the same category as this item:


view my cart my account my support contact us about us        

                                Built with Volusion                                                                 To receive OraPub's Newsletter »