Re: Cursor sharing

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Thu, 22 May 2014 16:30:33 -0700 (PDT)
Message-ID: <428b2788-0d8b-42c1-9c45-dbbac36b18e4_at_googlegroups.com>


Thanks, unfortunately this is 9.2.0.8, it doesn't have v$ses_optimizer_env.

I am seeing many other ALTER SESSION statements in V$SQL:

alter session set NLS_DATE_FORMAT='DD/MON/RR HH24:MI:SS' ALTER SESSION SET TIME_ZONE='Australia/Sydney' NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AUSTRALIA' alter session set hash_area_size=1048576 ALTER SESSION SET ISOLATION_LEVEL = READ COMMITTED So one would think that ALTER SESSION SET CURSOR SHARING should also appear in V$SQL Received on Fri May 23 2014 - 01:30:33 CEST

Original text of this message