1. A computer implemented method for managing cursors in a database system that is executable by a processor, comprising: creating a structure to track sharable cursors in the database system, wherein the structure includes a diagnostic node associated with a child cursor, wherein the diagnostic node comprises information regarding why the child cursor is not sharable or why the child cursor was created instead of re-using a pre-exiting child cursor; and storing the structure in a computer readable medium.