Message-ID: <F001.005DAEBD.20031223230425@fatcity.com>
Date: Tue, 23 Dec 2003 23:04:25 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Subject: Re: STATSPACK interpretation
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


Thanks for the information - that test has
been on my TODO list for the last couple
of years.   Apart from being useful information,
it also tells us that it's not the OP's problem,
as the number of different possibilities is too
low.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person 
  who can answer the questions, but the 
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


----- Original Message ----- 
To: "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sent: Tuesday, December 23, 2003 11:44 PM


> Thanks, Jonathan.
> Of course you are right :-)
> 
> Playing with this a little longer, I can get up to 4
> versions (child_number from 0 to 3) of the same pl/sql
> cursor by changing bind variable sizes. It ceases
> being sharable when bv size changes from 32 to 33,
> from 128 to 129 and from 2000 to 2001:
> 
> 1-32
> 33-128
> 129-2000
> 2001-4000
> 
> I wonder if this behavior can be changed by some init
> settings?
> 
> Thanks,
> Boris Dali.
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan@jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).