Cursor sharing

From: vsevolod afanassiev <>
Date: Thu, 22 May 2014 02:04:14 -0700 (PDT)
Message-ID: <>

We have busy production database ( 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

Original text of this message