Re: Cursor sharing

From: vsevolod afanassiev <>
Date: Thu, 22 May 2014 16:30:33 -0700 (PDT)
Message-ID: <>

Thanks, unfortunately this is, 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