X-Received: by 10.183.11.102 with SMTP id eh6mr513695obd.37.1400801434356; Thu, 22 May 2014 16:30:34 -0700 (PDT) X-Received: by 10.50.59.179 with SMTP id a19mr554999igr.10.1400801434273; Thu, 22 May 2014 16:30:34 -0700 (PDT) Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!209.85.213.216.MISMATCH!c1no14268901igq.0!news-out.google.com!qf4ni5721igc.0!nntp.google.com!c1no14268890igq.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Thu, 22 May 2014 16:30:33 -0700 (PDT) In-Reply-To: <4ea7eaec-08f2-4425-b713-1ab245f0098a@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=203.13.128.104; posting-account=h2bfjgoAAAB8OxqMUJkSqT-KE-FeFQmL NNTP-Posting-Host: 203.13.128.104 References: <7775700c-f856-46b9-97c0-6e3d047f62a2@googlegroups.com> <3aa37734-9171-4e57-8af1-040d19788672@googlegroups.com> <4ea7eaec-08f2-4425-b713-1ab245f0098a@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <428b2788-0d8b-42c1-9c45-dbbac36b18e4@googlegroups.com> Subject: Re: Cursor sharing From: vsevolod afanassiev Injection-Date: Thu, 22 May 2014 23:30:34 +0000 Content-Type: text/plain; charset=ISO-8859-1 Xref: news.cambrium.nl 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