Cursor sharing
From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Thu, 22 May 2014 02:04:14 -0700 (PDT)
Message-ID: <7775700c-f856-46b9-97c0-6e3d047f62a2_at_googlegroups.com>
We have busy production database (9.2.0.8) where parameter cursor_sharing is set to similar. Naturally V$SQL shows many SQL statements where literals were replaced with binds in the form "SYS_B_00". However V$SQL also shows SQL statements where this conversion didn't happen, i.e. literal values are still visible (FIRST_NAME = 'JONN' etc). Is it because they were executed from sessions where the value of cursor_sharing was changed at the session level? Or there could be another reason why cursor sharing didn't happen? Received on Thu May 22 2014 - 11:04:14 CEST
Date: Thu, 22 May 2014 02:04:14 -0700 (PDT)
Message-ID: <7775700c-f856-46b9-97c0-6e3d047f62a2_at_googlegroups.com>
We have busy production database (9.2.0.8) where parameter cursor_sharing is set to similar. Naturally V$SQL shows many SQL statements where literals were replaced with binds in the form "SYS_B_00". However V$SQL also shows SQL statements where this conversion didn't happen, i.e. literal values are still visible (FIRST_NAME = 'JONN' etc). Is it because they were executed from sessions where the value of cursor_sharing was changed at the session level? Or there could be another reason why cursor sharing didn't happen? Received on Thu May 22 2014 - 11:04:14 CEST