1. A computer implemented method for managing cursors in a database system that is executable by a processor, comprising: using at least one processor to perform a process, the process comprising: creating a structure to track sharable cursors in the database system, wherein the structure includes a diagnostic node associated with a pre-existing child cursor; and updating the diagnostic node to include information regarding why the pre-existing child cursor is not sharable for executing a query or why a child cursor was created instead of re-using the pre-existing child cursor to execute the query based at least in part upon a determination that the pre-existing child cursor is not to be shared for executing the query.