Re: Why is this SQL not shared ?

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: 17 Nov 2001 11:47:30 -0800
Message-ID: <bde5777e.0111171147.1956e61c@posting.google.com>

I would check the following:
1. take address into account, multiple sql-statements (lexically)

can have the same hash-value.
2. check in v$sqlarea the sql with the highest number of child cursors,

attribute loaded_versions
3. If you are on 8.1.7 or higher, investigate v$sql_shared_cursor;

this view indicates for what reason there is no sharing possible.

Note that sharable memory in v$sqlarea is the sum for all the child cursors.

Kind Regards,

Herman de Boer. Received on Sat Nov 17 2001 - 13:47:30 CST