RE: DBA_HIST_SQLSTAT
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Tue, 20 Nov 2012 21:15:16 +0000
Message-ID: <DUB115-W121A1E9F71A6EED31C314FAA1550_at_phx.gbl>
Date: Tue, 20 Nov 2012 21:15:16 +0000
Message-ID: <DUB115-W121A1E9F71A6EED31C314FAA1550_at_phx.gbl>
Statements that differ by literals will have different sql ids. The sql id is just a hash of the sql statement. Statements that differ by literals may well have the same force_matching_signature.
There are many reasons for different child cursors - take a look at some of the reasons exposed in v$sql_shared_cursor.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 20 2012 - 22:15:16 CET